+ Reply to Thread
Results 1 to 7 of 7

Can't connect to Sybase 12.5.3 remote server

  1. Can't connect to Sybase 12.5.3 remote server

    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.




  2. Re: Can't connect to Sybase 12.5.3 remote server

    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


  3. Re: Can't connect to Sybase 12.5.3 remote server

    >[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



  4. Re: Can't connect to Sybase 12.5.3 remote server

    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

  5. Re: Can't connect to Sybase 12.5.3 remote server

    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


  6. Re: Can't connect to Sybase 12.5.3 remote server

    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

  7. Re: Can't connect to Sybase 12.5.3 remote server

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

+ Reply to Thread