Try connect to Sybase - JZ006 Caught IOException connection refused

[Former Member]

Hello,

I have a system with SAP application and database used as sybase.

The tool is installed dbisql, when I try to connect with this tool gives me the following error: java.net.ConnectException JZ006 Caught IOException connection refused. (Attachment image.)

Investigating the error I suggest that you check if the port is available, I checked and enabled.

I'm trying to go with the default port is 5000.

Where I can see if dbisql use another port for connection?

Or how else can I access the database to run a sql script?

Best Regards!

[former_member188883 · Accepted solution]

Hi Hidalgo,

Please following credentials for dbisql

user: sapsa

passwd: <password for sapsa>

servername: <hostname of Sybase ASE>

port: 4901

Additional information can be found in thread

Hope this helps.

Regards,

Deepak Kori

[former_member182259]

One of two things.....

1) SAP installs with mandatory network password encryption....in the top part of the login dialog right next to the password field is a check box "Encrypt Password" - make sure it is checked.

2) the default port for general ASE installs is port 5000 - however, the default port for SAP installs is typically 4901 or something similar (in case multiple instances on same host).   check server's interfaces file for actual port number.