adUseServer cursor doesn't return any records

[custsoft]

I am using VB6 with ADO 2.1. I have a datagrid connected to an ADODC. I am currently using the Adopenkeyset cursor type, the adUseClient cursor location and a select * in the record source but it is veeery slow on networks. I am testing this on a standalone. When I change the cursor location to adUseServer no records show up in the datagrid. Obviously I am doing something wrong but I am trying to speed things up to an acceptable level on networks where it seems to work fast enough on stand alones. Thanks for any help you me be..

 

[TimLarkin]

Adopenkeyset is a client side cursor type. try adOpenDynamic Tim

Remember the KISS principle:
Keep It Simple, Stupid!

 

[custsoft]

Thanks Tim,
I did change the cursor type to dynamic but then I got a runtime error 7004 "the rowset is not bookmarkable" when setting the datagrid datasource to the adodc I am using. When I use the adopenkeyset I don't get that error. Any suggestions?