This discussion is archived
7 Replies Latest reply: Feb 13, 2013 5:33 PM by Gary Graham RSS

SQL Server tab missing in create new connection

shaamil Newbie
Currently Being Moderated
Hi,
I am trying to test some migration from SQL Server to Oracle. I went through the sample tutorial but I cannot find the SQL Server tab during connection creation.
I can only see Oracle and Access tabs.

Can some one help me to sort out this issue.
  • 1. Re: SQL Server tab missing in create new connection
    bjeffrie Journeyer
    Currently Being Moderated
    Hi Shaamil -

    You need to add the JDBC driver for SQL Server.
    Help->Check for Updates...
    Make sure "Third Party SQL Developer Extensions" is checked on the Source page
    Select "JTDS JDBC Driver" on Updates page
    after install, the tab will be there

    Brian Jeffries
    SQL Developer Team
  • 2. Re: SQL Server tab missing in create new connection
    SueHarper Oracle ACE
    Currently Being Moderated
    <p>Yes, you need to add the drivers to support the SQL Server connections. In the Release Notes, there is a link to the <a hrref="Migrations%20Getting%20Started%20document|http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html%20">Migrations Getting Started document</a>. That shows you where to get the drivers and how to add them. The document continues by showing you how to use the migration feature (this section is related to SQL Developer 2.0 as the functionality has changed considerably for 3.0). Adding the drivers is the same for both versions.</p>

    Sue
  • 3. Re: SQL Server tab missing in create new connection
    shaamil Newbie
    Currently Being Moderated
    Hay guys,
    Thank you for the feedback.
    I am using SQL developer in a isolated environment where as all download need to make request and downloaded according to my company IP policy compliences. Is there any link where I can download and get it activated. if so can you please provide me with the link and the seting up procedurefor 3rd party activation. I am using SQL Developer on XP Professional 32 bit.

    Thank you.
    Regards Shaamil

    Edited by: Shaamil . on Nov 24, 2010 2:18 PM
  • 4. Re: SQL Server tab missing in create new connection
    Irian Pro
    Currently Being Moderated
    for SQL Server you will need the JTDS JDBC driver, you can download the driver from here:

    http://sourceforge.net/projects/jtds/files/

    the supported JTDS version for SQL Developer is not the latest one but the following:

    http://sourceforge.net/projects/jtds/files/jtds/1.2.2/jtds-1.2.2-dist.zip/download

    when you have the driver downloaded you can add it as a third party JDBC driver and then you will be able to conenct.

    if you need to enable a link in your proxy I'd suggest you use the first one so you will be able to download updated drivers if needed.
  • 5. Re: SQL Server tab missing in create new connection
    SueHarper Oracle ACE
    Currently Being Moderated
    Please review the Migrations Getting Started (http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html) document. There is a link to this document from the downloads page and in the release notes. The detail provided by other users on this forum are correct, but it is important to review the release notes for general queries when you start working with new products.

    Sue
  • 6. Re: SQL Server tab missing in create new connection
    990967 Newbie
    Currently Being Moderated
    Irian-

    Thank you for specifying that the latest version does not work. No where on the web does anyone say this. I've been going around in circles trying to figure out what was wrong. I downloaded the 1.2.2 version and all is good now!
  • 7. Re: SQL Server tab missing in create new connection
    Gary Graham Expert
    Currently Being Moderated
    Hi,

    Actually, look at the following link (and find the Microsoft SQL Server and Sybase: jTDS driver available... section):
    http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html

    You can get there by drilling down from one of this forum's top level announcement links as follows:
    1. SQL Developer 3.2.2 Patch Available Now
    2. Release Notes -> see Third Party Databases
    4. Getting Started -> Oracle SQL Developer Migrations -> Configuring JDBC drivers

    Also, a general web search on SQL Developer jTDS driver came up with a blog listing a 1.2.7 jTDS driver solution as the second hit.

    -Gary

Legend

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