RecordCount Property

[ofsouto]

How can I get the property recordcount when the provider doesn't support it?
I'm using the Microsoft OLE DB Provider for Oracle (MSDAORA) and even I change CursorType
to adOpenStatic the property returns -1.

 

[elmi]

Have you set the CursorLocation Property to 'adUseClient'?
I think a client side cursor for the recordset supports RecordCount.
Let me know about the result.

 

[longmatch]

you need to change cursor type to adkeyset. I had this kind of problem before.

Haijun

 

[ofsouto]

I changed the CursorLocationProperty to 'adUseClient' but I didn't get recordcount.
I tried all cursortype but even I didn't get recorcount.