Problems using AddNew and Update

Results 1 to 2 of 2

Thread: Problems using AddNew and Update

  1. #1
    Extraover Guest

    Default Problems using AddNew and Update

    I am attempting to insert new values into an SQL database from a web page using AddNew and Update (ADO using SQLOLEDB as the Provider) . When When I use locktype or cursorlocation, I get this error: <BR><BR>ERROR NUMBER: 3001 The application is using arguments that are of the wrong type, are out of acceptable range, or are in conflict with one another.ADODB.Recordset.<BR><BR>When I remove the locktype , cursorlocation, and just leave the cursor type, I receive this error:<BR><BR>ERROR NUMBER: 3251 The operation requested by the application is not supported by the provider.ADODB.Field.<BR><BR>All permissions (Administrator) are granted on the SQL Server. How can I get around this problem. I need to addnew and update.

  2. #2
    pcv Guest

    Default RE: Problems using AddNew and Update

    hi<BR>why dont u use sql statement with execute method<BR>hope this works

Posting Permissions

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