Home / Databases / Adding MSQL Connector to Oracle SQL Developer 4.0
msql_connector_feature

Adding MSQL Connector to Oracle SQL Developer 4.0

I started on some Database development and decided to give the new Version of Oracle SQL Developer 4.0 a try. The first challenge I came across and had to spend more than 5 minutes to complete was adding a working MSQL connector. I did a bit of google action and came across some dead links and silly Oracle Cloud registrations. The only request I had was the supporting mysql .jar connector. So if by chance you have the same need, read on how to get it done…

This is for Oracle SQL Developer 4.0

1. Download the MSQL connector package via the sourceforge Project: JTDS – SQL Server and Sybase JDBC driver by ickzon

2. extract the package somewhere on you harddrive

3. I choose to create a new folder called “connectors” in /Applications/SQLDeveloper.app/Content/ and copied the extracted content here.

sql_connector_location

 

 

 

 

 

 

4. Open Oracle SQL Developer 4.0 – from the Menu navigate to Oracle SQL Developer –> Preferences

5. Open the section Database and choose Third Party JDBC Driver

third_party_menu

 

 

 

 

 

 

 

  • Press Add Entry
  • Navigate to the JDBC connector you extracted and highlight “jtds-1.3.1.jar” then Press Select
  • Press OK and you done

select_jtds-1.3.1.jar

 

 

 

 

 

 

 

Now when you create a new Database connection you see the SQLServer and Sybase Tab.

sql_server_connector

 

 

 

 

 

 

 

 

 

 

Check Also

africa_map

Mobile Payment Systems in Africa

A frica boasts of some of the fastest developing economies of the world, and just …