"Multiple-step OLE DB operation generated errors"
Hej, jeg har et problem... jeg får denne fejl:"sdfdsf
Microsoft OLE DB Provider for ODBC Drivers error '80020009'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/survivor/show.asp, line 0"
Det første "sdfdsf" er fra min database, så den kan godt finde ud af at hente det første. Men det er efter den at der sker noget... men jeg kan ikke se hvad :(
Her er min kode:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN">
<HTML>
<HEAD>
<TITLE>Showing submitted applications</TITLE>
</HEAD>
<body>
<%
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=dsnname", "un", "psw"
strSQL = "SELECT * FROM survivor"
Set rs = Conn.Execute(strSQL)
Response.Write "<br>"
Do
Response.Write "<TABLE BORDER=0 WIDTH=400>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write "<font color=993333 size=2 face=Verdana, Arial, Helvetica, sans-serif><b>"
Response.Write rs("charname")
Response.Write "</font>"
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("realname")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("rlage")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("email")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("charname")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("shard")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("timezone")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("age")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("skillclass")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("rp")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("hours")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("word")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "<TR>"
Response.Write "<TD>"
Response.Write rs("why")
Response.Write "</TD>"
Response.Write "</TR>"
Response.Write "</TABLE>"
Response.Write "<br>"
rs.MoveNext
Loop While Not rs.EOF
%>
</BODY>
</HTML>
Hvad gør jeg galt? På forhånd tak!
