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
|
|
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 |
Referenced by...