[ale] odbc.ini trouble

[James P. Kinney III]

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?

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!
-- 
James P. Kinney III          \Changing the mobile computing world/
CEO & Director of Engineering \          one Linux user         /
Local Net Solutions,LLC        \           at a time.          /
770-493-8244                    \.___________________________./
http://www.localnetsolutions.com

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics)
<jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part