INSTALLATION DOCUMENTS BY RAVI

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