Hi,
I am working in an application writen in
java, it connects to a Sybase ASA Database. That database has 3 instance, one named 'clock', another named 'sysadm' and a last one named 'clinics'.
I have a class wich has a method that provides access to the database and other methods to execute some queries, it uses jConnect 6.05 driver to connect to the database. I can connect perfectly, but i can not connect to an specific instance. At the begining i only can connect to the service named 'clock', and then i shut down that service, and i could connect to the service named 'sysadm', so i shutdown that service, but i couldnt connect to 'clinics', i dont know why... Then I reboot the database server, and i could connect directly to 'clinics'. I try to force the service name to connect to with the parameter SERVICENAME=clinics at the end of the url, but i have an error:
getConnection failed: java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
This is the code of my class:
The Configuration xml file:
I tried with diferrents sintaxs but nothing works. I tried appending the service name at the end of the url:
or passing the service name by the connection properties in the xml file
But i still having the same problem.
Any Ideas??
Thanks in advance,
JM