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
Showing posts with label debug. Show all posts
Showing posts with label debug. Show all posts
Monday, March 26, 2012
Sunday, February 19, 2012
How to step trough procedure in Debugger
I want to debug a procedure in Query analyzer. When I open the T-SQL debugger and add all the passing parameters the debugger runs very fast and the message shows "@.RETURN_VALUE = 0".
How can I toggle breakpoints and step trough each line of the scripts. The STEP INTO, STEP OVER, RUN TO THE CURSOR all are disabled. The Name and the values are not displayed.
Please help.
ThanksQ1 How can I toggle breakpoints and step trough each line of the scripts. The STEP INTO, STEP OVER, RUN TO THE CURSOR all are disabled. The Name and the values are not displayed.
A1 First, make sure debugger support was installed on your development Sql Server. (What you are describing may be a dev workstation with VB / VStudio installed running against a dev server that does not have debugging support installed?)
Note: It is advisable NOT to run the dubugger against a production server. The debugger can be very resource intensive (especially with regard to locked resources) and the debugger is NOT bug free.
A link to more information:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;310650|||SQL Server service must be logged on as non-System account:
Configure DCOM:
run dcomcnfg.exe
check DCOM settings (App.name is sqldbgreg)
For more see BOL "Troubleshooting the Transact-SQL Debugger" topic
How can I toggle breakpoints and step trough each line of the scripts. The STEP INTO, STEP OVER, RUN TO THE CURSOR all are disabled. The Name and the values are not displayed.
Please help.
ThanksQ1 How can I toggle breakpoints and step trough each line of the scripts. The STEP INTO, STEP OVER, RUN TO THE CURSOR all are disabled. The Name and the values are not displayed.
A1 First, make sure debugger support was installed on your development Sql Server. (What you are describing may be a dev workstation with VB / VStudio installed running against a dev server that does not have debugging support installed?)
Note: It is advisable NOT to run the dubugger against a production server. The debugger can be very resource intensive (especially with regard to locked resources) and the debugger is NOT bug free.
A link to more information:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;310650|||SQL Server service must be logged on as non-System account:
Configure DCOM:
run dcomcnfg.exe
check DCOM settings (App.name is sqldbgreg)
For more see BOL "Troubleshooting the Transact-SQL Debugger" topic
Subscribe to:
Posts (Atom)