ConnectionException: Connection Refused using dbisql but not isql using Sybase ASE 15.7 Developer

[Tom Jenkinson]

Hi,

I installed the free dev version of Sybase ASE on my own PC and eventually I worked out how to start it/stop it create a database and so on. I can even connect using the command line to it.

1. Install ASE, accept all the defaults, except create my own db afterwards

2. ./srvbuild <create a database called localhost>

I can tell the server is running on the port 4114 too:
[sybase@localhost install]$ grep 4114 /etc/services
jomamqmonitor 4114/tcp # JomaMQMonitor
jomamqmonitor 4114/udp # JomaMQMonitor
[sybase@localhost install]$ netstat -a | grep jomam
tcp 0 0 localhost:jomamqmonitor *:* LISTEN
tcp 1 0 localhost:33822 localhost:jomamqmonitor CLOSE_WAIT

I can connect to this db just fine using isql:
./isql -Usa -P<PASSWORD> -Slocalhost


I cannot connect to this db using dbisql, the graphical tool to explore the database which I assume uses the same login method.

It appears isql must connect using a different mechanism to dbisql or JDBC and perhaps I need to configure some additional security somewhere but I cannot work this out, has anyone ever played with Sybase and knows that there is a gotcha somewhere regarding security config. There certainly is in postgres where you can configure the database to accept command line or tcp connections independently, I can't see the same in sybase config as yet.

Does anyone know whether I need to start something else to connect to this server using dbisql? My end game is to connect using a JDBC datasource, it looks like dbisql is using something rather similar.

Tom

[apids...@gmail.com]

Did you ever figure this out? Running into EXACT same issue.