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. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Tuesday, 20 July 2010 1:35 PM To: u2-users@listserver.u2ug.org Subject: [U2] Tracing ODBC requests Hello List Members. Can anyone suggest a way to log the SQL requests sent via ODBC to the Universe DB (from a MS Windows client to a AIX based Universe DB). I suppose I want the commands processed by the uvapi_slave process. I have tried capturing them via the LOGIN paragraph to no avail. Any help would be appreciated. The manuals, as is often the case, were unhelpful. Regards, Ken Ford Software Engineer - Universe Phone: 07 3013 8605 Fax: 07 3002 8400 Email: ken.f...@firstmac.com.au Web: www.firstmac.com.au ************** IMPORTANT MESSAGE ***************************** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ************************************************************** _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users