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/libodbcmyS.so FileUsage=1 [ODBC Driver 17 for SQL Server] Description=Microsoft ODBC Driver 17 for SQL Server Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.3.so.1.1 UsageCount=1 [kdb] Description=KDB ODBC Driver Driver=/home/kdb/kdb11/client/lib/libkdodbc.so FileUsage=1 Driver Logging=7 #ForceTrace=YES Pooling=No