connect to MySql database in ASP

Hi,

I would like to have the code through which I can connect to MySql database in ASP. I am able to connect through VB but when I try to use the same connection string in ASP, I am getting an error saying that it is an invalid attribute.

Anyone please let me know about this at the earliest.

Hi,

Can you send me the code that connects VB to MySQL. Here is the code for ASP to MySQL connection.

--------------------------------------------------------------------------
<%@ Language=VBScript %>
<%
Dim my_conn, strSQL, rs
Set my_conn = createobject("ADODB.Connection")

my_conn.open = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& "DATABASE=C:\Program Files\mysql\data\wine;"_
& "UID=root;"_
& "PWD=;"

strSQL = "SELECT * FROM wine"

Set rs = conn.Execute(strSQL)

' Do until it reaches end of db

Do while not rs.eof
Response.Write "Name: " & rs("customers") & "<br>"
'Response.Write "FirstName: " & rs("FirstName") & "<br>"
'Response.Write "LastName: " & rs("LastName") & "<br>"

rs.MoveNext 'Next record
loop

my_conn.close ' Close database connection
Set my_conn = nothing 'obj variable released

%>


--------------------------------------------------------------------------------