Wow, that took some digging. :) How can you tell what works and what doesn't from that list? For example, I tried

? oDBConn.Properties.Item("SET reprocess").Value

and got something

but

? oDBConn.Properties.Item("Row Insert Notification").Value

Gives the error "Member ITEM does not evaluate to an object".

What I want to do is do inserts as fast as possible with the driver, kind of like a bulk-load utility in VBScript. Do you have any hints on what properties should be set to do a "firehose write"? Right now I am creating a GetRows() array from MSSQL data, and rolling through it to create "Insert Into..." statements for VFP, and getting 8-9 seconds for 1500 rows. Not all that fast.

I am attaching to the driver like this:

Set oDBConn = CreateObject("ADODB.Connection")
With oCacheConn
.ConnectionString = "Provider=VFPOLEDB.1;Data Source=" & cCacheDir & cDestDB
.CursorLocation = 2	'	adUseServer
.Mode = 2   'adModeWrite
.Open
End With

>
>There's Properties collection of the connection object. The VFP OLE DB provider properties are listed in the help under 'Standard and Custom OLE DB Properties'. I believe that property name is proveded in the 'Description' column. For example,

? ocon.Properties.Item("SET NULL").Value
>ocon.Properties.Item("SET NULL").Value = .F.
>? ocon.Properties.Item("SET NULL").Value