Chapter 3 Connection and Communication Parameters
57
If you are having trouble establishing a connection to a network server, set
the Debug connection parameter to Yes and the Logfile parameter to a log
file name. Diagnostic information is then placed in the log file.
The DEBUG connection parameter is connection-specific, so from a single
application you can set DEBUG=ON on one connection and OFF on another,
or set DEBUG=ON on both but log to different files.
♦ The following data source fragment says to use the Debug switch, with
output to a file named
error.log
.
...
DBG=Yes;
Log=ERROR.LOG
...
DisableMultiRowFetch connection parameter [DMRF]
To turn off multi-row fetches across the network
Anywhere
No
By default, when the database server gets a simple fetch request, the
application asks for extra rows. You can disable this behavior by setting this
parameter to ON.
$ For more information, see "Using cursors in procedures and triggers"
on page 471 of the book ASA User’s Guide.
$ Setting the DisableMultiRowFetch parameter to ON is equivalent to
setting the PREFETCH option to OFF. For more information, see
"Prefetching rows" on page 278 of the book ASA User’s Guide.
♦ The following connection string fragment prevents prefetching:
DMRF=Yes
EngineName connection parameter [ENG]
Synonym for ServerName. The name of a running database server to which
you want to connect.
Network servers or running personal servers.
The default local database server.
Description
Examples
Function
Usage
Default
Description
Examples
Function
Usage
Default