If you must connect to Adaptive Server Anywhere version 5.x.x through jConnect, run the Adaptive Server Anywhere Open Server Gateway dbos50, which is distributed with Adaptive Server Anywhere.
Running Adaptive Server Anywhere Open Server Gateway
dbos50
Install Open Server Gateway 5.5.x3 or later, and the Open Server DLLs, version 11.1.
Add an entry for the gateway to your %SYBASE%\ini\sql.ini file (using, for example, sqledit).
Start the gateway by entering:
start dbos50 gateway-demo
where gateway-demo is the gateway name defined in step 2.
When the Open Server Gateway is running, you can define a connection as follows:
jdbc:sybase:Tds:host:port
were host is the host name where the Adaptive Server Anywhere and Open Server Gateway are running, and port is the port number defined in sql.ini.
To support multiple Adaptive Server Anywhere databases,
use sqledit to add an entry with a different
port for each database, then run the Open Server Gateway for each
database.
