Sql server 2000 connection error - Initial setup using odbc
Posted: Wed Aug 04, 2004 10:11 am
The following is the error message I am receiving.
DSR.MetaGeta(GET.TABLES)(SQLConnect('SQLServer','sa')): BCI Error:
SQLSTATE=08001,CODE=11,[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][libssclient19]General network error. Check your network documentation.
SQLSTATE=01000,CODE=146,[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][libssclient19]ConnectionOpen (connect()).
.odbc.ini File
[SQLServer]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmss
s19.so
Description=DataDirect SQL Server Wire Protocol
Database=Northwind
LogonID=datastage
Password=datastage
Address=192.xxx.xxx.xxx,1433 * not really XXX
QuotedId=No
AnsiNPW=No
Uvodbc.config
<SQLServer>
DBMSTYPE = ODBC
Thanks,
DSR.MetaGeta(GET.TABLES)(SQLConnect('SQLServer','sa')): BCI Error:
SQLSTATE=08001,CODE=11,[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][libssclient19]General network error. Check your network documentation.
SQLSTATE=01000,CODE=146,[DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][libssclient19]ConnectionOpen (connect()).
.odbc.ini File
[SQLServer]
Driver=/export/home/dsadm/Ascential/DataStage/DSEngine/../branded_odbc/lib/VMmss
s19.so
Description=DataDirect SQL Server Wire Protocol
Database=Northwind
LogonID=datastage
Password=datastage
Address=192.xxx.xxx.xxx,1433 * not really XXX
QuotedId=No
AnsiNPW=No
Uvodbc.config
<SQLServer>
DBMSTYPE = ODBC
Thanks,