Release 10.1A: OpenEdge Data Management:
DataServer for Microsoft SQL Server

> ## ODBC options

> The DataServer allows access to selected options defined in the ODBC interface by providing corresponding options that you can use with the `-Dsrv` startup parameter. Each OpenEdge-supplied ODBC option has a name of the form `option–name` and corresponds with a startup option in the ODBC interface having the name SQL_`option–name`. Table 8–1 lists the OpenEdge-supplied ODBC startup options and the corresponding startup options defined in the ODBC interface.

> Table 8–1: ODBC options
> OpenEdge-supplied option | ODBC-defined option1
> --- | ---
>     ACCESS_MODE
>     SQL_ACCESS_MODE
>     ASYNC_ENABLE
>     SQL_ASYNC_ENABLE
>     AUTOCOMMIT
>     SQL_AUTOCOMMIT
>     LOGIN_TIMEOUT
>     SQL_LOGIN_TIMEOUT
> MAX_LENGTH |
>     SQL_MAX_LENGTH
>     MAX_ROWS
>     SQL_MAX_ROWS
>     MSS_PRESERVE_CURS
>     SQL_MSS_PRESERVE_CURS2
>     NOSCAN
>     SQL_NOSCAN
>     OPT_TRACE
>     SQL_OPT_TRACE
>     PACKET_SIZE
>     SQL_PACKET_SIZE
>     QUERY_TIMEOUT
>     SQL_QUERY_TIMEOUT
>     RESP_POLLCT
>     SQL_RESP_POLLCT
>     RESP_TIMEOUT
>     SQL_RESP_TIMEOUT
>     TXN_ISOLATION
>     SQL_TXN_ISOLATION

> 1Refer to an ODBC application developer’s guide for information on the ODBC-defined options. 2Cursor preservation allows server side cursors to be preserved beyond the transaction boundary. See the "Preserve cursors: The -Dsrv MSS_PRESERVE_CURS,1 option" section for information and warnings.

> When you specify an OpenEdge-supplied ODBC option with the `-Dsrv` startup parameter, the DataServer sends the option to the ODBC driver for processing by the ODBC interface.

> The following example of the `-Dsrv` startup parameter tells the ODBC driver to return no more than 1,000 rows to the OpenEdge application:

>     -Dsrv MAX_ROWS,1000

> Note: The DataServer generally sets the correct value automatically. Therefore, you should reserve use of the ODBC options for troubleshooting and fine-tuning purposes only. See ODBC Programmer’s Reference for more information on these options.

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