Progress
DataServer
for ODBC Guide


ODBC Options

The DataServer allows you 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
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

Refer to any good 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