Hi Glenn,

The Connection object has a properties collection, you can set it explicitly via these (among others).

On mine for example

oConn = CreateObject("ADODB.Connection")
cConnectString = [Provider=VFPOLEDB.1;Data Source=] + HOME(1) + [Samples\Data\testdata.dbc;] + ;
  [Mode=ReadWrite|Share Deny None;Password="";Collating Sequence=MACHINE]
oConn.ConnectionString = cConnectString
oConn.ConnectionTimeout = 30
oConn.Open
?oconn.Properties.Item("SET DELETED").Value && return .T.
oConn.Properties.Item("SET DELETED").Value = .F.

Whoops, sorry my example is in VFP, but you get the idea :)