another database connection question! asp and mysql

[fogofogo]

Hi all,
I'm trying to remotely access a mysql database and I am experiencing a few problems

Code: Select all

<% 
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:

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]

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.

[fogofogo]

That line is actually commented out.

I found the error though - it was the <> brackets.

Thanks

[Rob]

Originally Posted by fogofogo

That line is actually commented out.

I found the error though - it was the <> brackets.

Thanks

ROFL..... erm... yeah... I'm now pretty embarrased. I shoulda saw that straight-away.

[fogofogo]

ha! Ah - it was late in the evening mate. Long hard day etc etc.