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...
DSN Connection probelm
Moderators: chulett, rschirm, roy
DSN Connection probelm
Thanks and Regards
Prasad.G
Prasad.G