| :: Configuration :: (3) | Post a New Message | Post a Reply |
 Configuration | Post a Reply |
from: San Antonio, TX
Errors Occured!
Error #:-2147467259
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I am using:
objWiz.Initstr(ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};DESC=;" & _
"DATABASE=YOUR_DATABASE;SERVER=YOUR_SERVER_NAME;" & _
"UID=YOUR_USERNAME;PASSWORD=YOUR_PASSWORD;" & _
"PORT=;OPTION=0;STMT=;" )
I have filled in the appropriate Database Name, Server, etc.
and i get the enclosed error.
Whats wrong? Please help!
 Re: Configuration | Post a Reply |
from: Washington, DC
objWiz.Initstr(ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver}; ... to this:
objWiz.Initstr("DRIVER={MySQL ODBC 3.51 Driver}; .... Make sure that your MySQL ODBC driver's version corresponds to the one in your connection string. for example:
objWiz.Initstr("DRIVER={MySQL ODBC 3.51 Driver};DESC=;" & _
"DATABASE=YOUR_DATABASE;SERVER=YOUR_SERVER_NAME;" & _
"UID=YOUR_USERNAME;PASSWORD=YOUR_PASSWORD;" & _
"PORT=;OPTION=0;STMT=;" ) 
-------------------------
Ghost
 Re: Configuration | Post a Reply |
from: San Antonio, TX
I made the correctins you sugested. It did not work. Same error message.
ODBC Data Source is configured and passess the the connection test to server.
I am sure its probably something simple.. I will keep hacking at it.
I appreciate all your help.