报错信息
ODBC_Connector_0: ODBC Info: SQLSTATE = 42000: Native Error Code = 7,405: Msg = [IBM(DataDirect OEM)][ODBC SQL Server Legacy Driver][SQL Server]异类查询要求为连接设置 ANSI_NULLS 和 ANSI_WARNINGS 选项。这将确保查询语义一致。请启用这些选项,然后重新发出查询。
修改方式:
修改 .odbc.ini 文件中 AnsiNPW的值为YES
[TEST]
Driver=/ds/IBM/InformationServer/Server/branded_odbc/lib/VMmsss00.so
Description=DataDirect SQL Server Wire Protocol driver
Database=***
LogonID=***
Password=***
Address=***
QuotedId=No
AnsiNPW=YES