Cannot connect with MyODBC Version 5.0.10
Jim Bullington <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
I am unable to connect to a MySQL Version 5.0 database using the MySQL Connector/ODBC v5 driver. I am using the following connection string (with VB6/ADO - no DSN):
Driver={MySQL Connector/ODBC v5};Server=server;Database=mydb;Uid=dbuser;Pwd=dbpass;Option=3;
Returns the following error:
[MySQL][MyODBC 5.00.10][MySQL] 1045 Access denied for user 'dbuser@localhost' (using password: YES) Database: server, mydb
This is a remote server, should the @localhost be there?
The following connection string (MyODBC 3.51) to the same database works fine:
Driver={MySQL ODBC 3.51 Driver};Server=server;Database=mydb;User=dbuser;Password=dbpass;Option=3;
Any help would be greatly appreciated!
JIMB
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/[email protected]