Friday, January 22, 2016

Connect MS SQL Server from Oracle SQL Developer 3.2 using JDBC

Hello,


Here are the step to connect MS SQL Server from Oracle SQL Developer 3.2 using jtds-1.2.7.jar file (plugin)

1.       Open Oracle SQL Developer to go Tools Menu >> preferences

2.       In pop up window go to tree view explorer >> Database >> Third party JDBC Drivers

3.       Click on Add Entry >> select jtds-1.2.7-dist folder >> jtds-1.2.7.jar click ok

4.       Restart SQL Developer.

Now click on + button (new connection) and you will be able to connect SQL Server databases as well.

Use this link to download jtds driver

Below is the screenshot of preferences options.



No comments:

Post a Comment