[ale] odbc.ini trouble

[Jim Philips]

On Saturday 02 October 2004 03:09 pm, James P. Kinney III wrote:
> Does the odbc connection happen on the same port as the mysql
> connection? Don't you need a database name in the odbc.ini file?

All of the documentation I have on ODBC and MySQL uses that port. And 
specifying a database doesn't make any difference. It still says that 
root at localhost has not supplied a password.

>
> On Sat, 2004-10-02 at 13:39, Jim Philips wrote:
> > 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?
> >
> > _______________________________________________
> > Ale mailing list
> > Ale at ale.org
> > http://www.ale.org/mailman/listinfo/ale
> >
> > !DSPAM:415ee7dd309471619419946!