MSSQL配置
模板如下:
[SQL Server Legacy Wire Protocol]
Driver=/u01/app/Informatica/10.1.0/ODBC7.1/lib/DWmsss27.so
Description=DataDirect 7.1 SQL Server Legacy Wire Protocol
Address=<SQLServer_host, SQLServer_server_port>
AlternateServers=
AnsiNPW=Yes
ConnectionRetryCount=0
ConnectionRetryDelay=3
Database=<database_name>
FetchTSWTZasTimestamp=0
FetchTWFSasTime=0
LoadBalancing=0
LogonID=
Password=
QuotedId=No
ReportCodepageConversionErrors=0
SnapshotSerializable=0
但是注意,Address中不需要添加端口,否则会出现“[ODBC SQL Server Driver][libssclient24]206112061120611 ”错误