Creating the system data source on Windows

You must create a data source after you create the exceptions database.

Procedure

  1. Open the Windows ODBC administrator with the following command:
    start C:\Windows\SysWOW64\odbcad32.exe
  2. Select the System DSN tab.
  3. Click the Add button.
  4. Select the IBM Wire Protocol driver for the database where the exceptions database is located, and click Finish.
  5. Set the DSN name to the same value that you specified for the managedDataSourceName repository property.
  6. Click Test Connect to verify that the data source is configured correctly.
  7. If you use SQL Server to create the exceptions database, select the Advanced tab and click the Enable Quoted Identifiers option.
  8. 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.
    1. Open the Run utility in the Start menu.
    2. Enter REGEDIT in the Open field and click Ok.
    3. 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
    4. Create a String Value in your DSN_name folder.
      Right-click on your DSN_name folder and select New > String Value.
    5. Enter ColumnsAsChar as the name of your new String Value.
    6. Right-click on the ColumnsAsChar value and select Modify.
    7. Enter a value of 1 in the Value data field and click Ok.
    8. Repeat this process and create another String Value with ColumnSizeAsCharacter as the name, and a value of 1 in the Value data field.