Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Setup sybase DB connection in SQL developer?

Can we connect to the sybase db server using SQL developer. If yes what are the configuration settings we need to make?

Can we use the same tnsname.ora file in the Oracle directory or do we need to install a sybase client seperately for getting connection informa

like image 568
Balualways Avatar asked Dec 07 '22 18:12

Balualways


1 Answers

In Oracle SQL Developer 3:

You need to download the "JTDS JDBC Driver" extension via Oracle SQL Developer's GUI under Tools / Preferences. The description of this extension only mentions Microsoft SQL Server, but it can also be used for Sybase.

Once it's installed, you should see 2 new tabs in the Create Connection dialog: (MS) "SQLServer" and "Sybase".

I did not have to set up a 3rd party JDBC driver (a reference to a Sybase JDBC connector JAR).

like image 130
bcody Avatar answered Dec 09 '22 08:12

bcody