Hi all,
I'm trying to remotely access a mysql database and I am experiencing a few problems
Code:
<%
Dim sConnection, objConn , objRS
'sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=newsxml; OPTION=3"
sConnection = "Driver={MySQL ODBC 3.51 Driver};" & _
"Server=<82.195.128.88>;" & _
"Database=<johnfog_xml>;" & _
"Uid=<johnfog_xml>;" & _
"Pwd=<wordword>;"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open(sConnection)
Set objRS = objConn.Execute("SELECT Heading, Contents FROM DeHavillandNews")
While Not objRS.EOF
Response.Write objRS.Fields("Heading") & ", " & objRS.Fields("Contents") & "<br>"
'Response.Write & " "
objRS.MoveNext
Wend
objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>
and here is the error message:
Quote:
quote:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[MySQL][ODBC 3.51 Driver]Unknown MySQL server host '<82.195.128.88>' (11001)
/mysql/index2.asp, line 22
|
Is there anything obvious thats wrong here?
I'm fairly new to this so any help would be really appreciated.
Thanks all
another database connection question! asp and mysq
