DSXchange

Hi Team,

We are facing the connectivity issue with the following DSN.

Please find below DSN connections, it is connecting through SQL Server front end but through data stage.

[SQL_KNET_NEW_MIG]
Driver=/dsetlsoft/datastage/Ascential/DataStage/branded_odbc/lib/VMmsss20.so
Description=DataDirect SQL Server Wire Protocol
Database=Knet_OPS_DB
LogonID=KnetBI
Password=*******
Address=KM-ENT-SCL,1433
QuotedId=No
AnsiNPW=No

Find below are error,

DSR.MetaGeta(GET.TABLES)(SQLConnect('SQL_KNET_NEW_MIG','KnetBI')): BCI Error:
SQLSTATE=08001,CODE=11,[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][libssclient20]General network error. Check your network documentation.
SQLSTATE=01000,CODE=11,[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][libssclient20]ConnectionOpen (KM-ENT-SCL,1433())._r()).


Please suggest...

Explain the complete problem, what are you trying to do and how and what is your requirement?

We have one SQL Cluster server, i need to connect that DataBase using ODBC stage.

But I am getting the below mentioned error while connecting.

Please check the DSN code which i have mentioned and correct me if I am wrong.

Logon to your unix box where datastage is installed and try below command to check whether it is possible to connect to your sql server from datastage server or not.

telnet KM-ENT-SCL 1433

telnet IP ADDRESS OF(KM-ENT-SCL) 1433

Post the output of the above command thereafter.

No we are not able to connect. Please find below for the same

$ telnet KM-ENT-SCL
telnet: Unknown host KM-ENT-SCL


This is a Cluster SQL Server, it has only server name i.e KM-ENT-SCL, IP will not be static.

Have you tried using the full qualified host name? Is your resolve.config file is updated with name server details?