Oracle SQL Developer only support connection to Oracle and Access by default.
If I would like to connection to Microsoft SQL Server, how to configure it?
How-To
Step 1. Download jTDS - SQL Server and Sybase JDBC driver from http://sourceforge.net/projects/jtds/files/
Step 2. Tool => Preference => Third Party JDBC Driver. Set library file to Third Party JDBC Driver
Step 3. Click create new database connection. You can find out SQLServer option is the create new database connection dialog after forging configuration.
Step 4. Fill in the SQL Server database connection information and do test. It can connection to SQL Server database successfully via Oracle SQL Developer.
Reference
[1] https://www.dotblogs.com.tw/smartleos/archive/2013/09/16/118705.aspx
No comments:
Post a Comment