Re: [Iodbc-list] Could not determine the driver name; could not lookup setup library

[<ge...@ma...>]

I think that libodbcinst.so.1 and libodbc.so.1 belong to unixODBC. If=20
I=B4m right your mysql-connector package was not prepared to work with iO=
DBC.
I have been trying to recompile mysql-connector from sources to work=20
with iODBC for a few weeks with no success.


Regards
--=20
------------------------------------------------------------------------
*/Andr=E9 Louis Dutheil/ *
Gerente de Inform=E1tica
Machado Ribeiro editora e distribuidora ltda
Fone: 71 3483.5822 Celular: 71 9979.3348
------------------------------------------------------------------------



Thanh Do Duc wrote:
> Hi Andre
> How can i know if mysql-connector-odbc 3.51.12 supports iODBC or unixOD=
BC?
> if yes, how can i do to modify the default.
> Please help.
> Thanks.
>
> On 3/6/06, *Andr=E9 Louis Dutheil* <ge...@ma...=20
> <mailto:ge...@ma...>> wrote:
>
>     Is your mysql-connector-odbc-3.51.12 linked to support iODBC. I thi=
nk
>     the default from mysql is unixODBC.
>
>     Regards.
>     --
>     -------------------------------------------------------------------=
-----
>     */Andr=E9 Louis Dutheil/ *
>     Gerente de Inform=E1tica
>     Machado Ribeiro editora e distribuidora ltda
>     Fone: 71 3483.5822 Celular: 71 9979.3348
>     -------------------------------------------------------------------=
-----
>
>
>
>     Thanh Do Duc wrote:
>     > Hi.
>     > I've been stucking with iodbc and myodbcconnector.
>     > when i ran iodbctest, here is the error:
>     > iODBC Unicode Demonstration program
>     > This program shows an interactive SQL processor
>     > Driver Manager: 03.52.0406.0126
>     > Enter ODBC connect string (? shows list): DSN=3Dtest
>     > 1: SQLDriverConnectW =3D [MySQL][ODBC 3.51 Driver]Could not deter=
mine
>     > the driver name; could not lookup setup library. DSN=3D(test)
>     >  (0) SQLSTATE=3DHY000
>     > 1: ODBC_Connect =3D [MySQL][ODBC 3.51 Driver]Could not determine =
the
>     > driver name; could not lookup setup library. DSN=3D(test)
>     >  (0) SQLSTATE=3DHY000
>     >
>     > Here is my /etc/odbc.ini:
>     > [ODBC Data Sources]
>     > test=3Dtest database
>     >
>     > [ODBC]
>     > Tracefile=3D/var/log/iodbc.trace
>     > Trace=3D1
>     >
>     > [test]
>     > Description=3Dtest database
>     > port=3D3306
>     > Driver=3D/usr/lib/libmyodbc3.so
>     > DSN=3Dtest
>     > Server=3Dlocalhost
>     > Database=3Dtest
>     >
>     > And here is myodbc driver:
>     > # ls -l /usr/lib/libmyodbc*
>     > -rwxr-xr-x  1 root root 1836372 Oct 10 09:42
>     > /usr/lib/libmyodbc3- 3.51.12.so <http://3.51.12.so>
>     <http://3.51.12.so>
>     > -rwxr-xr-x  1 root root     968 Oct 10 09:42 /usr/lib/libmyodbc3.=
la
>     > -rwxr-xr-x  1 root root 1843496 Oct 10 09:42
>     > /usr/lib/libmyodbc3_r-3.51.12.so <http://3.51.12.so>
>     <http://3.51.12.so>
>     > -rwxr-xr-x  1 root root     980 Oct 10 09:42
>     /usr/lib/libmyodbc3_r.la
>     > lrwxrwxrwx  1 root root      23 Mar  6 20:20
>     /usr/lib/libmyodbc3_r.so
>     > -> libmyodbc3_r-3.51.12.so <http://3.51.12.so> <http://3.51.12.so=
>
>     > -rwxr-xr-x  1 root root 1629308 Oct 10 09:42
>     > /usr/lib/libmyodbc3S- 3.51.12.so <http://3.51.12.so>
>     <http://3.51.12.so>
>     > -rwxr-xr-x  1 root root    1173 Oct 10 09:42 /usr/lib/libmyodbc3S=
.la
>     > lrwxrwxrwx  1 root root      21 Mar  6 20:20
>     /usr/lib/libmyodbc3.so ->
>     > libmyodbc3-3.51.12.so <http://libmyodbc3-3.51.12.so>
>     <http://libmyodbc3-3.51.12.so>
>     > lrwxrwxrwx  1 root root      22 Mar  6 20:20
>     /usr/lib/libmyodbc3S.so
>     > -> libmyodbc3S-3.51.12.so <http://libmyodbc3S-3.51.12.so>
>     <http://libmyodbc3S-3.51.12.so>
>     >
>     > These a my database:
>     > # mysql -udbuser -p
>     > Enter password:
>     > Welcome to the MySQL monitor.  Commands end with ; or \g.
>     > Your MySQL connection id is 10 to server version:
>     5.0.18-standard-log
>     >
>     > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>     >
>     > mysql> show databases;
>     > +--------------------+
>     > | Database           |
>     > +--------------------+
>     > | information_schema |
>     > | lrc1000            |
>     > | rli1000            |
>     > | test               |
>     > +--------------------+
>     > 4 rows in set (0.00 sec)
>     >
>     > mysql>
>     >
>     > My Operating System is Fedore Core3.
>     > Following are the packets that i used to install:
>     > - mysql-standard-5.0.18-linux-i686.tar.gz
>     > - mysql-connector-odbc-3.51.12-1.i586.rpm
>     > - libiodbc-3.52.4-1.i386.rpm
>     >
>     > I don't know why it went wrong. Please Help.
>     >
>     > Thanh.
>     >
>
>