Connection String for mySQL

[baybook]

I'm looking for a way to connect to a mySQL database using ASP. All of my resources reference Microsoft data sources. Any suggestions on where I should look?


Thank you!

 

[SecondToNone]

http://www.able-consulting.com/ADO_Conn.htm

-SecondToNone

 

[SecondToNone]

Specifically this is link for MySql

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForMySQL

and here is one of the connection strings

oConn.Open "DRIVER={MySQL ODBC 3.51 Driver};" & _
"SERVER=myServerName;" & _
"DATABASE=myDatabaseName;" & _
"USER=myUsername;" & _
"PASSWORD=myPassword;"


-SecondToNone

 

[QatQat]

Or if you install MyOLEDB, then you can use oleDB connection and avoid ODBC

dim conn

Conn.Open "Provider=MySQLProv;Data Source=Server; Initial catalog=DB_Name;User Id=root;Password=pass"

Cheers

Qatqat

Life is what happens when you are making other plans.