Re: [Sheflug] OOo and MySQL via ODBC

[Steve Tickle <xxxxx [at] xxxxxxxxxxxxxx>]

At 11:16 16/08/02 +0100, pwd wrote:

>At present, I haven't got OpenOffice on my system (not enough disk
>space!) so I can't experiment with this.
>
>I think what it's saying essentially is that most Windows apps use ODBC
>almost by default (as it's a Microsoft-developed
>protocol/(so-called)standard.) On the other hand, many, if not most,
>UNIX-based apps would connect to a database "natively", using a built-in
>API of some sort.
>
>If OpenOffice has "native" support for MySQL built into it, (may be the
>case, as MySQL seems rapidly to be becoming a de facto standard) then
>obviously you won't need ODBC. However, if it expects to access a
>database via a data source name only, then you do need the ODBC package.
>And in the solution which I used, the part which advertises the
>datasource names is libiodbc (it also uses the odbc.ini file approach.)

The connection options available in OOo are Adabas, dBase, ODBC, JDBC, 
Text, Spreadsheet and Addressbook so I suppose I need to use one of those.

I'll have a look at the MyODBC docs and see if anything is mentioned 
specifically about OOo.


Steve


___________________________________________________________________

Sheffield Linux User's Group -
http://www.sheflug.co.uk/mailfaq.html

  GNU the choice of a complete generation.