February 3, 2002 at 3:14 am
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-668ENTER SQLSetEnvAttr
SQLHENV 00891520
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003
SQLINTEGER -5
n 5e4-668EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 00891520
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER -5
......
February 3, 2002 at 8:03 am
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