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.
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:
Download the driver distribution, and then read, edit, and run the following commands.
Unzip the package:
tar –zxf freetds-stable.tgz
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;
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
odbcinst -d -q
To find a list of drivers on Windows
Run the following command to open the driver manager:
%windir%\system32\odbcad32.exe
In the driver manager, review the information on the Drivers tab. The following driver is required:
SQL Server Native Client 10.0
|