ODBCDatabase.Attribute
From Xojo Documentation
Property (As Integer )
aODBCDatabase.Attribute = newIntegerValue
or
IntegerValue = aODBCDatabase.Attribute
Supported for all project types and targets.
or
IntegerValue = aODBCDatabase.Attribute
Supported for all project types and targets.
Optional attribute. This property is used in conjunction with the AttributeString property to set a string property using the SQLSetConnectAttr ODBC API function.
Notes
Using the Attribute property, the attribute is only set before the connection is made to the database. Although the Attribute / AttributeString properties are readable, they are not updated with information from the database.
The AttributeString property is not passed to the database if the Attribute property is set to zero (the default).
For more information, see the documentation for the SQLSetConnectAttr function at msdn.microsoft.com.
If you don't want to use Attribute, pass zero.
Example
The following code sets the SQL_CURRENT_QUALIFIER property:
db.Attribute = ODBCConstant.SQL_CURRENT_QUALIFIER
db.AttributeString = "NorthWind"
db.AttributeString = "NorthWind"