Specifies a key=value pair for every custom connection property that the OpenAccess SDK administrator allows the application to use. You can define the custom properties in the Management Console (see Changing a Service Attribute). Alternatively, you can define the custom connection properties and their default values in the oadm.ini, the configuration file of the OpenAccess SDK Server.
The syntax is as follows:
DataSourceIPCustomProperties=Attribute=value;
The application can overwrite these custom properties by specifying the following:
For ODBC:
The Custom Properties text field of the setup dialog on Windows, or in the Windows Custom Properties registry key
The Custom Properties=… entry in the ODBC data source (odbc.ini) on Linux and UNIX
The user connect string of SQLDriverConnectW on Windows, Linux, and UNIX
Note: The OpenAccess SDK Client connection options and the Custom connection options can have the same name. When the application specifies such keywords on the user SQLDriverConnectW connection string, you can prefix the key of the key=value pair with CP_. The escape sequence CP_ is removed when the key=value pair is delivered to the IP layer.
For example, UID is an OpenAccess SDK Client connection option. If the IP layer also needs to specify UID, change the key=value pair on SQLDriverConnectW to CP_UID=uid1.
For JDBC:
Specify the connection options in the JDBC data source; to handle these properties, you can use the getCustomProperties and setCustomProperties methods of the OpenAccessDataSource class
Specify the connection options in the JDBC URL. The custom connection properties are key value pairs separated by semicolons and distinguished from the other connection properties by surrounding the custom properties with braces:
([;attribute=value[;attribute=value]...])
For example: jdbc:openaccess://localhost:19986;ServerDatasource=CSV;CustomProperties=(A=abc;B=xyz)
For ADO, the custom properties can be specified in the Custom Properties text field of the setup dialog on Windows.
Note: The OpenAccess SDK Client connection options and the Custom connection options can have the same name. When the application specifies such keywords on the user SQLDriverConnectW connection string, you can prefix the key of the key=value pair with CP_. The escape sequence CP_ is removed when the key=value pair is delivered to the IP layer.
For .NET, the custom properties can be specified in the Custom Properties connection string option.
Note: DataSourceIPCustomProperties does not support Unicode characters. For example, DataSourceIPCustomProperties=A=¥, which has the ¥ Unicode character, is not supported.
For ODBC: