Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2004
    Posts
    4

    Unanswered: 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 Li

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    perhaps you could use the profiler and run it on the server to see what/when sql-commands are given?

  3. #3
    Join Date
    Jun 2004
    Posts
    4
    Unfortunately, the profile won't give me enough information for why a function (xa_open) failed.

    thanks,

    Jeff Li

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Open a DSN trace on the client?

    -PatP

  5. #5
    Join Date
    Jun 2004
    Posts
    4
    Hi, Pat:

    How can I open the DSN trace on a client?

    thanks,

    Jeff

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •