Adaptive Server Connection Fails

Problem: Adaptive Server connection details are configured correctly, but DA fails to establish a connection.

Possible cause: Adaptive Server is configured to require all clients to use password encryption. If the net password encryption reqd parameter is configured to a nonzero value, login fails.

Solution: Ensure that the Adaptive Server connection has the ENCRYPT_PASSWORD property set to true. Add this property to existing connections by issuing:

alter connection myAseConn 
and set ENCRYPT_PASSWORD = true
go

See Connection Properties in the jConnect for JDBC 7.0 Programmers Reference.