%META:TOPICPARENT{name="ServerAgentAdministration"}%

=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**  |
|  <code>[Environment SQLServer 2000]</code>  |  | The section name will vary with the agent version and database version.  |
|  <code>FREETDSCONF</code>  |  <code>/home/openlink/bin/freetds.conf</code>  |  |
|  <code>DSQUERY</code>  |  <code>SQLSERVER</code>  | Tells the driver what section of the <code>freetds.conf</code> file applies to these connections.  |
|  <code>TDSHOST</code>  |  <code>sqlsrv</code>  | Tells the driver what host your SQL Server/Sybase instance is on.  |
|  <code>TDSPORT</code>  |  <code>1433</code>  | 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.  |
|  <code>TDSVER</code>  |  <code>7.0</code>  | Tells the driver what version of TDS to use, based on the SQL Server version.  Refer to the table below.  |
|  <code>SQLSERVER_CATALOG</code>  |  <code>Y</code>  | |
|  <code>CURSOR_SENSITIVITY</code>  |  <code>LOW</code>  | You can set this to <code>HIGH</code> after loading <code>oplrvc.sql</code>. |

The <code>TDSVER</code> option above must be set correctly for connection to the desired database. Use the following table to find which.

==Table 2. TDSVER settings==

|=  **<code>TDSVER</code> or <code>-V</code> 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 %BR% Sybase ASA (Adaptive Server Anywhere) 7.x, 8.x, 9.x %BR% Sybase SQL Anywhere 6.x, 10.x, 11.x %BR% 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  |