Hi,
Task: Connect SquirrelSQL 5.0 or DBeaver via the aseuserstore to ASE 16.1 SP00 PL01.
1) SAIP entry created in aseuserstore:
C:\SAP\OCS-16_1\bin>aseuserstore.exe list
KEY: AMC_H2_FILE_PASSWORD
CON_ENV : local
USERNAME : H2SA
PASSWORD : ***
DATABASE : amc
KEY: AMC_H2_USER_PASSWORD
CON_ENV : local
USERNAME : H2SA
PASSWORD : ***
DATABASE : amc
KEY: SAIP
CON_ENV : jdbc:sybase:Tds:HP450RK:5000
USERNAME : sa
PASSWORD : ***
2) In SquirrelSQL create an Alias without username and password:
Name: AUSJDBC
Driver: Sybase Adaptive Server Enterprise
URL: jdbc:sybase:Tds:?SECURE_STORE_KEY=SAIP
3) Connecting to ASE fails:
Unexpected Error occurred attempting to open an SQL connection.
class java.net.UnknownHostException: jdbc:sybase:Tds:HP450RK
Changing the hostname to an IP address results in the same error; the IP address then appears at the end of the error message.
Adding the driver property SECURE_STORE_KEY to SquirrelSQL with the value SAIP results in the same error.
Connecting to the same driver without using the aseuserstore works without any issues. URL=jdbc:sybase:Tds:HP450RK:5000 and providing username and password .
Many thanks
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.