8.2.9.TDS
The TDS Agent supercedes the Sybase and SQLServer database agents. Although they share a common connection mechanism there are some subtle value differences that must be observed.
TDS provides a number of environment variables for configuring database clients, a typical set used for successfully connecting your database agent to a SQL Server are tabulated below:
Table8.8.Default Rule Book settings
|
Rule Book Section & parameters |
Default Rule Book Settings |
Notes |
|---|---|---|
|
[Environment SQLServer 2000] |
The section name will vary with the agent version and database version. |
|
|
FREETDSCONF= |
/home/openlink/bin/freetds.conf |
|
|
DSQUERY= |
SQLSERVER |
Load this section from the freetds.conf file. |
|
TDSHOST= |
sqlsrv |
Point this to your SQL Server /Sybase machine |
|
TDSPORT= |
1433 |
The port on which you SQL Server/Sybase listens for incoming connections. SQL Server uses port 1433 by default, however Sybase uses 4100. |
|
TDSVER= |
7.0 |
The required TDS connectivity version. Refer to the table below. |
|
SQLSERVER_CATALOG= |
Y |
|
|
CURSOR_SENSITIVITY= |
LOW |
You can set this to HIGH after loading oplrvc.sql |
The TDSVER option above must be set correctly for connection to the desired database. Use the following table to find which.
Table8.9.TDSVER settings
|
Version Number |
Database Supported |
|||||
|---|---|---|---|---|---|---|
|
4.2 |
|
|||||
|
4.6 |
|
|||||
|
5.0 |
|
|||||
|
7.0 |
|
|||||
|
8.0 |
|
|||||
|
9.0 |
|