*******************
So you want to write your changes to the database? With the approach you're taking (sending the whole recordset) you would send a disconnected rs from the client (that has been obtained from the server specifically for batch updates) and when it gets to your server COM object, you reconnect (create an ADO connection object, fill connection parameters and .Open, then set the .Activeconnection property to the opened connection object) and execute the .UpdateBatch method of the ADO recordset
****
I do this exactly. The problem is creating an ADO connection object. The code o(a portion) of wraper class of ADODB.Connection runing IN CLASS SERVER is executed IN FORM CLIENT !!!!(i can see this in debugger...)
The Life is Beautiful!
Programmer in
Delphi, VS.NET
MCP