Is DB Connect to ASE 16 not possible?

[klowk]

Hi all,

I get following error Message:

JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

I tried it with DBConnect version 3.3.1 and 3.1.4.

I want connect to following version:

Adaptive Server Enterprise/16.0 SP03 PL05 HF1/EBF 28622 SMP/P/x86_64/SLES 11.1/ase160sp03pl05x/3463/64-bit/FBO/Thu Sep 13 09:24:26 2018

I tried it with different JDBC drivers it is still not working.

Can i find any additional error messages from Splunk or are there any other debug possibilities?

kind regards

Kathrin

[richgalloway]

Have you looked in splunkd.log and splunk_app_db_connect*.log?

[klowk]

Hi richgalloway

I had already looked into these files there is only this short error message again no other information.

kind regards

Kathrin

[chli_splunk]

Usually it's caused by incorrect credentials or JVM options. Please try to login with other DB clients. If it's still not working, please contact Splunk support and provide diag. Thanks.

[klowk · Accepted solution]

It was not Credentials itself. It was a problem with encryption. With following JDBC it is working:

jdbc:sybase:Tds:<host>:<port>/<db-name>?ENCRYPT_PASSWORD=true

[youngsuh]

Could you provide little more details like which configuration file you change that on?

[klowk]

It was only an adjustment in the JDBC String directly in Connection setup in DB Connect

[youngsuh]

Thanks for you're time!