首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >什么可以生成这个SQL.LOG文件?

什么可以生成这个SQL.LOG文件?
EN

Database Administration用户
提问于 2015-10-08 13:55:08
回答 1查看 35关注 0票数 0

我正在试图找出生成一个名为C:\SQL.LOG的日志文件的内容,该文件的大小已经增长到了4G。文件的内容如下所示:

代码语言:javascript
复制
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)
EN

回答 1

Database Administration用户

回答已采纳

发布于 2015-10-08 13:57:50

这是一个ODBC日志。见踪274551如何使用ODBC数据源管理器生成ODBC跟踪

长话短说,检查HKEY_CURRENT_USER\Software\ODBC\ODBC.ini\ODBC并将键Trace从1更改为0。

票数 2
EN
页面原文内容由Database Administration提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://dba.stackexchange.com/questions/117440

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档