[ale] odbc.ini trouble

Jim Philips jimmyc at speedfactory.net
Sat Oct 2 13:44:52 EDT 2004


I am trying to get ODBC connections to MySQL working. I borrowed the following 
odbc.ini from a tutorial on the Web:

[ODBC Data Sources]

myodbc3 = MySQL ODBC 3.51 Driver DSN

[myodbc3]
Driver = /usr/local/lib/libmyodbc3.so
Setup = /usr/local/lib/libodbcmyS.so
Description = MySQL ODBC 3.51 Driver DSN
SERVER = localhost
PORT = 3306
USER = root
Password = my_password_here
Database =
OPTION = 3
SOCKET = /var/run/mysql/mysql.sock

But when I run:

isql -v myodbc3

I get:

[S1000][unixODBC][MySQL][ODBC 3.51 Driver]Access denied for user: 
'root at localhost' (Using password: NO)
[ISQL]ERROR: Could not SQLConnect

Now I use the same password in some PHP pages and I can log in to MySQL from 
the command line using the same password with no trouble. So, I can only 
conclude the password isn't getting through to the login sequence. Anybody 
have an idea why? 



More information about the Ale mailing list