MySQLTalk.org

Gary Wong · Guest

Hi!

I hope to use MySQL with iHTML - I am almost there!
I am having problems using unixODBC with MyODBC to connect to a
MySQL database. I am running MySQL 3.22.24 and MyODBC 2.50.24 on
Linux 2.0.36.

- I configured myodbc with:
.../configure --with-mysql-sources=/home/mysrces/mysql/mysql-3.22.24
--with-unixODBC=/usr --with-unixODBC-libs=/usr/lib
--with-unixODBC-includes=/usr/include

- the make and make install ran ok, and installed the driver
in /usr/local/lib
- I used ODBCConfig to add the driver using:
Driver Lib: /usr/local/lib/libmyodbc.so
Setup Lib: /usr/lib/libodbcmyS.so.1.0.0 [this is from unixODBC]
- I used ODBCCOnfig to create a system DSN for the test database:
Name: MySQLTest
Host: localhost
Port: 3306
Socket: /tmp/mysql.sock
Database: test
- I ran DataManager and tried to connect but I got:

Gary Wong · Guest

Solved! - Thanks to Jim Ziegler (see reply below).
Using dltest (i didn't know what that was for!),
I found that libmyodbc was looking for a
"libmysqlclient.so.6". MySql placed this file in
/usr/local/mysql/lib as "libmysqlclient.so",
and so I moved it to my path at /usr/lib, created
a sym link to it as "libmysqlclient.so.6" and viola!
All is well. By the way, what's "dlconfig", and
where can I find it?

Simone, you might want to do the same thing-
in the unixODBC's Drivers directory, you'll find
the dltest program. Do this:

../dltest /usr/local/lib/libmyodbc-2.50.23.so SQLConnect 1

If it comes back as failed, it will tell you which lib you're
missing (or not in your path).

Thanks also to everyone that replied - just made my day!

Gary Wong
[email]gary.wong (AT) spingroup (DOT) com[/email]

Jim Ziegler wrote: