Does anyone know the correct syntax for a DSN-less connection to mySQL? 

I've already downloaded the myODBC driver.



Am I going in the right direction with this:





  Dim con

  set con = Server.CreateObject("ADODB.Connection")

  con.ConnectionString = "Provider=?????????; Data Source=?????????"

  con.open

Here is a connections string I put in an include.



Connects to mySQL database.



<%

strConn = "driver={MySQL};server=localhost;uid=????;pwd=????;database=????"

Set dbc = Server.CreateObject("ADODB.Connection")

dbc.Open strConn

%>



Regards

Grant



-----Original Message-----

From: selman@b... [mailto:selman@b...]

Sent: Wednesday, 7 March 2001 6:36 PM

To: ASP Database Setup

Subject: [asp_database_setup] DSN-less connection to mySQL





Does anyone know the correct syntax for a DSN-less connection to mySQL?

I've already downloaded the myODBC driver.



Am I going in the right direction with this:





  Dim con

  set con = Server.CreateObject("ADODB.Connection")

  con.ConnectionString = "Provider=?????????; Data Source=?????????"

  con.open