Community Component 25.1
Community Component Help

# Set up the Knowledge Discovery 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 Knowledge Discovery 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 Knowledge Discovery. For more information, see Configure Knowledge Discovery 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

Copyright 2024 Open Text
Version 25.1 | Last updated January 2025

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: Knowledge Discovery Community Component 25.1

Topic Title: Set up the Knowledge Discovery Host Machines