ADODB CursorLocation = adUseNone

[Andrzejek]

I have a VB 6 application that connects to Oracle data base thru ADODB. The recordsets created are not that big (in my opinion), there is not much Inserts, Updates and Deletes (again, ‘not much’ is a relative term).

To connect to Oracle I have been using:

Dim Cn As ADODB.Connection

Set Cn = New ADODB.Connection
Cn.ConnectionString = strCn [green]'connection string set somewhere else[/green]
Cn.CursorLocation = [red]adUseNone[/red]
Cn.Open

From MicroSoft site: "adUseNone - This value indicates no cursor location."

I would like to change it to adUseClient, but I don't know what problems I may encounter, if any.

Also, does ADODB.Recordset get/inherit its CursorLocation from Connection object?

If someone could enlighten me on the subject, I would appreciate it.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[dilettante]

From the manual:

adUseNone, 1, Does not use cursor services. (This constant is obsolete and appears solely for the sake of backward compatibility.)

This probably results in a default (server) cursor.