Hvor er fejlen????
Fejl meddelse:Microsoft OLE DB Provider for ODBC Drivers fejl '80004005'
[Microsoft][ODBC Microsoft Access Driver] Duplicate output destination 'nr6'.
/Sms/Opret.asp, linje 90
Det er kun når jeg forsøger at indsætte i databasen jeg får fejlmeddelsen!!
Scriptet:
%>
brugerid = request.form("brugerid")
pass = request.form("pass")
navn1 = Request.Form("navn1")
navn2 = Request.Form("navn2")
navn3 = Request.Form("navn3")
navn4 = Request.Form("navn4")
navn5 = Request.Form("navn5")
navn6 = Request.Form("navn6")
navn7 = Request.Form("navn7")
navn8 = Request.Form("navn8")
navn9 = Request.Form("navn9")
navn10 = Request.Form("navn10")
nr1 = Request.Form("nr1")
nr2 = Request.Form("nr2")
nr3 = Request.Form("nr3")
nr4 = Request.Form("nr4")
nr5 = Request.Form("nr5")
nr6 = Request.Form("nr6")
nr7 = Request.Form("nr7")
nr8 = Request.Form("nr8")
nr9 = Request.Form("nr9")
nr10 = Request.Form("nr10")
If IsEmpty(brugerid) or brugerid = "" then
Response.Write "<h2><center>Du mangler at skrive brugernavn</h2><br>"
Response.Write "<input type='button' value='Tilbage' Onclick=history.go(-1)>"
Response.End
Else
If IsEmpty(pass) or pass = "" then
Response.Write "<h2>Du mangler at skrive password</h2><br>"
Response.Write "<input type='button' Value='Tilbage' Onclick=history.go(-1)>"
Response.End
Else
set conn = server.createobject("adodb.connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("/Sms/cgi-bin/base.mdb")
conn.Open DSNtemp
sqlstmt = "SELECT * from Bruger ORDER BY brugerid DESC"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sqlstmt, conn, 3, 3
Total = rs.recordcount
Do while RS.EOF = False
If RS("brugerid") = brugerid then
Conn.Close
Set Conn = nothing
Response.Write "<center>Det Valgte brugernavn er detsvære optaget<br>"
Response.Write "<input type='button' value='Tilbage' Onclick=history.go(-1)></center>"
Response.End
Else
Conn.Close
Set Conn = nothing
set conn = server.createobject("adodb.connection")
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("/Sms/cgi-bin/base.mdb")
conn.Open DSNtemp
SQLstmt = "INSERT INTO bruger (brugerid,pass,navn1,navn2,navn3,navn4,navn5,navn6,navn7,navn8,navn9,navn10,nr1,nr2,nr3,nr4,nr5,nr6,nr6,nr7,nr8,nr9,nr10) VALUES ('" &brugerid& "', '" &pass& "', '" &navn1& "', '" &navn2& "', '" &navn2& "', '" &navn3& "', '" &navn4& "', '" &navn5& "', '" &navn6& "', '" &navn7& "', '" &navn8& "', '" &navn9& "', '" &navn10& "', '" &nr1& "', '" &nr2& "', '" &nr3& "', '" &nr4& "', '" &nr5& "', '" &nr6& "', '" &nr7& "', '" &nr8& "', '" &nr9& "', '" &nr10& "')"
Set RS = conn.execute(SQLstmt)
If err.number>0 then
response.write "VBScript Errors Occured:" & "<P>"
response.write "Error Number=" & err.number & "<P>"
response.write "Error Descr.=" & err.description & "<P>"
response.write "Help Context=" & err.helpcontext & "<P>"
response.write "Help Path=" & err.helppath & "<P>"
response.write "Native Error=" & err.nativeerror & "<P>"
response.write "Source=" & err.source & "<P>"
response.write "SQLState=" & err.sqlstate & "<P>"
end if
IF conn.errors.count> 0 then
response.write "Database Errors Occured" & "<P>"
response.write SQLstmt & "<P>"
for counter= 0 to conn.errors.count
response.write "Error #" & conn.errors(counter).number & "<P>"
response.write "Error desc. -> " & conn.errors(counter).description & "<P>"
next
else
response.write "<br><br><font face='arial' size=4><b>"
response.write "Takker"
end if
Conn.Close
Set conn = nothing
End If
RS.Movenext
Loop
End If
End If
End If
%>
