EasyManua.ls Logo

Sybase Adaptive Server Anywhere - Page 75

Sybase Adaptive Server Anywhere
1182 pages
Print Icon
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Loading...
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

Table of Contents

Related product manuals