aspose file tools*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "alternatives to JDBC for Sybase.???" Watch "alternatives to JDBC for Sybase.???" New topic
Author

alternatives to JDBC for Sybase.???

Colm Keogh
Greenhorn

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.
Thanks
Colm.
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!
Jamie
Colm Keogh
Greenhorn

Joined: Jan 18, 2002
Posts: 4
Thanks,
What type of driver do I need, type 2 or a type 4.
Where can i get them??
Thanks
Colm.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: alternatives to JDBC for Sybase.???