ODBC Connection to MSSQL
Posted: Tue Sep 13, 2011 7:37 am
Hello,
i try to setup a ODBC Connection to a MSSQL-Database
Well, i have searched in this Forum several hours ... tested all hints given ... now i have no further idea ?????
Everythink looks fine !
odbc.ini (part)
---------
[UIP_ALM]
Driver=/datastage/Ascential/DataStage/branded_odbc/lib/VMmsss20.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Database=UIP_ALM
LogonID=bo_dbaccess
Password=aaaaaaaaaa
Address=123.456.789.0\UIP_ALM,1433
QuotedId=No
AnsiNPW=No
==> here i also tested with the server name
==> i also tested without instance
uvodbc.config (part)
----------------
<UIP_ALM>
DBMSTYPE = ODBC
Transformer with an OCBD-Connector gets:
main_program: Fatal Error: Could not connect to datasource[DataDirect][ODBC SQL Server Driver][libssclient20]General network error. Check your network documentation.
Trying to access with a Routine gets:
Status for SQLConnect call is -1, SQLSTATE is 08001, NATCOD is 11, message is [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][libssclient20]General network error. Check your network documentation.
I can ping the MSSQL-server from the datastage server
I can connect via telnet to MSSQL-server from the datastage server
I can easy setup an ACCESS-ODBC-Connection with the same parameter (so the database is up and running)
I talked with the network-guys ... there is no firewall issue
Does anybody have any further hint, what could i test?
Thanks a lot !!!
Manfred Hagedorn
i try to setup a ODBC Connection to a MSSQL-Database
Well, i have searched in this Forum several hours ... tested all hints given ... now i have no further idea ?????
Everythink looks fine !
odbc.ini (part)
---------
[UIP_ALM]
Driver=/datastage/Ascential/DataStage/branded_odbc/lib/VMmsss20.so
Description=DataDirect 5.0 SQL Server Wire Protocol
Database=UIP_ALM
LogonID=bo_dbaccess
Password=aaaaaaaaaa
Address=123.456.789.0\UIP_ALM,1433
QuotedId=No
AnsiNPW=No
==> here i also tested with the server name
==> i also tested without instance
uvodbc.config (part)
----------------
<UIP_ALM>
DBMSTYPE = ODBC
Transformer with an OCBD-Connector gets:
main_program: Fatal Error: Could not connect to datasource[DataDirect][ODBC SQL Server Driver][libssclient20]General network error. Check your network documentation.
Trying to access with a Routine gets:
Status for SQLConnect call is -1, SQLSTATE is 08001, NATCOD is 11, message is [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][libssclient20]General network error. Check your network documentation.
I can ping the MSSQL-server from the datastage server
I can connect via telnet to MSSQL-server from the datastage server
I can easy setup an ACCESS-ODBC-Connection with the same parameter (so the database is up and running)
I talked with the network-guys ... there is no firewall issue
Does anybody have any further hint, what could i test?
Thanks a lot !!!
Manfred Hagedorn