Version: 15.0.11-4
Build #: 41232
Build Date: 2014-Nov-26 02:25:51 PM
Sybase IQ: connection url for iAnywhere Driver for Multiple Databases under Server Properties, Drivers Tab
1. Configure Sybase IQ with the use iAnywhere Driver option in the Advanced Tab. See below link to configure:
https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/Documentation15/page/206/Sybase-IQ-JDBC-Drivers#osx
2. Create multiple databases in the Sybase Server so that you have 2 databases on the same host and port
3. Try to connect with the iAnywhere driver
4. You can see that it ignores specified database that the connection is requesting and always chooses the same one and does not allow connections to different catalog by name
See if we need to adjust the connection URL with DBN instead of ServiceName, when the advanced option to the following. i.e.
jdbc:sqlanywhere:host=host.domain.com:4101;DBN=SomeCatalog
instead of
jdbc:sqlanywhere:Host=host.domain.com:4101?ServiceName=SomeCatalog
It is not possible to run multiple database services that listen on the same port. The listener will lock the port for the first database service. This issue is invalid as written.