problem in connetcion with MYSQL db ?

[xray]

hi there
when i try to connect using this code ::

<%
Dim dbhost, username,dbname, dbpwd, oConn, sConnection

dbhost = "localhost"
dbname_and_username = "root"
dbpwd = "Brinkster_Password"
dbname="test"

Set oConn = Server.CreateObject("ADODB.Connection")
sConnection = "Driver={MySQL ODBC 3.51 Driver};" &_
"Server="& dbhost &";uid="& username &";pwd="& dbpwd &";database="& dbname &";"
oConn.Open(sConnection)
response.write "<br><br><center>The MySQL connection has been opened.<br><br>"

oConn.Close
response.write "The MySQL connection has been closed.</center>"
Set oConn = nothing
%>

an error rasie :

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

how i can connect to this db :

i try to connect local and then will connect on server .. hope to solve this case .. thanks

[xray]

hi there

any help plz ..
plz ..

[si_the_geek]

See the "Fixing common DB related errors" link in my signature.