troubleshooting Question

myODBC connection error!

Avatar of WillBurke
WillBurke asked on
MySQL Server
2 Comments1 Solution432 ViewsLast Modified:
Hello Experts,

I am running Windows XP, IIS 5.1, php 4.4.0 mysql 4.0.25 and myODBC driver 3.51 I set up my db with the following:

u: root
p: wrong1pass

myODBC has the following settings

Login Tab:
   DataSource Name: myodbc
   User: root
   Password: wrong1pass
   Database: test

this is my connection string in asp:

'Set connection strings for entire application
strConnectString = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;DATABASE=test;USER=root;PASSWORD=wrong1pass;OPTION=3;"
if not IsObject("objConnection") then
    set objConnection=Server.CreateObject("ADODB.Connection")
    objConnection.ConnectionTimeout = 15
    objConnection.CommandTimeout = 10
    objConnection.Mode = 3 'adModeReadWrite
    if objConnection.state = 0 then
        objConnection.Open strConnectString       #######This is Line 107######
    end if
end if

its the same for php and it worked on my last system, but now it gives this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Access denied for user: 'root@localhost' (Using password: YES)
/wheels4sale/main/cars/index.asp, line 107

I need this resolved ASAP!!!

Thank you,
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros