ODBC tracing! No Info

Hi I know I should be able to find this out myself , but both book I have don't seem to know and the online helps isn't much better.

I want to find out if ODBC tracing is on or off, and if it is on I want to be able to turn it off.

How can I do this? I just can't find any Info on it!

Thanks Ed

P.S. If their was a Icon for simpleton, I would use it!ODBC Tracing? I'm not sure what you are talking about. You can get server and connection information with these commands:

sp_configure
SQLGetConnectAttr
SQLSetConnectAttr

blindman|||Originally posted by blindman
ODBC Tracing? I'm not sure what you are talking about. You can get server and connection information with these commands:

sp_configure
SQLGetConnectAttr
SQLSetConnectAttr

blindman



My orginal problem was that EM runs really slowely when looking a propeties. So I searched through the existing threads to try and find out what the problem and one of the suggestion was that I may have ODBC tracing turned on and that could be slowing down the system, but I could not find a way see if ODBC tracing was on or off.

I thought it was on a setting withine the database , now figured it out by talking to the other in the office, sorry, thanks anyway!|||odbc tracing is in admin tools/datasource configuration. it comes very handy by allowing to see what actual statements are issued by the driver manager. poobah probably never used it :)|||Nope. I haven't. My expertise is in database design, transact sql programming, and query optimization. I know a fair amount about database tuning and administration, but in general I leave those posts to others to answer.

Like nixies, I couldn't find anything in Books Online referencing this configuration. Is it strictly middle-tier or interface resident?

blindman|||all sql server client tools are using odbc driver manager one way or the other. below is a sample set of entries from the log file if you turn tracing on in your data sources tracing tab:

SQL Server Ente 7b4-794 ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 01B471D4

SQL Server Ente 7b4-794 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 0x01B471D4 ( 0x01a31540)

SQL Server Ente 7b4-794 ENTER SQLSetEnvAttr
SQLHENV 01A31540
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003
SQLINTEGER -5

if tracing is turned on the performance of that workstation deteriorates. as an example i turned it on and opened em and expanded a server (in a sense connected to it). within a minute after it i turned tracing off. the resulting file size was 472K. mind you i didn't do anything other than what i described, - connected to the server and nothing else.|||Now I see. So its a workstation setting, not a server setting.

Thanks

blindman|||not necessarily, you can do the same thing on the server.