我正在试图找出生成一个名为C:\SQL.LOG的日志文件的内容,该文件的大小已经增长到了4G。文件的内容如下所示:
fserver 398-408 ENTER SQLDescribeCol
HSTMT 019BF798
UWORD 16
UCHAR * 0x0465F100
SWORD 256
SWORD * 0x0465F0FE
SWORD * 0x0465F0F4
SQLULEN * 0x0465F0EC
SWORD * 0x0465F0F8
SWORD * 0x0465F0F2
cfserver 398-408 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 019BF798
UWORD 16
UCHAR * 0x0465F100 [ 8] "emp_temp"
SWORD 256
SWORD * 0x0465F0FE (8)
SWORD * 0x0465F0F4 (-7)
SQLULEN * 0x0465F0EC (1)
SWORD * 0x0465F0F8 (0)
SWORD * 0x0465F0F2 (1)
cfserver 398-408 ENTER SQLDescribeCol
HSTMT 019BF798
UWORD 17
UCHAR * 0x0465F100
SWORD 256
SWORD * 0x0465F0FE
SWORD * 0x0465F0F4
SQLULEN * 0x0465F0EC
SWORD * 0x0465F0F8
SWORD * 0x0465F0F2
cfserver 398-408 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 019BF798
UWORD 17
UCHAR * 0x0465F100 [ 12] "emp_seasonal"
SWORD 256
SWORD * 0x0465F0FE (12)
SWORD * 0x0465F0F4 (-7)
SQLULEN * 0x0465F0EC (1)
SWORD * 0x0465F0F8 (0)
SWORD * 0x0465F0F2 (1)
cfserver 398-408 ENTER SQLDescribeCol
HSTMT 019BF798
UWORD 18
UCHAR * 0x0465F100
SWORD 256
SWORD * 0x0465F0FE
SWORD * 0x0465F0F4
SQLULEN * 0x0465F0EC
SWORD * 0x0465F0F8
SWORD * 0x0465F0F2
cfserver 398-408 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 019BF798
UWORD 18
UCHAR * 0x0465F100 [ 9] "emp_notes"
SWORD 256
SWORD * 0x0465F0FE (9)
SWORD * 0x0465F0F4 (-10)
SQLULEN * 0x0465F0EC (1073741823)
SWORD * 0x0465F0F8 (0)
SWORD * 0x0465F0F2 (1)
cfserver 398-408 ENTER SQLDescribeCol
HSTMT 019BF798
UWORD 19
UCHAR * 0x0465F100
SWORD 256
SWORD * 0x0465F0FE
SWORD * 0x0465F0F4
SQLULEN * 0x0465F0EC
SWORD * 0x0465F0F8
SWORD * 0x0465F0F2
cfserver 398-408 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 019BF798
UWORD 19
UCHAR * 0x0465F100 [ 12] "emp_firstaid"
SWORD 256
SWORD * 0x0465F0FE (12)
SWORD * 0x0465F0F4 (-7)
SQLULEN * 0x0465F0EC (1)
SWORD * 0x0465F0F8 (0)
SWORD * 0x0465F0F2 (1)
cfserver 398-408 ENTER SQLDescribeCol
HSTMT 019BF798
UWORD 20
UCHAR * 0x0465F100
SWORD 256
SWORD * 0x0465F0FE
SWORD * 0x0465F0F4
SQLULEN * 0x0465F0EC
SWORD * 0x0465F0F8
SWORD * 0x0465F0F2
cfserver 398-408 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 019BF798
UWORD 20
UCHAR * 0x0465F100 [ 10] "emp_active"
SWORD 256
SWORD * 0x0465F0FE (10)
SWORD * 0x0465F0F4 (-7)
SQLULEN * 0x0465F0EC (1)
SWORD * 0x0465F0F8 (0)
SWORD * 0x0465F0F2 (1)
cfserver 398-408 ENTER SQLDescribeCol
HSTMT 019BF798
UWORD 21
UCHAR * 0x0465F100
SWORD 256
SWORD * 0x0465F0FE
SWORD * 0x0465F0F4
SQLULEN * 0x0465F0EC
SWORD * 0x0465F0F8
SWORD * 0x0465F0F2
cfserver 398-408 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 019BF798
UWORD 21
UCHAR * 0x0465F100 [ 12] "emp_birthday"
SWORD 256
SWORD * 0x0465F0FE (12)
SWORD * 0x0465F0F4 (-9)
SQLULEN * 0x0465F0EC (4)
SWORD * 0x0465F0F8 (0)
SWORD * 0x0465F0F2 (1)
cfserver 398-408 ENTER SQLDescribeCol
HSTMT 019BF798
UWORD 22
UCHAR * 0x0465F100
SWORD 256
SWORD * 0x0465F0FE
SWORD * 0x0465F0F4
SQLULEN * 0x0465F0EC
SWORD * 0x0465F0F8
SWORD * 0x0465F0F2
cfserver 398-408 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 019BF798
UWORD 22
UCHAR * 0x0465F100 [ 19] "emp_anniversary_old"
SWORD 256
SWORD * 0x0465F0FE (19)
SWORD * 0x0465F0F4 (-9)
SQLULEN * 0x0465F0EC (8)
SWORD * 0x0465F0F8 (0)
SWORD * 0x0465F0F2 (1)
cfserver 398-408 ENTER SQLDescribeCol
HSTMT 019BF798
UWORD 23
UCHAR * 0x0465F100
SWORD 256
SWORD * 0x0465F0FE
SWORD * 0x0465F0F4
SQLULEN * 0x0465F0EC
SWORD * 0x0465F0F8
SWORD * 0x0465F0F2
cfserver 398-408 EXIT SQLDescribeCol with return code 0 (SQL_SUCCESS)
HSTMT 019BF798
UWORD 23
UCHAR * 0x0465F100 [ 15] "emp_anniversary"
SWORD 256
SWORD * 0x0465F0FE (15)
SWORD * 0x0465F0F4 (11)
SQLULEN * 0x0465F0EC (23)
SWORD * 0x0465F0F8 (3)
SWORD * 0x0465F0F2 (1)发布于 2015-10-08 13:57:50
这是一个ODBC日志。见踪274551如何使用ODBC数据源管理器生成ODBC跟踪。
长话短说,检查HKEY_CURRENT_USER\Software\ODBC\ODBC.ini\ODBC并将键Trace从1更改为0。
https://dba.stackexchange.com/questions/117440
复制相似问题