× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2014-12-16T22:00:52Z  · last modified 2015-01-28T18:00:59Z

Sybase IQ: connection url for iAnywhere Driver for Multiple Databases


customer request
Priority Major
Complexity Unknown
Component App - Server Registration
Version 15.0
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
2 attachments

Issue #12984

Closed
Invalid
Resolved 2014-12-23T17:24:31Z
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017