XI - Sybase Database

[Former Member]

Hi

I am trying to connect Sybase database for updating tables, for this I deployed JConnect 6.05 driver in XI7.0 system. When I try to connect, I am receiving following error

JZ0D5: Error loading protocol com.sybase.jdbc3.tds.Tds

Did any of you come across this problem?

Thanks

Reddi

[bhavesh_kantilal]

Reddi,

The driver value entered in your JDBC adapter is the issue.

<b>com.sybase.jdbc3.tds.Tds</b>

Just test using a standalone java program with the same driver and connectivity string and see if it works.

Regards,

Bhavesh

[Former Member]

Reddi,

I used the following driver value,

Driver value - com.sybase.jdbc2.jdbc.SybDriver

Connection string - jdbc:sybase:Tds:ip:port?SERVICENAME=dbname

wher ip - ip address, port name and dbname.

[Former Member]

Hi SSG,

Which version of drivers JConnect you are using?

I am using 6.05.I had settings as follows

Driver : com.sybase.jdbc3.jdbc.SybDriver

Connection :

jdbc:sybase:Tds:<ip>:2638/<bdname>

Later as you suggested i changed as follows

Driver : com.sybase.jdbc3.jdbc.SybDriver

Connection :

jdbc:sybase:Tds:<ip>:2638?SERVICENAME=<bdname>

Still having problem as

Attempt to establish database connection failed with SQL error Cannot establish connection to URL 'jdbc:sybase:Tds:<ip>:2638?SERVICENAME=<dbname>': SQLException: JZ0D5: Error loading protocol com.sybase.jdbc3.tds.Tds.

Appreciate your reply.

Thanks

Reddi

[former_member201513]

Hello Reddi,

Could you solve your problem? in this case could you tell me how, because we have the same problem now.

Thank you in advance,

Fernando

[Former Member]

Hey,

Did u install the corresponding sybase driver in the XI server.

cheers

jithesh

[Former Member]

Hi,

Have you uploaded the required drivers?

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

Just check for details here for driver:

http://www.sybase.com/detail?id=1041697

Regards

Vijaya

[Former Member]

Hi

I already loaded Driver for this. It would have been different error without driver.

Still having same issue. Did you any of you worked with Sybase Database?

Thanks

Reddi