MySQLTalk.org

Nazmul Hossain · Guest

I am having problem using the unixODBC with MySQL. The ODBC trace file shows the

following error message:

========================================================
////// First Try /////////

[ODBC][811][SQLFreeHandle.c][123]
Entry:
Handle Type = 2
Input Handle = 0x80870f0
[ODBC][818][SQLConnect.c][170]Error: IM003

////// Subsequent retry //////

[ODBC][818][SQLConnect.c][892]
Entry:
Connection = 0x80870f0
Server Name = [192.168.2.1][length = 15 (SQL_NTS)]
User Name = [][length = 0 (SQL_NTS)]
Authentication = [][length = 0 (SQL_NTS)]
[ODBC][818][SQLConnect.c][170]Error: IM003

/////// The odbc.ini file is ////////////

[192.168.2.1]
DSN = Test
Description = MyODBC
Driver = /usr/local/lib/libmyodbc.so
Trace = Yes
TraceFile = /tmp/odbc.txt
Host = 192.168.2.1
Port = 3306
#Socket =
Database = test
user =
Password =
==================================================================

I have tried with the iODBC driver, the result is same. I am using MyQL
3.22.22 and unixODBC Beta 1.0.5.

Any help will be appreciated.