Re: [Iodbc-list] About iodbc with MyODBC

[<iod...@li...>]

Hi,

> first of all, i want to say that i'm a new user in this list, i'm very 
> rookie about odbc, well lets go to grain
> i had installed unixODBC 3.51 with MyODBC 3.51 for mysql databases and 
> this is my odbc.ini:
>  
> [test]
> Description = Test
> Driver = MySQL
> Server = localhost
> Database = test
> Port = 3306
> Socket =
> Option =
> Stmt =
>  
> and this is my odbcinst.ini
>  
> [TXT]
> Description             = Text file driver
> Driver          = /usr/lib/libodbctxt.so
> Setup           = /usr/lib/libodbctxtS.so
> FileUsage               = 2
>  
> [PostgreSQL]
> Description             = PostgreSQL driver
> Driver          = /usr/lib/libodbpsql.so
> Setup           = /usr/lib/libodbpsqlS.so
> FileUsage               = 2
>  
> [MySQL]
> Description             = Mysql driver
> Driver          = /usr/lib/libmyodbc3.so
> Setup           = /usr/lib/libodbcmyS.so
> FileUsage             = 2
>  
> and when i run isql, it connects fine to the mysql database
> but when i run iodbctest with test as database
> it sends me this message
>  
> iODBC Demonstration program
> This program shows an interactive SQL processor
> Driver Manager: 03.51.0001.0908
> [iODBC][Driver Manager]Specified driver could not be loaded, SQLSTATE=IM003
> [iODBC][Driver Manager]MySQL: cannot open shared object file: No such 
> file or directory, SQLSTATE=00000
>  
> this is problem of drivers but i don't have idea of what to do????
>  
>  

The current version of iODBC does not handle Driver=MySQL as it is not 
capable of reading the actual driver name from the odbcinst.ini file.
This feature is going to be part of the upcoming version of iODBC.

A workaround is to specify the full path to the driver e.g.:

[test]
Description = Test
Driver = /usr/lib/libmyodbc3.so
Server = localhost
Database = test
Port = 3306
Socket =
Option =
Stmt =


Best regards,

Patrick
-- 
Patrick van Kleef            Email : io...@op...
Maintainer iODBC             Web   : http://www.iodbc.org/
OpenLink Software

Universal Data Access & Data Integration Technology Providers