Open topic with navigation

# 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

- In your terminal (not in an SQL client), type the following command to list the available drivers:

      odbcinst -d -q

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

© 2016 Hewlett Packard Enterprise Development LP | Send documentation feedback to HPE Close Send Documentation Feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to AutonomyTPFeedback@hpe.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_HP_HTML5_bannerTitle.htm