Procedure for Oracle SQL developer to connect to ms SQL Server 2000

How to connect Oracle SQL developer to ms SQL Server 2000:

1. Download the net. SourceForge. JDBC. Driver driver Driver (http://sourceforge.net has download, I downloaded the jtds-1.2.1)

2, extract and copy the jtds-1.2.1.jar to the <l SQL developer/sqldeveloper>/lib directory

3. Copy jtdsxa. DLL to the <SQL Server 2000>/bin directory.

4. Use sa Login SQL query analyzer to execute instjtds. SQL

5. After everything is done, open sqlcmd.exe and create a new connection.

6. 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.

7. Note: The password cannot be null. loginner whose password is null must change the password before connecting.