CODEWITHSUNDEEP
configurationsybaseoracle-sqldeveloper
Balualways
Balualways

Reputation: 4510

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

Upvotes: 4

Views: 46863

Answers (4)

mani_nz
mani_nz

Reputation: 5592

Link to download the JTDS driver. Just add it to your Oracle SQL developer and you are done!!

Upvotes: 2

bcody
bcody

Reputation: 2548

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).

Upvotes: 9

Miguel G
Miguel G

Reputation: 41

You have to configure a new JDBC Driver into SQL Developer.

You can follow these instructions: http://www.oracle.com/technetwork/database/migration/jdbc-migration-1923524.html

Basically you have to download the supported version of the open source jTDS driver (1.2) and then add the jar file in "Third Party JDBC Drivers" on "Preferences".

Upvotes: 4

Balualways
Balualways

Reputation: 4510

I got the solution. We can download the Sybase plugin which allow us to use SQL Developer for Sybase. Or we can use JDBC ODBC bridge tweaks for SQL developer. Can be downloaded for free.

Upvotes: 2

Related Questions