Tuesday, July 23, 2019

Connecting Microsoft SQL Server using Oracle SQL developer

We can connect Microsoft SQL server using oracle SQL developer by following the steps below.

Download “jTDS-SQL Server and Sybase JDBC driver”.

Open SQL developer

Click on Tools and then click on Preferences

Under Database Click on Third Party JDBC Driver

Add the downloaded SQL server JDBC driver and click on ok

Try to create a new connection, we will see SQL Server option now.

Select SQL Server and provide the connection details and Click on Test.
We will get a Success status.

No comments:

Post a Comment

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...