[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