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:
> Login Failed
> This may be for one of these reasons:
> 1. Invalid ID and Password
> 2. Invalid Data Source Config
> 3. Improper installation
- I ran "isql MySQLTest" and got:
[ISQL]ERROR: Could not SQLConnect
- I did a DSN trace and found this:
>[ODBC][28619][SQLConnect.c][170]Error: IM003
>[ODBC][28619][SQLConnect.c][892]
> Entry:
> Connection = 0x8084390
> Server Name = [MySQLTest][length = 9 (SQL_NTS)]
> User Name = [testuser][length = 8 (SQL_NTS)]
> Authentication = [mypasswd][length = 8 (SQL_NTS)]
>[ODBC][28619][SQLConnect.c][170]Error: IM003
- I don't think that it is a permissions problem because I am able
to connect to the database using mysql monitor and the same
user/password combo. In addition, I was able to use the Windows
ODBC driver to connect to the test database using that
username/password
combo.
Any ideas? Thanks in advance!
Gary Wong
gary.wong@stripped
