MySQL Forums
Forum List  »  Connector/ODBC

correct connection string for mysql database using myODBC
Posted by: giupint
Date: March 31, 2005 05:12AM

Hi,
I'm using an asp page to connect to a mysql db created with MySQL Administrator

this is my string:

strConn= "Driver={MySQL ODBC 3.51 Driver};" &_
"Server=localhost;" &_
"Port=3306;" &_
"Data Source=" & dbcomuni & ";" &_
"User Id=root;" &_
"Password=***"

at the MyConn.Open instruction appear this error:

"Microsoft OLEDB Provider for ODBC Drivers
[Microsoft][Driver Manager ODBC]
Data origin name not found and predefined driver not specified"

if i'm using myODBC why is requested OLEDB Provider ?

thanks

Options: ReplyQuote


Subject
Written By
Posted
correct connection string for mysql database using myODBC
March 31, 2005 05:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.