You can get the list of all properties. There're more properties available after connection open than before.

lcFileName = "PropList.txt"
ERASE (lcFileName)
FOR i=1 TO oDBConn.Properties.Count
  STRTOFILE(oDBConn.Properties.Item(i-1).Name + Chr(13) + Chr(10), lcFileName, .t.)
ENDFOR

I don't know what properties to set for your purpose.

>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