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