Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

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

> Table 6–1: ODBC options
> OpenEdge-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 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.

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