Re: Cannot connect with MyODBC Version 5.0.10

Hi Jim,

Jim Bullington wrote:
> 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
>
>   
The server you are connecting to believes that your connection attempt 
is coming from the same machine that is hosting the server. That is the 
source of the "@localhost" portion of the login account that you are 
seeing in your error message.

Are you using some kind of network tunnel (like VPN or SSH) to make a 
connection from your code machine (where the ODBC driver is) and your 
database server? That would be my best guess at why a server on a 
machine other than your own might believe you are attempting a local 
connection.

-- 
Shawn Green, Support Engineer
MySQL Inc., USA, www.mysql.com
Office: Blountville, TN

Are you MySQL certified?  www.mysql.com/certification


-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]