Progress
DataServer for
Microsoft SQL Server
Guide


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 Progress-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 6–1 lists the Progress-supplied ODBC startup options and the corresponding startup options defined in the ODBC interface.

Table 6–1: ODBC Options 
Progress-supplied Option
ODBC-defined Option
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
NOSCAN
SQL_NOSCAN
OPT_TRACE
SQL_OPT_TRACE
QUERY_TIMEOUT
SQL_QUERY_TIMEOUT
TXN_ISOLATION
SQL_TXN_ISOLATION

Refer to an ODBC application developer’s guide for information on the ODBC-defined options.

When you specify a Progress-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 Progress 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 the ODBC Programmer’s Reference for more information on these options.


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