Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Starting and Connecting to Your Database » Connection parameters and network protocol options » Connection parameters

 

LogFile connection parameter [LOG]

Sends client error messages and debugging messages to a file.

Usage

Anywhere

Values

String

Default

No log file.

Remarks

If you want to save client error messages and debugging messages in a file, use the LogFile (LOG) connection parameter.

If the file name does not include a path, it is relative to the current working directory of the client application.

The LogFile (LOG) connection parameter is connection-specific, so from a single application you can set different LogFile arguments for different connections.

Typical log file contents are as follows:

Mon Aug 28 2006 12:29:46
12:29:46 Attempting to connect using:
UID=DBA;PWD=********;DBF='C:\Documents and Settings\All Users\Documents\SQL 
Anywhere 11\Samples\demo.db';ENG=demo11;START='C:\Program Files\
SQL Anywhere 11\bin32\dbeng11.exe';CON='Sybase Central 1';
ASTOP=YES;LOG=c:\mylog.txt
12:29:46 Attempting to connect to a running server...
12:29:46 Trying to start SharedMemory link ...

12:29:46 SharedMemory link started successfully

12:29:46 Attempting SharedMemory connection (no sasrv.ini cached address)

12:29:46 Failed to connect over SharedMemory

12:29:46 No server found, attempting to run START line...
12:29:47 Autostarted server, attempting to connect using:
UID=DBA;PWD=********;DBF='C:\Documents and Settings\All Users\Documents\
SQL Anywhere 11\Samples\demo.db';ENG=demo11;START='C:\Program Files\
SQL Anywhere 11\bin32\dbeng11.exe';CON='Sybase Central 1';ASTOP=YES
12:29:47 Attempting SharedMemory connection (no sasrv.ini cached address)

12:29:47 Connected to server over SharedMemory

12:29:47 Connected to SQL Anywhere Server version 11.0.0.2456
12:29:47 Application information:
12:29:47 IP=10.25.99.227;HOST=mymachine-XP;OS='Windows XP Build 2600 
Service Pack 2';PID=0x21c;THREAD=0xa38;EXE='C:\Program Files\
SQL Anywhere 11\bin32\scjview.exe';VERSION=11.0.0.2456;
API=iAnywhereJDBC;TIMEZONEADJUSTMENT=-240
12:29:47 Connected to the server, attempting to connect to a
         running database...
12:29:48 [    1] Connected to database successfully
12:29:53 [    1] The number of prefetch rows has been reduced to 168 due 
                 to the prefetch buffer
12:29:53 [    1] limit. Consider using the PrefetchBuffer connection parameter.
See also
Example

The following command line starts Interactive SQL, connecting to the sample database with a LogFile (LOG) connection parameter:

dbisql -c "DSN=SQL Anywhere 11 Demo;LOG=d:\logs\test.txt"