ODBC Drivers for Windows

On Windows platforms, a Microsoft ODBC Data Source Administrator should be used to configure a Data Source Name (DSN) for a particular driver and a particular connection.

On 64-bit Windows platforms, there are 32-bit and 64-bit versions of the MS ODBC Data Source Administrator. The version choice for MS ODBC Data Source Administrator is explained below.

See also some general information on the use of ODBC Drivers with the Database Capture Point.

Driver installation

Microsoft Windows includes Microsoft SQL Server Native Client by default. Client drivers for Oracle and DB2 can be obtained from the corresponding vendors. The "bitness" of the driver (32-bit or 64-bit) should match the bitness of the Interaction Server executable.

The ODBC drivers have been installed and tested to work with the integrated Database Capture Point on Microsoft Windows.

MSSQL	Oracle	DB2
Windows 2003 x86: NCl 2005.90.3042.00 Cl 2000.86.3959.00 Windows 2008 x64: NativeClient 10.0 Client 6.01.7600	InstantClient 11.2 Client Shared Library 64-bit - 11.2.0.2.0	IBM Data Server Driver For ODBC and CLI 9.7.3 and 9.7.4 latest FixPacks

ODBC configuration on 32-bit platforms

To configure the ODBC on 32-bit platforms, run MS ODBC Data Source Administrator (%WINDIR%\System32\odbcad32.exe). Add the User DSN with the corresponding driver.

Important

When Interaction Server runs as a Service, by default it starts from the System account. If you want to start Interaction Server manually as a Service, do one of the following:

• Use the System DSN rather than a User DSN.
• Go to Administrative Tools > Services > Log On and change the Log on as: setting from Local System account to This account.

ODBC configuration on 64-bit platforms

Run MS ODBC Data Source Administrator for 32-bit drivers from %WINDIR%\SysWOW64\odbcad32.exe. For 64-bit drivers (and the Interaction Server executable), run from %WINDIR%\System32\odbcad32.exe.