append only recordset -- sql server clients

rulkin Guy
6/30/2003 12:09:59 PM

i have one big table with many records. I want to use one "append only"
recordset with the oledbprovider. When i open the recordset, this take long
time. Have someone information to open the recordset in append only mode ?
With jet ole db, throught one link in access database, it's work fine but i
want to use the oledb provider.

'in access, the Mvt.Properties("Append-Only Rowset") = True work fine but
not with the sqloledb provider
Set DB = New ADODB.Connection
DB.Open "provider=sqloledb;Connect Timeout=15;Persist Security
Info=False;database=mar;server=guy\visual", "sa", ""
Set Mvt = New ADODB.Recordset
Mvt.ActiveConnection = DB
' Mvt.Properties("Append-Only Rowset") = True
Mvt.Open "mvtstock", , adOpenKeyset, adLockPessimistic

BlueGI
7/1/2003 9:37:20 AM

Why would you need to open it? Just issue insert/update/delete statements.
The only reason to open it would be to display something to the user, or
gather some information for some other process. If that's the case, then
only issue a select statement to gather the minimum number of records you
need. Opening it and accessing it means the server has to send the result
set to the client machine.

[quoted text, click to view]

sql server clients : append only recordset