Error in row
når jeg kører et af mine scripts kommer den med denne fejl:Microsoft OLE DB Provider for ODBC Drivers fejl '80004005'
[Microsoft][ODBC Microsoft Access Driver]Error in row
/nocturne/news/addnews.asp, linje 23
mit script:
<!-- #INCLUDE FILE="security.asp" -->
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("news.mdb")
If Request.Form("Gem") <> "" Then
strOverskrift = Trim(Request.Form("overskrift"))
strKrop = Trim(Request.Form("krop"))
strOpretterlogin = Trim(Request.Form("brugerlogin"))
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM news WHERE (ID = 0)"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs("Dato") = Now()
rs("Overskrift") = strOverskrift
rs("Krop") = strKrop
rs("opretterLogin") = strOpretterlogin
rs.Update
End If
rs.Close
Set rs = Nothing
response.redirect ("nyheder.asp")
End If
%>
<html>
<HTML>
<HEAD>
<!-- "This document is made in Stone's WebWriter 2" -->
<TITLE>addnews.asp</TITLE>
<link REL="StyleSheet" HREF="menunisse.css" TYPE="text/css" TITLE="Web-bruger style">
<META NAME="Generator" CONTENT="Stone's WebWriter 2">
<!-- Minus AutoDato -->
<!-- BACKGROUND="pics/q3tegn.jpg" bgproperties="fixed" -->
<link REL="StyleSheet" HREF="../styles/main.css" TYPE="text/css" TITLE="Web-bruger style">
</HEAD>
<body bgcolor="black" BACKGROUND="../pics/q3tegn.jpg" bgproperties="fixed">
<br><br>
<form method="POST" action="addnews.asp">
<TABLE WIDTH="100%" BORDER="0">
<TR valign="right"><TD width="70"></td><td WIDTH="410"><div><tt>Indtast venligst oplysningerne i følgende felter:</tt></div>
</td></tr>
<tr>
<td valign="middle" align="right" width="70"></td>
<td valign="middle" align="left"><input type="hidden" name="Opretterlogin" size="40" value="<%=session("brugerlogin")%>"></td>
</tr>
<tr>
<td valign="middle" align="right" width="70"><strong>Overskrift:</strong></td>
<td valign="middle" align="left"><input type="text" name="Overskrift" size="40"></td>
</tr>
<tr>
<td valign="middle" align="right" width="70"><strong>Nyhed:</strong></td>
<td valign="middle" align="left"><textarea rows="4" name="Krop" cols="40"></textarea></td>
</tr>
<tr>
<td valign="middle" align="middle" colspan="2"><br>
<input type="submit" value="Gem" name="Gem"> <input type="button" value="Annuller" name="Annuller" onClick="java script:history.back();"></td>
</tr>
</table>
</form>
</tr>
</table>
</center></div>
</body>
</html>
