hi

i could nt connect to mysql from my client app using the connection str

DRIVER={MySQL ODBC 3.51 Driver};SERVER=192.168.1.212;DATABASE=DB1;UID=MyUs er1;PWD=MyPasswd1;OPTION=18475

but when i give 'localhost' instead of IP it gets connected to the database

the ADO error message is

error no -2147467259

[MySQL][ODBC 3.51 Driver]Access denied for user: 'MyUser1@MySystem' (Using password: YES

pl explain this

How have you specified the hostnames in the user, host and db tables in the mysql database?

could u pl explain , or suggest some links

am new to mysql

try this..

note:
xserver,xdatabase,xuser,xpass is a variable

example:
xserver="192.168.215.3"
xdatabase="customer"
xuser="reuben"
xpass="none"

also check the character case either lower/upper case of your mysql database,user,password design

connStr = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=" & xserver & ";" _
& "DATABASE=" & xdatabase & ";" _
& "UID=" & xuser & ";" _
& "PWD=" & xpass & ";" _
& "OPTION=18475"

THANKS,,

IT WORKED,

BUT WATS THE OPTION, 18475 ?

Option 18475 is the sum of a few different options that MyODBC accepts, like changing LONGLONG columns to INT, for one. It also uses a compressed communication protocol, simulates an ODBC 1.0 driver, doesn't set a packet limit, returns found rows instead of affected rows and tells the driver that the client can't handle the real width of the column. More detail is available below.
http://www.mysql.com/doc/en/MyODBC_c...arameters.html

thanks