Database sti
Hvordan ændrer jeg stien i den nedenstående kode til at pege på den fysiske sti, det kunne fx være d:\\localhost\\site\\database.mdb<%
strSQL = \"SELECT TOP 5 * FROM links ORDER BY LinkHits DESC;\"
Set myConn = Server.CreateObject(\"ADODB.Connection\")
myConn.Open \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database.mdb\") & \";UID=admin;PWD=;\"
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Do While Not rs.EOF
Response.Write\"<span class=\'flerart\'>-</span> <a href=\'\" & rs(\"LinkURL\") & \"\' class=flerart>\" & rs(\"LinkName\") & \"</a><br>\"
rs.MoveNext
Loop
Else
Response.Write \"<p><font face=Tahoma size=1>There are no new articles in the database</font></p>\"
End If
myConn.Close
Set myConn = Nothing
%>
