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
Re: problem in connetcion with MYSQL db ?
hi there
any help plz ..
plz ..
Re: problem in connetcion with MYSQL db ?
See the "Fixing common DB related errors" link in my signature.