Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

> ## 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:

> - The schema holder is already connected.

> - The `data–source–name` argument is the name of the data source and the `logical–name` argument is its logical name, which is defined when you created your schema image.

> - You pass the options as the `argn`,`valn` pairs.

> 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095