TDS-based Sybase & Microsoft SQL Server Agent Administration

The TDS-based Agent has replaced the old-style DB-Lib- and CT-Lib-based Sybase and SQLServer Database Agents and Lite Drivers.

A number of environment variables may be used in configuring database clients.

Table 1. 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 Tells the driver what section of the freetds.conf file applies to these connections.
TDSHOST sqlsrv Tells the driver what host your SQL Server/Sybase instance is on.
TDSPORT 1433 Tells the driver what port your SQL Server/Sybase instance listens to for incoming connections. SQL Server uses port 1433 by default; Sybase uses 4100.
TDSVER 7.0 Tells the driver what version of TDS to use, based on the SQL Server 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.

Table 2. TDSVER settings

TDSVER or -V Value

Database Versions Supported

Actual TDS Protocol Version

4.2 Microsoft SQL Server 4.x, 6.x 4.2
4.6 Sybase SQL Server 4.x 4.2
5.0 Sybase ASE (Adaptive Server Enterprise) 11.x, 12.x, 15.x
Sybase ASA (Adaptive Server Anywhere) 7.x, 8.x, 9.x
Sybase SQL Anywhere 6.x, 10.x, 11.x
Sybase SQL Server 10.x, 11.x
5.0
7.0 Microsoft SQL Server 7.x 7.0
8.0 Microsoft SQL Server 2000 (v.8.x) 7.1
9.0 Microsoft SQL Server 2005 (v.9.x) 7.2
10.0 Microsoft SQL Server 2008 (v.10.x) 7.3