Re: [Sheflug] OOo and MySQL via ODBC

[Steve Tickle <xxxxx [at] xxxxxxxxxxxxxx>]

At 09:58 16/08/02 +0100, pwd wrote:

>I don't know unixODBC: however, I have in the past got MySQL/ODBC to
>work (I was developing an LDAP front-end for MySQL at the time.) The
>software I used was MyODBC and libiodbc: essentially, libiodbc is
>generic ODBC middleware for UNIX/Linux, and MyODBC is the specific ODBC
>driver for MySQL.
>
>If you want to have a look at them, libiodbc is at
>http://www.iodbc.org/software.htm and MyODBC is at
>http://www.mysql.com/downloads/api-myodbc.html
>
>In each case, I got the source versions and built them on my system.
>Note that it was not a straightforward process: it took me a fair bit of
>fiddling to get it to work!! However, once I did get it to work, it did
>what I required of it, although it tended to be a bit slow.

Thanks for that. I am a little confused though. An extract of the MyODBC 
manual reads "Normally you only need to install MyODBC on Windows machines. 
You only need MyODBC for Unix if you have a program like ColdFusion that is 
running on the Unix machine and uses ODBC to connect to the databases" so 
do I in fact need to use ODBC to connect OOo to a MySQL database?

Cheers


Steve


___________________________________________________________________

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

  GNU the choice of a complete generation.