locked
SSMA 2008 for Oracle: Connect Identifier RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    I am trying to migrate my oracle 11g sored procedures into SQL server 2008.

    In SSMA 2008 for Oracle, I am able to connect to SQL Server 2008, however I am having problems in connecting to Oracle 11g.

    I am connecting to Oracle using TNSNAME mode. Details are as follows:

    Provider : Oracle Client Provider

    Mode: TNSNAME mode

    Connect Identifier : ????? (problem lies here)

    Username : xxxx

    password : xxxx

    In oracle, using SQL developer, if I keep Connect identifier blank, I am able to connect. Bt this doesn't work in SSMA 2008.

    Any suggestions.

     Thanks,

    Nitin Pawar

    Tuesday, July 6, 2010 5:50 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Nitin,

    Connect Identifier would be something like this

    Connect Identifier :

    (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname)(PORT=portnumber)))(CONNECT_DATA=(SID=sid)))

    You can find the above information from TNSNAME.ora in ORACLE folder path.

     

    If you still face the issue , we would like to know what is the exact error message which you are getting while connecting to Oracle ? Is it just "Connection Failed" or is there anything else which you are seeing ?

     

    Thanks,

    Krishna

    Wednesday, July 7, 2010 5:52 AM