Tags: advantage, ase, box, cant, client, connect, database, failwhen, fedora, installed, linux, mysql, oracle, server, sql, sybase, usesql

Cant connect a PC client to ASE 12.5 on Linux

On Database » sybase

1,928 words with 5 Comments; publish: Sat, 10 Nov 2007 18:05:00 GMT; (25093.75, « »)

Hi,

I have installed ASE 12.5 on a Linux box (fedora 4) and try to use

SQL advantage (from a PC) to connect to this ASE server but I fail

when I try the "Ping server" option in "dsedit utility".

Do I have to install any extra packages on my linux box to get this

to work? Or are there any special settings I have missed?

If I use my "PC client" to connect to ASE servers running on Solaris

there is no problem.

All Comments

Leave a comment...

  • 5 Comments
    • If this is a freebie or developers edition, it only allows local connections originating from the same host. The express edition, I think does like 25 total connections
      #1; Thu, 13 Dec 2007 12:54:00 GMT
    • If this is a freebie or developers edition, it only allows local connections originating from the same host. The express edition, I think does like 25 total connections

      Actually that's not true at all. The freedie (developper or express) versions can be accessed from remote hosts just as any other Sybase servers.

      The issue that the OP has is that the database server is listening on the loopback address (127.0.0.1). This happens when the hostname is listed in /etc/hosts along with the loopback (the default configuration on Red Hat systems) and /etc/hosts is read first when doing a hostname lookup.

      Michael

      #2; Thu, 13 Dec 2007 12:55:00 GMT
    • Please read the following:

      http://www.peppler.org/FAQ/linux.html#q1.15

      Michael

      #3; Thu, 13 Dec 2007 12:56:00 GMT
    • Thanks a lot Michael it helped.

      But what if the linux machine is getting its ip from a DHCP server,

      is it possible to fix this in such a case too?

      #4; Thu, 13 Dec 2007 12:57:00 GMT
    • The it gets tricky, unless the hostname actually maps to the dynamic IP address.

      I guess you could do some scripting at startup to pull the ip address via /sbin/ifconfig and update the Sybase interfaces file, and then start the db server. But you would still have the problem of the client machine that needs to know where to connect to (i.e. what IP address the server has today...)

      Michael

      #5; Thu, 13 Dec 2007 12:58:00 GMT