RE: Cannot connect with MyODBC Version 5.0.10
"Ron Alexander" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
This is the site I will use for connections strings. I have yet to not be able to find what I need or at least find one that I can manipulate to meet my needs. http://www.connectionstrings.com/?carrier=mysql Good luck. Ron -----Original Message----- From: Jim Bullington [mailto:[email protected]] Sent: Tuesday, January 09, 2007 3:28 PM To: [email protected] Subject: Re: Cannot connect with MyODBC Version 5.0.10 Thanks for your response, Shawn. The MySQL server is actually on the same physical network as my machine. No SSH or VPN. I still haven't figured this out... JIMB "Shawn Green" <[email protected]> wrote in message news:[email protected]... > 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] -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]