Updating the JDBC Service Driver to support custom connection property prefixes
By default, custom connection properties that are prefixed by MR or MR Init are not supported in the connection string. If you want to specify these custom connection properties, you must declare them in the JDBC Service Driver’s configuration:
1 After installing the JDBC Service Driver, go to the Windows Control Panel > Administrative Tools > Services.
2 In the Services list, click the DataCollectionJDBCDriverService service.
3 Click Action > Stop.
4 Go to the \cfg directory in the JDBC Service Driver installation path. The default path is:
[INSTALL_FOLDER]\IBM\SPSS\DataCollection\7\JDBC Server
5 Open the oadm.ini file in a text editor.
6 Search for the DataSourceIPCustomProperties keyword; the default value is:
User ID=;Password=;Data Source=;Initial Catalog=;Location=;Mode=Read;Connect Timeout=;
7 Add the property name to the end of the value. For example, to add the MR Init Category Names property, write the value as:
User ID=;Password=;Data Source=;Initial Catalog=;Location=;Mode=Read;Connect Timeout=;MR Init Category Names=;
8 Save the oadm.ini file, and then go back to the Services dialog.
9 In the Services list, select the DataCollectionJDBCDriverService service.
10 Click Action > Start, and then close the Services dialog.
See also
See also