nPropertiesCount=cnn.Properties.count put cnn.Properties[propertyIndex] cnn.Properties[propertyIndex]=newValue put cnn.Properties[propertyIndex].Type objProperty=cnn.Properties[propertyIndex].ref
Parameters
propertyIndex
String property name or Integer zero based index of the property object in Connection.Properties collection.
Sets or gets
Any
connection property value, if used in simple syntax.
Object property object wrapper, if further cascading property is requested.
Description
Allows access to the Value property of the property objects or to the Property object itself in Properties collection of the wrapped ADODB.Connection object. Each Property object corresponds to a characteristic of the ADODB.Connection object specific to the provider.
Some properties are read only, others are read and write capable.
Sample
A sample script, which displays all properties of the passed connection object:
on ShowProperties cnn
repeat with i= 0 to cnn.Properties.Count - 1
put cnn.Properties[i].Name & "=" & cnn.Properties[i]
end repeat
end
