This discussion is archived
5 Replies Latest reply: Oct 9, 2011 9:39 PM by kgronau RSS

Connect from Oracle Sql Developer to MSSQL Server

OraFighter Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points