Insert Into failure

Results 1 to 3 of 3

Thread: Insert Into failure

  1. #1
    Ghose Guest

    Default Insert Into failure

    I´m using win2000 and a access db. When I try to execute this sqlstatement i get an error saying:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers (0x80004005)<BR>[Microsoft][Drivrutin för ODBC Microsoft Access]<BR>The operation needs a question that can be updated.(translated from swedish!)<BR><BR>Can anyone please help me... Here´s the code.<BR><BR>Set DBConnection = Server.CreateObject("adodb.connection") <BR>DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; " <BR>DSN = DSN & "DBQ=" & Server.MapPath("log.mdb") <BR>DBConnection.Open DSN <BR><BR>sql="INSERT INTO tblLog (REMOTE_ADDR, HTTP_REFERER, HTTP_USER_AGENT, HTTP_VIA, SERVER_NAME) VALUES(&#039;;, &#039;&#039;, &#039; MSIE 5.01&#039;, &#039;&#039;, &#039;gbg882&#039;) "<BR><BR>DBConnection.execute(sql)

  2. #2
    NPKumar Guest

    Default RE: Insert Into failure

    Use the cursor type as adOpenDynamic(or 2) and locktype as adLockOptimistic(or 3)

  3. #3
    Ghose Guest

    Default RE: Insert Into failure

    But where does it go into my code?<BR>Is it like this?<BR><BR>DBConnection.Open DSN , 2, 3

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts