How to connect Sybase databse through Squirrel

[Gaurang_Patel]

Hello,
I am a new user, and trying to connect sybase database through Squirrel via URL. I don't know what drivers should I select in Alias and what will be the connection URL format. I tried using JDBC ODBC Bridge (as it is the only one available in the list of drivers), but when I try to connect to database it says URL format is not correct. Can anyone please help me on this,

Thanks,
Gaurang

[manningr]

Gaurang,

While the jdbc-odbc bridge will provide minimal support, a better
alternative is to
use the jdbc driver provided by Sybase, or the JTDS driver
(http://jtds.sourceforge.net/)
The Sybase Adaptive Server Enterprise (ASE) driver class that I use is :

com.sybase.jdbc3.jdbc.SybDriver

and it is located in jconn3.jar (which you can find on your server in
$SYBROOT/classed/jconn3.jar.

It's jdbc url looks like:

jdbc:sybase:Tds:<hostname>:<port>/<databasename>

The jTDS driver has a URL of the following form:

jdbc:jtds:<server_type>://<server>[:<port>][/<database>]

My Sybase server version is:

Adaptive Server Enterprise/15.0.2/EBF 15654 ESD#4/P/Linux Intel/Linux
2.4.21-47.ELsmp i686/ase1502/2528/32-bit/FBO/Sat Apr  5 05:18:42 2008

Rob


On Mon, Aug 3, 2009 at 1:03 PM, Gaurang_Patel<Gaurang.j.patel@...> wrote:

>
> Hello,
> I am a new user, and trying to connect sybase database through Squirrel via
> URL. I don't know what drivers should I select in Alias and what will be the
> connection URL format. I tried using JDBC ODBC Bridge (as it is the only one
> available in the list of drivers), but when I try to connect to database it
> says URL format is not correct. Can anyone please help me on this,
>
> Thanks,
> Gaurang
> --
> View this message in context: http://www.nabble.com/How-to-connect-Sybase-databse-through-Squirrel-tp24794452p24794452.html
> Sent from the squirrel-sql-users mailing list archive at Nabble.com.
>
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> Squirrel-sql-users mailing list
> Squirrel-sql-users@...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
>

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@...
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users