Sends client error messages and debugging messages to a file.
Anywhere
String
No log file.
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. |
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" |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |