ADO Recordset Update into Oracle/ How To

[sguslan]

Hi all

I use and .ASP page and ADO to read data from an SQL7 linked server to DB2 and save data into SQL7 linked server to Oracle7.3. Reading data from DB2 is fine but when I update Oracle I get "updateable keyset cursors on remote tables require a transaction with UPDATEABLE_READ or SERIALIZABLE isolation level"

How do i use a RECORDSET to update/insert the data from source recordset into the target Oracle DB..

Thanx

Salim

 

[TomasDill]

What recordset type you use to update the Oracle table - Client-Side or not? (CursorLocation = adUseClient or adUseServer)?
Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs

 

[sguslan]

Thanx for the quick response ...
I use the default cursor location ...
I found a solution by including the following code:

connectionobj.beginTrans

and of course:

recordesetobj.updateBatch
connectionobj.commitTrans


But, it is still verrrrry slow .. Why? any help

 

[TomasDill]

Take a look to the help file for CursorLocation property. If it is adUseServer, i creates server-side cursors, that could be VERY slow. Try to assign adUseClient cursor location if you use ADO recordset.

Anyway, I would also recommend to use DTS of MS SQL Server to transfer data between different servers.
Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs