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

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

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)