How to trace SQL

Hi,

I'm trying to debug a vendor package and would like to turn on JDBC trace (either client or server side). The only information I found is DBCC TRACE which seems not very useful (I even don't know where the trace result located). Any help is appreciated!

Env: Windows Server 2003 & SQL Server 2000 8.00.818.

Jeff Liperhaps you could use the profiler and run it on the server to see what/when sql-commands are given?|||Unfortunately, the profile won't give me enough information for why a function (xa_open) failed.

thanks,

Jeff Li|||Open a DSN trace on the client?

-PatP|||Hi, Pat:

How can I open the DSN trace on a client?

thanks,

Jeff|||When creating an ODBC DSN, the last dialog page (with the Finish button) usually has the log file information on it.

You can also do it using a connection string or dynamcially using SQLSetConnectAttr, but I don't remember the parameter names for either of them.

-PatP