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