I can connect to SQLAnywhere database "mydb" using dbisql as along as
I don't use localhost or any other name that is assigned to my local
machine. As soon as I add -host parameter, it stops connecting as
shown below.
However to connect through JDBC I need hostname hence I am stuck
without it.

Please assist.


MacBookPro:~ usr$ dbisql -nogui -c
"Server=sungard;DBN=mydb;UID=admin;PWD=admin"
(admin)> quit /*** successful **/

MacBookPro:~ usr$ dbisql -nogui -c
"Server=sungard;DBN=mydb;UID=admin;PWD=admin" -port 2638
(admin)> quit /*** successful **/

MacBookPro:~ usr$ dbisql -nogui -c
"Server=sungard;DBN=mydb;UID=admin;PWD=admin" -port 2638 -host
localhost
Could not connect to the database.
Database server not found
SQLCODE=-100, ODBC 3 State="08001"
(Not Connected)> /*** failed **/