ole cursor location error

[mterveen]

Don't quite know which forum to put this in so sorry if wrong one.

Having trouble with linked server under sql server 7.0 that links to .dbf files using ms jet ole 4.0 provider. when i query a large table it returns around 1000 records then bombs out with error "search key not found in any record".

so, set up a new vb6 project with 1 form, 1 adodc control and a text box linked to the adodc control. adodc connection string uses ms jet ole db 4.0 provider with dbase iii as extended properties, problem table as source.

with cursor location set to client the program bombs out with e_fail error message when i try to move through the table with the adodc control. with cursor location set to server it works. so solution then would be to use server cursor on linked server.

question is: 1) why does it bomb out with client cursor and 2) how do you designate cursor location with a linked server.

thx for any help.

 

[donutman]

There must be a good FoxPro or dBase forum somewhere, but I'll venture a semi-wild guess. A client side cursor may require the rowset to be local and ado "knows" better than to download an entire table.
-Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]