SAP Knowledge Base Article - Preview

2252011 - sqldbgr gets Error "JZ00L: Login Failed" when connecting to servers configured with the roman8 character set. - SAP ASE

Symptom

The sqldbgr utility fails to connect to servers configured with the roman8 character set. For example:

% sqldbgr -U sa -Ppassword -S myhost:1234

$SYBASE_JRE6 is set.  Use $SYBASE_JRE6 as $JAVA_HOME.

java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).
        at com.sybase.jdbc3.jdbc.ErrorMessage.raiseError(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.for(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.case(Unknown Source)
        at com.sybase.jdbc3.tds.Tds.login(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.a(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.handleHAFailover(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybConnection.<init>(Unknown Source)
        at com.sybase.jdbc3.jdbc.SybDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at java.sql.DriverManager.getConnection(Unknown Source)
        at com.sybase.sqldbgr.Debugger.<init>(Debugger.java:172)
        at com.sybase.sqldbgr.Debugger.main(Debugger.java:313)
Exception in thread "main" java.lang.NullPointerException
        at com.sybase.sqldbgr.Debugger.SendAttachDetachRpc(Debugger.java:220)
        at com.sybase.sqldbgr.Debugger.main(Debugger.java:326)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

charset, "Connection string", Java-supported, roman8, sqldbgr, login, failed , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.