Can't connect to Sybase 12.5.3 remote server

[Database Administrator]

I am having a major problem connecting to a 12.5.3 ASE database running on a
remote server that runs on Windows XP Service Pack 2. I am using the 'SYC
Sybase ASE' driver. I can connect locally no problem. But when I try to
connect remotely I get this message:

ct_connect();network packet layer:internal net library error: Net-Lib
protocol driver call to connect two endpoints failed.

I have checked and re-checked my SQL.INI file. The IP adress is OK and the
ports are OK. It looks like this:

[cadmqct3]
master=NLWNSCK,172.214.11,5002
query=NLWNSCK,172.214.11,5002

The DB service is running on the remote server.

I can ping the server remotely. I can map to network shares. Just can't get
to the database

All this grief started when we upgraded from 11.9.2. This would appear to
be a network issue but I can't be sure. I simply have no idea anymore.

[Database Administrator]

On Tue, 20 May 2008 10:37:58 -0700, Doogie wrote:

> I am having a major problem connecting to a 12.5.3 ASE database running on a
> remote server that runs on Windows XP Service Pack 2. I am using the 'SYC
> Sybase ASE' driver. I can connect locally no problem. But when I try to
> connect remotely I get this message:
>
> ct_connect();network packet layer:internal net library error: Net-Lib
> protocol driver call to connect two endpoints failed.
>
> I have checked and re-checked my SQL.INI file. The IP adress is OK and the
> ports are OK. It looks like this:
>
> [cadmqct3]
> master=NLWNSCK,172.214.11,5002
> query=NLWNSCK,172.214.11,5002
>
> The DB service is running on the remote server.
>
> I can ping the server remotely. I can map to network shares. Just can't get
> to the database
>
> All this grief started when we upgraded from 11.9.2. This would appear to
> be a network issue but I can't be sure. I simply have no idea anymore.

Are you sure that the server is listening on the correct IP address?
I have seen this behavior when the server was listening on the localhost
loopback instead of the public IP address of the host...

Michael
--
Michael Peppler - Peppler Consulting SaRL
mpeppler@peppler.org - http://www.peppler.org
Sybase DBA/Developer - TeamSybase: http://www.teamsybase.com
Sybase on Linux FAQ - http://www.peppler.org/FAQ/linux.html

[Database Administrator]

>[cadmqct3]
>master=NLWNSCK,172.214.11,5002
>query=NLWNSCK,172.214.11,5002

Is that really a valid IP address (looks like an octet in the address is
missing) or did you edit the text before you pasted it here?

/mh

[Database Administrator]

Doogie wrote:
>
> I have checked and re-checked my SQL.INI file. The IP adress is OK and the
> ports are OK. It looks like this:
>
> [cadmqct3]
> master=NLWNSCK,172.214.11,5002
> query=NLWNSCK,172.214.11,5002

The IP address you list here isn't valid. Check
the original sql.ini file to confirm that.

> All this grief started when we upgraded from 11.9.2. This would appear to
> be a network issue but I can't be sure. I simply have no idea anymore.

Check on the remote server what IP address the
server is actually using too (assuming the
above was just a transcription typo). If its
using the loopback port (127.0.0.1) fix that.

-am © MMVIII

[Database Administrator]

So to check what address the server is using I just issue an
'ipconfig' command, right? And check the 'IP Address'? If
so, that is the address that I can ping remotely and that is
the address I have in my SQL.INI file.

I can connect to a MS SQL Server database on the remote
server, just not the ASE server. So maybe it isn't a network
issue.

> Doogie wrote:
> >
> > I have checked and re-checked my SQL.INI file. The IP
> > adress is OK and the ports are OK. It looks like this:
> >
> > [cadmqct3]
> > master=NLWNSCK,172.214.11,5002
> > query=NLWNSCK,172.214.11,5002
>
> The IP address you list here isn't valid. Check
> the original sql.ini file to confirm that.
>
> > All this grief started when we upgraded from 11.9.2.
> > This would appear to be a network issue but I can't be
> sure. I simply have no idea anymore.
>
> Check on the remote server what IP address the
> server is actually using too (assuming the
> above was just a transcription typo). If its
> using the loopback port (127.0.0.1) fix that.
>
> -am © MMVIII

[Database Administrator]

Doogie wrote:
>
> So to check what address the server is using I just issue an
> 'ipconfig' command, right?

No. ipconfig (ifconfig on Unix) only tells you
what interfaces the operating system has configured.
You would need the Windows equivalent of netstat
to see which IP addresses and ports applications
are using. Of course, a quicker way is to just
look at the ASE server's errorlog. Its in the
first few startup lines.

> And check the 'IP Address'? If
> so, that is the address that I can ping remotely and that is
> the address I have in my SQL.INI file.

Your other post mentions you have two interfaces.
Kevin's given you the details for using both.

-am © MMVIII

[elina_be]

in my case it was the Firewall that blocked the remotely connection to Sybase .