ASP and MySQL

hi

I am trying to form a connectivity with MySQL. I installed mySQL from the net. I created a simple table and want to show the same through asp.

I am writing the below script--->

<%
DIM SQL
DIM RSA
DIM BGC
ConnString = "Driver={MySQL};"
ConnString = ConnString & "Port=8888; "
ConnString = ConnString & "DATABASE=TEST; "
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open
BGC = "BDBDFF"
SQL = "SELECT * from trial"
set RSA = Server.CreateObject("ADODB.Recordset")
Set RSA = conn.Execute(SQL,,adCmdText)
If not RSA.EOF and not RSA.BOF then
Do while not RSA.EOF
Response.Write "<table>"
Response.Write "<tr>"
Response.Write "<td bgcolor=" & BGC & "> " & RSA.Fields ("name").Value & "</td>"
Response.Write "<td bgcolor=" & BGC & "> " & RSA.Fields ("age").Value & "</td>"
Response.Write "</tr>"
Response.Write "</table>"
RSA.MoveNext
loop
end if
%>

and i am getting the following error:
Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/myweb/testconnect.asp, line 9


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)

Page:
GET /myweb/testconnect.asp

can anyone tell me what wrong i have done with the script ! I am giving the DSN name and have also specified the driver.

thanks in advance!

Have you installed MyODBC on the web server?

but why do i need to install myODBC?
I am using ADO for connectivity. arent they the same thing?

thanks

i installed MyODBC driver available on mysql.com. And then going to 'administrative tools' i foind the driver name for mysql. i then used that driver name in the code and i can retirieve information from mysql.

thanks!!!