Creating the system data source on Windows
You must create a data source after you create the exceptions database.
Procedure
- Open the Windows ODBC
administrator with the following command:
start C:\Windows\SysWOW64\odbcad32.exe
- Select the System DSN tab.
- Click the Add button.
- Select the IBM Wire Protocol driver for the database where the exceptions database is located, and click Finish.
- Set the DSN name to the same value that you specified for the managedDataSourceName repository property.
- Click Test Connect to verify that the data source is configured correctly.
- If you use SQL Server to create the exceptions database, select the Advanced tab and click the Enable Quoted Identifiers option.
- If you use Oracle database to create the exceptions database,
enable support for the NCHAR data type. Add two parameters to your
DSN definition in the Windows registry.
- Open the Run utility in the Start menu.
- Enter REGEDIT in the Open field and click Ok.
- Browse to the DSN_name folder where DSN_name is
your data source name.
The location of this folder depends on which version of Windows you are using.
- 64-bit Windows
- HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\DSN_name
- 32-bit Windows
- HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\DSN_name
- Create a String Value in your DSN_name folder.
Right-click on your DSN_name folder and select New > String Value.
- Enter
ColumnsAsChar
as the name of your new String Value. - Right-click on the
ColumnsAsChar
value and select Modify. - Enter a value of
1
in the Value data field and click Ok. - Repeat this process and create another String
Value with
ColumnSizeAsCharacter
as the name, and a value of1
in the Value data field.