Sql server 2000 connection error - Initial setup using odbc

[larryoceanview]

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,

[Mike]

I'm no network expert, but I'll hazard a guess.

What is the second node of your IP address? Addresses like 192.168.xxx.xxx are non-routable. If there is a network router between your SQL Server database server and your UNIX DataStage server, then that could be your network problem.

Mike

[ray.wurlod]

Most of the places I work that reply makes you a network expert! :D

[larryoceanview]

Your probably right the IP is 192.168.
I referred this problem to the Admin.
I'll let you when I get a resolution.


Thanks,
Larry

[fkana]

Hi Larry,

Did u manage to resolve this issue.

Thanks.

Faeez

[maheshsada]

Your probably right the IP is 192.168.
I referred this problem to the Admin.
I'll let you when I get a resolution.


Thanks,
Larry

Have you got the resolution

[chulett]

Rather than ask Larry, who hasn't posted here in over two years if you check his stats, start your own post. That way we'll know your particulars and you can spell out all the gory details of your problem, not Larry's.