How to connect MYSQL database from asp file?

I have sample Code like this. Please let me know how to connect Mysql DB from these ASP file. I have installed MySQLODBC driver 5 on my machine.

SQL="select fname,lname from Guest"

set rs=Conn.Execute(SQL)

response.write("")

response.write("")

while (not rs.EOF)

response.write("")

response.write("" & rs("fname") & "")

response.write("" & rs("lname") & "")

response.write("")

rs.MoveNext()

wend

rs.close()

conn.close()

response.write("")
%>

1 answer