Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Red face Unanswered: Insert and update problems

    Hi

    First i wanna say hi since this is my very first post in this forum.

    Now let's get to the subject.

    I have some problems with my scripts and I hope to get an answer here. My script supposed to make an easy task. An insert into a table. And it worked very well until I changed the ODBC drivers into OLEDB drivers.

    This is the part of the script where I get the error:

    -----------
    set objNouvCde = Server.CreateObject("ADODB.Recordset")
    objNouvCde.Open "DRW01FIC.DRTCDE", objConn, 2 , adLockPessimistic, adCmdTable
    objNouvCde.AddNew
    ....

    -------------

    It works very well with this connection string :

    "Provider=MSDASQL.1;Password=***;Persist Security Info=True;User ID=user;Data Source=DSN1"

    but when I am using the OLEDB driver the connection string gets :

    "Provider=IBMDA400.DataSource.1;Password=***;Persi st Security Info=True;User ID=user;Data Source=DSN2"

    The error I get is

    "ADODB.Recordset (0x800A0CB3)
    Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype."

    Can anyone help? Is there some driver limitation and I can't get Dynamic cursor or stuff like that?

    I am on a Windows 2000 server with IIS 5.0 and the DB is DB2/AS400

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    Perhaps try changing this:
    objNouvCde.Open "DRW01FIC.DRTCDE", objConn, 2 , adLockPessimistic, adCmdTable

    To be something more like this instead:
    objNouvCde.Open "DRW01FIC.DRTCDE", objConn, 3 , adLockOptimistic, adCmdTable

    And here's a related resource:

    Cursor & LockType Performance Report - 6/27/1999
    http://www.4guysfromrolla.com/webtec...3.report.shtml
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

  3. #3
    Join Date
    Sep 2003
    Posts
    6

    Unhappy

    Thanks, but nope. I tried all the combinations of locktype and cursor types. I am affraid that it is some kind of incompatibility with this OLEDB driver.... (proider = IBMDA400.DataSource.1) Evthing works great withthe ODBC driver (but much slower)

Posting Permissions

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