Using the ADO Client : ADO Connection Attributes : Defining Custom Properties

Defining Custom Properties

OpenAccess SDK allows you to define the custom connection attributes and their default values in the oadm.ini, the configuration file of the OpenAccess SDK Server, using the DataSourceIPCustomProperties service attribute.

For example:

AttributeName=DataSourceIPCustomProperties

AttributeType=string

AttributeSize=16384

AttributeValidationType=none

AttributeValidationStringParam_=0

AttributeValidationIntegerParam_=0

AttributeDisplayGroup=Advanced

AttributeServiceTypeScope=1

AttributeServiceTypeScope0=10

The custom connection properties are key=value pairs separated by semicolons, and surrounded by parentheses to distinguish them from the other connection properties. For example:

([;attribute=value[;attribute=value]...])

For example:

host=localhost;port=19986;ServerDatasource=CSV; CustomProperties=(A=abc;B=xyz)

The defined custom properties are sent to the ODBC Client. The values for the properties can be overwritten by the application using one of the following methods:

• The Custom Properties entry field on the Windows setup dialog

• The Custom Properties entry in the ODBC data source (odbc.ini) on Linux/UNIX

• The Custom Properties entry in the ODBC data source in the Windows registry

Refer to the OpenAccess SDK Administrator’s Guide for more information about the DataSourceIPCustomProperties service attribute.