|
From: Robert M. <rob...@gm...> - 2009-08-06 00:48:58
|
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<Gau...@fm...> 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 > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
