Progress
DataServer
for ODBC Guide


Tuning Your Environment with the -Dsrv Startup Parameter

The DataServer (-Dsrv) startup parameter allows you to use special ODBC or DataServer options to tune your environment. You pass these options as arguments to -Dsrv when connecting to an ODBC data source.

There are two versions of the syntax, as follows:

SYNTAX
CONNECT data-source-name -ld logical-name -dt ODBC 
-Dsrv arg1,val1 -Dsrv arg2,val2 -Dsrv arg3,val3... 

SYNTAX
CONNECT data-source-name -ld logical-name -dt ODBC
-Dsrv arg1,val1,arg2,val2,arg3,val3... 

In this syntax:

Here is an example of how to use the CONNECT statement with the -Dsrv parameter:

CONNECT mssql_db -ld mydb -Ux -Py
   -Dsrv qt_debug,EXTENDED
   -Dsrv PRGRS_IDBUF,100
   -Dsrv PRGRS_MINBUF,10000
   -Dsrv MAX_R,10000. 

Note that MAX_R is an abbreviation of MAX_ROWS. You can abbreviate option names as long as they identify parameters uniquely.

Both the syntax statements and the example show the use of the -Dsrv startup parameter in CONNECT statements. You can also specify -Dsrv options in a parameter file, on a program item command line, or in the Connection Parameters field in the Database Connect dialog box.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095