Nu hvor jeg prøver at åbne min database, og jeg skriver dette:
<html>
<head>
</head>
<body>
<%
SQLserveradr="http://mysql.b-one.dk"
SQLdatabase="kulidiwa_dk"
SQLlogin="kulidiwa_dk"
SQLpassword="password her!"
Set Conn = Server.CreateObject("ADODB.Connection")
conStr = "driver={MySql};server="& SQLserveradr &";database="& SQLdatabase
conStr = conStr & ";uid="& SQLlogin &";pwd="& SQLpassword & ";OPTION=3"
Conn.Open conStr
sql = "select * from X"
set rs = Conn.execute(sql)
do until rs.eof
%>
UDSKRIV HER!
<%
rs.MoveNext
Loop
Set conn = Nothing
Set rs = Nothing
%>
</body>
</html>Og så får jeg den her fejl:
Technical Information (for support personnel)
Error Type:
ADODB.Connection.1 (0x80004005)
SQLState: S1000 Native Error Code: 2005 [TCX][MyODBC]Unknown MySQL Server Host '
http://mysql.b-one.dk' (3)
/kulidiwa.asp, line 16
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Page:
GET /kulidiwa.asp
Time:
Tuesday, January 25, 2005, 12:25:13 PM
More information:
Sun ONE Active Server Pages Support
Hvad er det der sker? s: