Results 1 to 8 of 8
  1. #1
    Join Date
    Jul 2003
    Posts
    100

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

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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

  3. #3
    Join Date
    Jul 2003
    Posts
    100
    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!

  4. #4
    Join Date
    Sep 2003
    Posts
    522
    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

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    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

  6. #6
    Join Date
    Sep 2003
    Posts
    522
    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.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Now I see. So its a workstation setting, not a server setting.

    Thanks

    blindman

  8. #8
    Join Date
    Sep 2003
    Posts
    522
    not necessarily, you can do the same thing on the server.

Posting Permissions

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