This is a place where you can find the diy stuffs that mom will love and technical stuffs, specially computer programming. Working full time as a software developer, I try to update myself with the new technologies. And, being a mother of the beautiful daughter, I love to entertain my kid with new things and play with her.

Thursday, 10 July 2014

Using Oracle SQLDeveloper to access SQL Server

These are the steps if you want to use SQL Server from Oracle's SQLDeveloper.

  1. Download jtds (open-source SQLServer JDBC driver) from here. Unzip and extract the jtds-1.2.jar (the latest version) to your computer.
  2. Open SQLDeveloper and goto: Tools->Preferences->Database->Third Party JDBC Drivers. Click “Add Entry” and give the path where you have downloaded jtds-1.2.jar
  3.  Now goto SQLDeveloper and click the "New Connection". You will now see the extra tab for the SQL Server.
  4. Give the credentials of database to connect.


0 comments:

Post a Comment