ADO 2.7 and client side cursors

[newora]

Hi there - I am new to Oracle and VB6,but have used VB6 with SQL server.

In SQL server it is possible to use server side cursors and open an ADO recordset (using ADO 2.7) which can then see any modifications made by other users.

Under Oracle it seems that I can not use server side cursors, is this just a restriction with using Oracle or the ADO drivers, or am I being completely stupid.

Thanks for your help.

 

[RJFost]

Using client-side cursors (CursorLocation = adUseClient) lets you leverage all the features of the OLE DB cursor service; in general, this is what I use (be it Oracle, SQL Server, whatever) unless specifically directed otherwise.

 

[fixthebug]

So "RTFrost" are you sying that in oracle we can use ServerSide Cursor, and then as "NewOra" questioned, we can see the records being updated dynamically ( id cursor is opened dynamically or keyset)??