Application error

Results 1 to 2 of 2

Thread: Application error

  1. #1
    Linda Guest

    Default Application error

    Hi, can anyone help me with this error message:<BR><BR>ADODB.Connection error &#039 800a0bb9&#039 <BR><BR>The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another. <BR><BR>/Testasp/testformnew2.asp, line 9 <BR><BR><BR>This is my code:<BR><BR><BR>&#060;!--#include file=""--&#062;<BR>&#060;%<BR><BR>set conn=Server.CreateObject("Adodb.connection")<BR>se t rs=Server.CreateObject("Adodb.recordset")<BR><BR>s trConnectionString="Provider=Microsoft.Jet.OLEDB.4 .0;User ID=Admin;Data Source=D:Testasp est.mdb;Mode=Read&#124Write&#124Share Deny None;Extended Properties="";Locale Identifier=1033;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don&#039t Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False"<BR>conn.Open strConnectionString<BR><BR><BR>****this is where the error occurs:<BR>rs.Open "Test", conn, adOpenDynamic, adLockOptimistic, adcmdtable<BR><BR>rs.AddNew<BR>rs("Naam")=Request. Form("txtNaam")<BR>rs("Voornaam")=Request.Form("tx tVoornaam")<BR>rs.Update<BR><BR>rs.Close<BR>set rs=nothing<BR>conn.Close<BR>set conn=nothing<BR><BR>Response.Redirect "testformnew.htm"<BR><BR>%&#062;<BR><BR>Thanks in advance

  2. #2
    Join Date
    Dec 1969

    Default RE: Application error

    Replace rs.Open "Test", conn, adOpenDynamic, adLockOptimistic, adcmdtable<BR><BR>with<BR><BR> "Test", conn, 3, 2, 1

Posting Permissions

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