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