another database connection question! asp and mysql

fogofogo · December 1st, 2005, 01:24 PM

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:

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

Rob · December 1st, 2005, 01:49 PM

One fairly obvious thing wrong is that you are using localhost..... localhost is NOT remote... I suspect you need your remote server name in there instead.