We just installed the Datastage 8.7 in our Linux box. Right now we are trying to connect to SQL Server 2008 R2 through ODBC stage.
I have added SQL Server database and server name in odbc.ini and uvodbc.config.
When I am testing the connection from linux through DS_CONNECT, it unable to connect.
Code: Select all
./bin/dssh
LOGTO <Project>
DS_CONNECT SQLServerTest
SQLConnect error: Status = -1 SQLState = IM002 Natcode = 0
[ODBC] [DataDirect][ODBC lib] Data source name not found and no default driver specified
Code: Select all
$ ./ddtestlib /opt/IBM/InformationServer/Server/branded_odbc/lib/VMsqls25.so
Load of /opt/IBM/InformationServer/Server/branded_odbc/lib/VMsqls25.so successful, qehandle is 0x2DB9090
File version: 06.12.0118 (B0117, U0061)
Appreciate all your help!!
Thanks in Advance!!