unixODBC and MySQL

[Nazmul Hossain]

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.