iodbctest tool fails to connect with mysql

[Sunil]

Hi,

I have installed
1. mysql server/client(VER 4.1.8-0)
2. iodbc driver manager(LIBIODBC-3.52.1)
3. MyODBC(MySQL odbc 3.51 driver)(VER 3.51.09-1)

on Linux NLD.

I am trying to connect to the database through iodbctest

# iodbctest DSN=mysql;UID=mysql;PWD=mysql

I receive an error message "No DSN entered" when the SQLDriverConnect() is invoked.
I get the same error when i test the dsn with iodbc data source administrator.

I have given full privileges to the user mysql
I am giving the odbc.ini settings below:

[ODBC Data Sources]
mysql = MySQL ODBC 3.51 Driver DSN

[mysql]
Driver = /usr/lib/libmyodbc3.so
Description = MySQL ODBC 3.51 Driver DSN
DSN = mysql
SERVER = localhost
PORT = 3306
SOCKET = /var/lib/mysql/mysql.sock
USER = mysql
Password = mysql
Database = mysql
ReadOnly = no
ServerType = MySQL
OPTION = 3
TraceFile = /var/log/mysql_test_trace.log

I am able to get the iodbctest working with postgres though.

Is there anything specific i need to do for connecting an iodbc client to mysql?
Please let me know.

Thanks

- Sunil