CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloperplsqldeveloperdbase
ama989
ama989

Reputation: 463

connect Oracle developer with Access or Microsoft SQL database

I was wondering if it's possible to connect Oracle Developer to Microsoft SQL database or Microsoft Access Database. I believe there is a way to do that. If there is, I would rather to know how.

Upvotes: 0

Views: 912

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22412

Oracle SQL Developer can connect to MSFT SQL Server. You just need to get the jTDS jdbc driver and add it to SQLDev via the preferences.

For Access, you'll need an older version of SQL Developer - I recommend version 3.1. We removed support for Access because newer versions of Java don't support an ODBC bridge that we were using.

enter image description here

I talk about how to add the JDBC drivers here.

Upvotes: 2

Related Questions