This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
I try to connect to a Sybase server from my machine.
When I do a direct connection from Java, I am able to connect to the Sybase server.
Also, when i configure it as a ODBC connection, and try to do a Test Connection, the result is successful.
But, when i try to configure it as a Datasource in WAS server, i am getting the error message " java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s)."
My WAS version is 6.1.
What could be the possible reasons for this?
I checked my user id and password supplied to WAS and it is correct.
My question is, when I am able to connect through ODBC, why am I not able to connect to the Sybase sever as a Datasource from WAS?