From the troubleshooting guide: 1. Search /usr for libodbc*.so* looking for duplicates of the UnixODBC Drive Manager. I don't see any duplicates. [root@nagios usr]# find /usr -name libodbc*.so* /usr/lib64/libodbcdrvcfg1S.so.2.0.0 /usr/lib64/libodbc.so /usr/lib64/libodbc.so.2 /usr/lib64/libodbc.so.2.0.0 /usr/lib64/libodbccr.so.2 /usr/lib64/libodbcdrvcfg2S.so.2 /usr/lib64/libodbcdrvcfg1S.so.2 /usr/lib64/libodbccr.so.2.0.0 /usr/lib64/libodbcmyS.so /usr/lib64/libodbcdrvcfg2S.so.2.0.0 /usr/lib64/libodbcinst.so.2.0.0 /usr/lib64/libodbcinst.so /usr/lib64/libodbcmyS.so.2 /usr/lib64/libodbcminiS.so.2 /usr/lib64/libodbcminiS.so.2.0.0 /usr/lib64/libodbcinst.so.2 /usr/lib64/libodbcmyS.so.2.0.0 /usr/lib64/libodbcnnS.so.2 /usr/lib64/libodbcnnS.so.2.0.0 /usr/lib64/libodbcpsqlS.so.2 /usr/lib64/libreoffice/program/libodbclo.so /usr/lib64/libodbctxtS.so.2 /usr/lib64/libodbctxtS.so.2.0.0 /usr/lib64/libodbcpsqlS.so /usr/lib64/libodbcpsqlS.so.2.0.0 /usr/lib64/libodbccr.so /usr/lib64/libodbcdrvcfg1S.so /usr/lib64/libodbccr.so.1 /usr/lib64/libodbcinst.so.1 /usr/lib64/libodbc.so.1 /usr/lib64/libodbcdrvcfg2S.so /usr/lib64/libodbcminiS.so /usr/lib64/libodbcnnS.so /usr/lib64/libodbctxtS.so 2. Output of yum list unixODBC looking to duplicate driver managers. No duplicates foung Installed Packages unixODBC.x86_64 2.3.1-11.el7 @base Available Packages unixODBC.i686 2.3.1-11.el7 base 3. Modify odbcinst.ini to add trace I found two odbcinst.ini files. Is that right? [root@nagios usr]# locate odbcinst.ini /etc/odbcinst.ini /etc/odbcinst.ini.rpmsave /opt/microsoft/msodbcsql/etc/odbcinst.ini /usr/share/doc/libiodbc-3.52.7/odbcinst.ini.sample /usr/share/man/man5/odbcinst.ini.5.gz I added the trace to both (see below) and connected through sqlcmd (success) and through the testsql.php (fail). The trace for sqlcmd is below. The testsql.php did not write anything to the log. cat /etc/odbcinst.ini [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 13 for SQL Server] Description=Microsoft ODBC Driver 13 for SQL Server Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.4.0 UsageCount=1 [ODBC] Trace = Yes TraceFile = /tmp/odbc.log cat /opt/microsoft/msodbcsql/etc/odbcinst.ini [ODBC Driver 13 for SQL Server] Description=Microsoft ODBC Driver 13 for SQL Server Driver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-13.1.so.4.0 [ODBC] Trace = Yes TraceFile = /tmp/odbc.log [root@nagios /]# cat odbc.log [ODBC][30399][1487873014.964432][__handles.c][460] Exit:[SQL_SUCCESS] Environment = 0x25db360 [ODBC][30399][1487873014.964496][SQLSetEnvAttr.c][189] Entry: Environment = 0x25db360 Attribute = SQL_ATTR_ODBC_VERSION Value = 0x3 StrLen = 0 [ODBC][30399][1487873014.964517][SQLSetEnvAttr.c][363] Exit:[SQL_SUCCESS] [ODBC][30399][1487873014.964532][SQLAllocHandle.c][375] Entry: Handle Type = 2 Input Handle = 0x25db360 [ODBC][30399][1487873014.964546][SQLAllocHandle.c][493] Exit:[SQL_SUCCESS] Output Handle = 0x25dbae0 [ODBC][30399][1487873014.964581][SQLSetConnectAttr.c][396] Entry: Connection = 0x25dbae0 Attribute = SQL_ATTR_LOGIN_TIMEOUT Value = 0x8 StrLen = 4 [ODBC][30399][1487873014.964598][SQLSetConnectAttr.c][681] Exit:[SQL_SUCCESS] [ODBC][30399][1487873014.964619][SQLSetConnectAttrW.c][332] Entry: Connection = 0x25dbae0 Attribute = SQL_ATTR_PACKET_SIZE Value = 0x1000 StrLen = 4 [ODBC][30399][1487873014.964633][SQLSetConnectAttrW.c][616] Exit:[SQL_SUCCESS] [ODBC][30399][1487873014.964721][SQLDriverConnectW.c][290] Entry: Connection = 0x25dbae0 Window Hdl = (nil) Str In = [DRIVER={ODBC Driver 13 for SQL Server};SERVER={10.21.50.131};UID={nagios};PWD={nagios};WSID={nagios};APP={SQLCMD};][length = 114 (SQL_NTS)] Str Out = (nil) Str Out Max = 0 Str Out Ptr = (nil) Completion = 0 UNICODE Using encoding ASCII 'UTF8' and UNICODE 'UTF16LE' [ODBC][30399][1487873014.980160][SQLDriverConnectW.c][910] Exit:[SQL_SUCCESS_WITH_INFO] Connection Out [[NULL]] DIAG [01000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Changed database context to 'master'. DIAG [01000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Changed language setting to us_english. [ODBC][30399][1487873014.980268][SQLAllocHandle.c][540] Entry: Handle Type = 3 Input Handle = 0x25dbae0 [ODBC][30399][1487873014.980297][SQLAllocHandle.c][1081] Exit:[SQL_SUCCESS] Output Handle = 0x25e0310 [ODBC][30399][1487873014.980327][SQLSetStmtAttrW.c][166] Entry: Statement = 0x25e0310 Attribute = SQL_ATTR_QUERY_TIMEOUT Value = (nil) StrLen = -5 [ODBC][30399][1487873014.980344][SQLSetStmtAttrW.c][551] Exit:[SQL_SUCCESS] [ODBC][30399][1487873014.980383][SQLExecDirectW.c][177] Entry: Statement = 0x25e0310 SQL = [SET QUOTED_IDENTIFIER OFF][length = 25 (SQL_NTS)] [ODBC][30399][1487873014.980913][SQLExecDirectW.c][436] Exit:[SQL_SUCCESS] [ODBC][30399][1487873014.980968][SQLSetStmtAttrW.c][166] Entry: Statement = 0x25e0310 Attribute = SQL_ATTR_QUERY_TIMEOUT Value = (nil) StrLen = -5 [ODBC][30399][1487873014.980986][SQLSetStmtAttrW.c][551] Exit:[SQL_SUCCESS] [ODBC][30399][1487873014.981014][SQLExecDirectW.c][177] Entry: Statement = 0x25e0310 SQL = [SET TEXTSIZE 4096][length = 17 (SQL_NTS)] [ODBC][30399][1487873014.981553][SQLExecDirectW.c][436] Exit:[SQL_SUCCESS] [ODBC][30399][1487873018.104562][SQLGetConnectAttrW.c][236] Entry: Connection = 0x25dbae0 Attribute = 1244 Value = 0x7ffc6bb1edbc Buffer Length = -6 StrLen = 0x7ffc6bb1edb8 [ODBC][30399][1487873018.104617][SQLGetConnectAttrW.c][703] Exit:[SQL_SUCCESS] [ODBC][30399][1487873018.104638][SQLFreeHandle.c][381] Entry: Handle Type = 3 Input Handle = 0x25e0310 [ODBC][30399][1487873018.104669][SQLFreeHandle.c][491] Exit:[SQL_SUCCESS] [ODBC][30399][1487873018.104686][SQLDisconnect.c][208] Entry: Connection = 0x25dbae0 [ODBC][30399][1487873018.104814][SQLDisconnect.c][364] Exit:[SQL_SUCCESS] [ODBC][30399][1487873018.104832][SQLFreeHandle.c][284] Entry: Handle Type = 2 Input Handle = 0x25dbae0 [ODBC][30399][1487873018.104846][SQLFreeHandle.c][333] Exit:[SQL_SUCCESS] [ODBC][30399][1487873018.104859][SQLFreeHandle.c][219] Entry: Handle Type = 1 Input Handle = 0x25db360