Update disconnect RS from Linked Server

[ToddR]

I am pulling a disconnected recordset from a linked server using ADO 2.5. I have the following config:
Cursor Location: client side
Cursor Type: KeySet
LockType: BatchOptimistic

I'm using the oledb provider against a linked SQL7.0 server (wait, on second thought it's an MSDE db). When I reconnect and call updatebatch, I get:
"Insufficient base table information for updating or refreshing".
Error number = -21474667259
Native Number = 1006

Any ideas?

Thanks

 

[princeshri]

try doing it without the disconnect / reconnect. If the error still shows - you know the bug is not with the disconnect / reconnect. There is a (yet another) known BUG with microsoft which displays this error message when using some queries etc.