When I use the SQLOLEDB Provider I cannont get a record count. All the documentation that I have read says I need to use Keyset or static cursor type. And then read through the recordset to get a count. I tried this and it does not work.

Has anyone found a way to get a record count using the SQLOLEDB and using either server side or client side cursors.

Thanks