How to use ORACLE sqldeveloper to connect Ms sqlserver and MySQL Databases

1. Connect to MySQL database 1. Download The JDBC driver of MySQL, http://dev.mysql.com/downloads/ free,. 2. Unzip the ZIP file (the version I downloaded is the mysql-connector-java-5.1.5) and we will use the mysql-connector-java-5.1.5-bin.jar file. /** Method A for adding the MySQL JDBC driver. Put the JAR file in your \ tomcat6.0 \ Lib (tomcat6) \ tomcat5.5 \ commom \ Lib (tomcat5.5 or 5.0) b. You can also modify the environment variable classpath. C. If you are using eclipse (myeclipse), JB, and Nb, You can import the package. Note: This file can be placed in three different locations and has different scopes: For a Linux system: /usr/Java/JDK/JRE/lib/EXT ------ all Java applications/usr/local/resin/lib --------- all JSP/servlet Application website root directory/WEB-INF/lib single site if put it in the resin directory, restart resin:/etc/init. d/resin restart: if it is a win2000 system, put it in a similar directory, for example, D: \ JDK \ JRE \ Lib \ ext D: \ resin \ Lib website root directory \ htdocs \ WEB-INF \ Lib */3. run SQL developer, select "tools-> Preferences", select "database-> third party JDBC drivers" in the displayed window, and click "Add entry... ", select MySql-Conne Ctor-java-5.1.5-bin.jar (select from the folder you decompress) and click OK. 4. create a new connection. Everything is OK. 2. Connect to the ms SQL Server database. 1. first, go to the http://sourceforge.net to download net. sourceForge. JDBC. driver, I use the version is jtds-1.2.2.jar2. copy the jtds-1.2.2.jar in the package to the <SQL developer>/sqldeveloper/lib folder or any folder, you can only decompress it locally or :) 3. run SQL developer, select "tools-> Preferences", select "database-> third party JDBC drivers" in the displayed window, and click "Add entry..., select the jtds-1.2.2.jar (from the folder you decompressed), and click OK. 4. Create a new connection. Everything is OK. /** If you cannot connect to SQL Server, perform the following steps: 1. set jtdsxa. DLL copy to the <SQL Server 2000> \ bin directory 2. run instjtds with sa Login SQL query analyzer. SQL (one failed execution can be performed multiple times,) 3. after everything is done, open sqlcmd.exe and create a new connection 4. in Oracle SQL developer, click File> New> select database connection, and click the "sqlserver" tab in the pop-up UI, enter the related loginner, PWD, and connection name, click the retrieve database button, and then select the database to be connected in the following dialog box. note: The password cannot be null. loginner whose password is null must change the password before connecting */

This article is from the "little turtle" blog, please be sure to keep this source http://tinytortoise.blog.51cto.com/72584/108051