设置ODBC日志

ODBC日志设置

查看ODBC配置

[root@localhost~]# odbcinst -j 
unixODBC 2.3.7 
DRIVERS............: /etc/odbcinst.ini 
SYSTEM DATA SOURCES: /etc/odbc.ini 
FILE DATA SOURCES..: /etc/ODBCDataSources 
USER DATA SOURCES..: /root/.odbc.ini 
SQLULEN Size.......: 8 
SQLLEN Size........: 8 
SQLSETPOSIROW Size.: 8 

配置ODBC日志

更改odbcinst.ini 配置文件，在[ODBC]下添加trace和tracefile参数

[root@upright91 ~]# cat /etc/odbcinst.ini 
[ODBC] 
Trace=YES 
TraceFile=/root/C/odbc.log     #ODBC日志路径

[PostgreSQL] 
Description=ODBC for PostgreSQL 
Driver=/usr/lib/psqlodbcw.so 
Setup=/usr/lib/libodbcpsqlS.so 
Driver64=/usr/lib64/psqlodbcw.so 
Setup64=/usr/lib64/libodbcpsqlS.so 
FileUsage=1 

[MySQL] 
Description=ODBC for MySQL 
Driver=/usr/lib/libmyodbc5.so 
Setup=/usr/lib/libodbcmyS.so 
Driver64=/usr/lib64/libmyodbc5.so 
Setup64=/usr/lib64