Re: [Sheflug] OOo and MySQL via ODBC

[pwd <xxxxx [at] xxxxxxxxxxxxxx>]

On Mon, 2002-08-12 at 14:09, Steve Tickle wrote:
> My current trauma is getting OOo to load a MySQL database via ODBC. I have 
> unixODBC installed and I have configured a DSN in /etc/odbc.ini. However, 
> when I try to configure my database as an OOo data source it's not listed.
> In the OOo Data Source Admin window, I create a new DSN, select ODBC as the 
> database type but if I then click the browse button to select the url of 
> the data source, I get an empty window. If I then click the Organize button 
> I get an error box saying that OOo can't find libodbc.so although it's 
> actually in /var/lib

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. 


___________________________________________________________________

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

  GNU the choice of a complete generation.