"Data source name not found ..." error !

[Gerald Gutierrez]

	
Hey all.

I'm trying to get MyODBC working. Although I can create the executable I can't
make it access any databases! When I try to connect to a database, I get the
error message:

[iODBC][Driver Manager]Data source name not found and no default driver 
specified. Driver could not be loaded. 

The sqlState is IM002. 

I believe this has to do with an improper .iodbc.ini setup, but I fail to see
what's wrong with it. It's below. There's no UID or password. I'm assuming I
can issue those with ODBC commands instead.

If anyone can help, I'd appreciate it very much.

Thanks.

[test]
Trace    = Off
TraceFile= stderr
Driver   = /usr/lib/mysql/libmyodbc_mysql.so
DSN      = test
DB       = test
SERVER   = localhost
#UID      = test
#PWD      =
PORT     = 3306
#OPTION  = 1
#DB      = test
SOCKET  = /tmp/mysql.sock