Check lige denne connection
Fandt lige følgende connectionkode til database hos b-one. Jeg erstattede min eksisterende Accessdatabase kode med denne, så det ser sådan ud:<%
Dim thumbrec
Dim inforec
ID = request.querystring("id")
Dim objConn
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString="DRIVER={MySQL};SERVER=localhost;
DATABASE=[sights_dk];UID=[sights_dk];PWD=pass;"
objConn.Open
objRS.Open "[QUERY]", objConn, 3,3
set thumbrec = objConn.execute("select * from thumbs where id=" & ID & ";")
set inforec = objConn.execute("select * from info where id=" & ID & ";")
set billedrec = objConn.execute("select * from billeder where id=" & ID & ";")
Jeg får følgende fejlmeddelelse:
Error Type:
Sun ONE ASP VBScript compilation (0x800A0438)
Unexpected end of line inside a string
/skirke.asp, line 17, column 60
