Set up the IDOL Host Machines

To communicate with the SQL server, you must install an SQL driver (for your server type), and you must install an ODBC driver manager on the IDOL host machines.

Install the SQL Driver and Manager for Microsoft SQL Server

Microsoft Windows comes with SQL Server drivers by default. You can use odbcad32.exe (in WindowsDirectory\system32) to verify that SQL Server Native Client 10.0 is installed.

For SQL Server 2008 SP3, you can download the driver from the Microsoft Web site:

http://www.microsoft.com/en-us/download/details.aspx?id=27596

NOTE:

You might need a different version of the ODBC drivers if you are using a different edition of SQL Server.

UNIX machines can use the open-source FreeTDS driver to connect to Microsoft SQL Server. A driver developed by Microsoft also exists, targeted at Red Hat Enterprise Linux. This example uses FreeTDS, which can be obtained from the following Web site:

http://www.freetds.org/

Download the driver distribution, and then read, edit, and run the following commands.

  1. Unzip the package:

    tar –zxf freetds-stable.tgz
  2. Use the following commands to build the driver:

    cd freetds-0.91
    ./configure --prefix=YourFileDirectory --with-tdsver=8.0
    make
    make install

These commands copy the drivers to your prefix directory. The driver itself is copied to

Prefix/lib/libtdsodbc.so

You can reference this driver in your connection string when configuring IDOL. For more information, see Configure IDOL Components.

For example:

ConnectionString=Driver=/freetds/inst/lib/libtdsodbc.so;TDS_Version=7.0;Server=myserverhostname\SQLEXPRESS;Port=56841;UID=idol;PWD=password;

Check the Installed Drivers

Use the following procedures to check the installed drivers.

NOTE:

You can use the Windows user interface to find the installed drivers for the Microsoft SQL Server back end.

To check the installed drivers on Linux and UNIX ODBC

To find a list of drivers on Windows

  1. Run the following command to open the driver manager:

    %windir%\system32\odbcad32.exe
  2. In the driver manager, review the information on the Drivers tab. The following driver is required:

    SQL Server Native Client 10.0


_HP_HTML5_bannerTitle.htm