5 Replies Latest reply: Oct 9, 2011 11:39 PM by Kgronau-Oracle RSS

    Connect from Oracle Sql Developer to MSSQL Server

    OraFighter
      I am trying to connect Oracle Sql Developer 3.0 to MSSQL Server 2000.

      I have mentioned all Connection Name : my_connection
      username : sa
           password : sa
      and in Hostname : \\FINU
      Current Service on \\Finu
                port : 1433
      I have done JDBC Drivers      : jtds-1.2.5.jar
      windows : XP

      while testing the connection it is displaying the error :
      Status: Failure - Test failed: Network error IOException:Could not create socket

      Actually we need to migrate data from SqlServer to Oracle . Is it any other way to migrate from sqlserver to Oracle
      please help me as early as possible . last two days we are running back this .
        • 1. Re: Connect from Oracle Sql Developer to MSSQL Server
          Kgronau-Oracle
          I'm using the same driver version - so in general it should work....


          What message appears when you use a hostname that does not exist in your network and then click on Test Connection?
          Does the SQL Server really listen on port 1433?
          Might there be a Firewall blocking the requests?
          • 2. Re: Connect from Oracle Sql Developer to MSSQL Server
            OraFighter
            I checked the hostname that does'not exist ,displayed below message:
                 Status: Failure - Test failed: Unknown server host name 'localhost2'.
            How to check Server really listen on port 1433?
            How to check Firewall blocking the requests?
            • 3. Re: Connect from Oracle Sql Developer to MSSQL Server
              Kgronau-Oracle
              Best would be to first open on the SQL Server the SQL Server net config tool, select TCP/IP protocol and check its config.

              Another option would be to use the SQL Server ODBC driver that is commonly installed on every Windows PC ...
              define an ODBC DSN with the server's details and check out the ODBC test
              • 4. Re: Connect from Oracle Sql Developer to MSSQL Server
                OraFighter
                Best would be to first open on the SQL Server the SQL Server net config tool, select TCP/IP protocol and check its config.

                Another option would be to use the SQL Server ODBC driver that is commonly installed on every Windows PC ...
                define an ODBC DSN with the server's details and check out the ODBC test.

                Thank you for your continues support . first of all I am totally newbei in sql server.
                can you tell where to find : Sql Server net Config tool ?

                In Sql server client Network utility I enabled TCP/IP already.
                • 5. Re: Connect from Oracle Sql Developer to MSSQL Server
                  Kgronau-Oracle
                  When you're a newbie, let's test the ODBC connection first. On the machine where you've installed SQL Developer, open the ODBC Administrator and check if you have a SQL Server ODBC driver installed. If yes, configure a new DSN and at the end test the connection. Is the connection successful?

                  Now open again SQL Developer and compare the settings you have configured in the ODBC Admin with your settings in SQL Developer. Does the SQL Server hostname, port# and database name match? Then test the connection in SQL Developer as well.