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 vb 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 bombs out with e_fail error message. 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.
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 vb 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 bombs out with e_fail error message. 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.
