May I know the configuration that we need to do for connecting a MS SQl server from a Unix Datastage Server.
We have the odbc.ini updated as follows.
Code: Select all
WHRPOSDEV=MS SQL
[DBNAME]
Driver=/opt/nz/lib/lib/libtdsodbc.so
Description=MS SQL ODBC
Servername=SERVERNAME
Port=1433
Database=DBNAME
ReadOnly=false
ShowSystemTables=false
Socket=16384
DateFormat=1
TranslationDLL=
TranslationName=
TranslationOption=
But, when I DS_CONNECT DBNAME from Command it gives the following error.
Code: Select all
SQLConnect error: sTATUS = -1 SQLState = IM003 Natcode = 0 [ODBC] [DataDirect] [ODBC lib] Specified driver could not be loaded Invalid parameter (s) found in configuration file.