Database connectivity to MS SQL Server
Posted: Fri Nov 07, 2008 1:33 pm
Hi,
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.
Added an entry in uvodbc.config.
But, when I DS_CONNECT DBNAME from Command it gives the following error.
Iam wondering, why is it still giving DataDirect error. As we have installed separate Driver to windows connectivity.
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.