Configure MS SQL SERVER,MY SQL,MS ACCESS to run from Oracle SQL Developer

We can execute MS SQL SERVER,MY SQL,MS ACCESS from Oracle SQL Developer.Steps are given below

1.download Oracle SQL Developer from below link

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

2.Oracle connection

We can connect oracle by Host Name,Port and SID or by TNS details.

oracle connection by host name

 

 

 

 

 

oracle connection by TNS

 

 

 

 

 

3.MY SQL Server connection

a.need to download the MySQL J Connector (JDBC Driver) at the MySQL download site.

b.start SQL Developer and click on the Tools>Preferences>open the Preferences dialog box.

my sql drivers

 

 

 

 

 

 

Click on the Add Entry button,select the JAR file and select it to load into Preferences.

my sql drivers selection

 

 

 

 

 

 

 

c.now we can configure my sql connection like below

my sql connection

 

 

 

 

 

4.MS SQL Server connection

a.need to download  jTDS from http://sourceforge.net/projects/jtds/. The jtds-1.2-dist.zip file for Microsoft SQL Server.

b.start SQL Developer and click on the Tools>Preferences>open the Preferences dialog box.add below entry

ms sql drivers selection

 

 

 

 

 

 

 

c.now we can configure ms sql connection like below

ms sql connection

 

 

 

 

 

d.We have to check the Configuration Manager on your SQL Server database to make sure we  have TCP/IP enabled,Named pipes and Shared Memory Enabled.

ms sql connection configuration

 

 

 

 

 

4.MS Access connection

To create a connection for Microsoft Access,we do not require any drivers.we can directly connect a .mdb file.

ms access connection

 

 

 

 

 

Hope this is helpful.

Enjoy!

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: