Thanks, David.
It was just what I was after.  

Regards,
Ken.

-----Original Message-----

Date: Tue, 20 Jul 2010 14:13:24 +1000
From: "Hona, David" <david.h...@cba.com.au>
To: 'U2 Users List' <u2-users@listserver.u2ug.org>
Subject: Re: [U2] Tracing ODBC requests
Message-ID:
        <297b19fd90fdb14da1c8ceff0b6cffe76785e3f...@vaunsw139.au.cbainet.com>
Content-Type: text/plain; charset="iso-8859-1"

Hello Ken,

Check out the API Supplement PDF (apisupp.pdf)

Try this... haven't used it for a long time...I believe ODBC connections go via 
"uvserver". Last time I used was for "uvcs" though, I can't recall it actually 
works for ODBC connections. You can also get your remote system to invoke a 
stored procedure to your UV 

Regards
David

Extracted out of the PDF:

Logging Client Connections
Beginning at UniVerse 10.0, a server-side debugging log is available for 
tracking client connections.
The debugging log is located in the /tmp/ directory on UNIX, or C:\tmp on 
Windows platforms, by default.
Complete the following steps to set up the debugging log:

1.Edit the serverdebug file in the UVHOME directory.

2.In the first column, enter uvcs, indicating that you want to log the 
connection progress for both uvapi_server and uvapi_slave.

3.In the next column, enter an integer indicating the level of logging 
information you want to maintain. The valid integers are:

0 - No debugging.
1 - Captures information about the startup connection only.
9 - Captures information about every call.

4.In the third column, enter the full path for the log file location. If this 
value does not exist, the logs are written to /tmp/uvapiserver_###.log as the 
default on UNIX systems, or C:\tmp\uvapiserver####.log as the default on 
Windows systems. #### is the uvapi_server process ID.

#####################################################################################
This email (inc all attachments) is for the use of the intended recipient(s) 
only.
Privileged or confidential information may be contained in this communication. 
If you have received this email in error, please notify the sender immediately 
and then
delete all copies of this message from your computer network. If you are not the
intended recipient, you must not keep, use, disclose, copy or distribute this 
email
without the author's prior permission. If you are the intended recipient and 
you do
not wish to receive similar electronic messages from us in future, then please
respond to the sender to this effect.

We have taken precautions to minimise the risk of transmitting software 
viruses, but
advise you to carry out your own virus checks on this email and its 
attachments. We
do not accept liability for any loss or damage caused by software viruses and 
do not
represent that this transmission is free from viruses or other defects. 

FirstMac Limited (ABN 59 094 145 963)  (AFSL 290600)
#####################################################################################
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to