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