JDBC driver configuration for sybase in XI 3.0

[Former Member]

my client vendor upgraded sybase database version 8 to 11, then after we are facing connectivity problem.

i deployed new JDBC for sybase ver 6.05.. jconn3.jar i am not sure this is the right version to deploy for sybase 11...

still have the connectivity problem...

do i need to configure this driver to work.

if yes please assist me or provide any documentation

Thanks in Advance

--

Edited by: moiz2306 on Jul 18, 2011 8:15 AM

[Former Member]

the error i am getting is

Receiver Adapter v2604 for Party '', Service 'BS_DTS':

Configured at 2011-07-18 15:53:36 CDT

History:- 2011-07-18 15:53:37 CDT: Error: Accessing database connection 'jdbc:sybase:Tds:34.64.3.74:2638?SERVICENAME=DTS285_12&IGNORE_DONE_IN_PROC=true' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:sybase:Tds:34.64.3.74:2638?SERVICENAME=DTS285_12&IGNORE_DONE_IN_PROC=true': SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).

[baskar_gopalakrishnan2]

> Cannot establish connection to URL 'jdbc:sybase:Tds:34.64.3.74:2638?SERVICENAME=DTS285_12&IGNORE_DONE_IN_PROC=true': SQLException: JZ00L: Login failed

Just few cents...

a) Make sure login information user/password for the database is valid

b) Looks like your connection string seems to be invalid. Refer the document.

[rajasekhar_reddy14]

Hi,

Remove your old jaer file and deploy correct jar file once again.

refer below link,it might be usefull

http://iablog.sybase.com/hinsperg/2009/10/connecting-to-sql-anywhere-using-jdbc/

Regards.

Raj

[former_member854360]

No configuration required.

Only you need to deploy the latest Jar.

also can you provide the exact error msg what you are getting