File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes alternatives to JDBC for Sybase.??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "alternatives to JDBC for Sybase.???" Watch "alternatives to JDBC for Sybase.???" New topic

alternatives to JDBC for Sybase.???

Colm Keogh

Joined: Jan 18, 2002
Posts: 4
Hello All,
I'm trying to write an application running on windows NT workstation to connect to Sybase SQL server running on Solaris. I'm not permitted to make any changes to the SQL server.....can JDBC be implemented from the client side only???
I don't think there are any JDBC drivers loaded on the SQL server. Do all type 4 drivers (jconnect for Sybase) need some server side component installed or is there a way around that???
Are there any alternatives to JDBC (i don't want to use ODBC)???
Any idea's on a best approach???
Any help much appreciated.
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

jdbc can be used when only installed on the client( for a client/server application --> 2-tier architecture). Download the jdbc drivers for your DB, then put the .jar/.zip file in your classpath. As long as you have permissions, you can do it!
Colm Keogh

Joined: Jan 18, 2002
Posts: 4
What type of driver do I need, type 2 or a type 4.
Where can i get them??
I agree. Here's the link:
subject: alternatives to JDBC for Sybase.???
It's not a secret anymore!