problem in connetcion with MYSQL db ?

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

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 :

Code:

---

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

hi there

any help plz ..
plz ..

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