SQL.txt will exist in my C:\

  • When I execute my SQLServer(SQL2000) in my local computer,I find a file, which is "SQL.txt" will exist in my C:\.This file can incremental itself and I feel the performance of my SQLServer getting slow.How to solve this problem? The content of "SQL.txt" is:

    n 5e4-668 ENTER SQLAllocHandle

    SQLSMALLINT 1 <SQL_HANDLE_ENV>

    SQLHANDLE 00000000

    SQLHANDLE * 0012EBF4

    n 5e4-668 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)

    QLSMALLINT 1 <SQL_HANDLE_ENV>

    SQLHANDLE 00000000

    SQLHANDLE * 0x0012EBF4 ( 0x00891520)

    n 5e4-668 ENTER SQLSetEnvAttr

    SQLHENV 00891520

    SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>

    SQLPOINTER 0x00000003

    SQLINTEGER -5

    n 5e4-668 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)

    SQLHENV 00891520

    SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>

    SQLPOINTER 0x00000003 (BADMEM)

    SQLINTEGER -5

    ......

  • I think its a ODBC trace file - check your DSN utility to see if tracing is turned on.

    Andy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply