SSMA 2008 for Oracle: Connect Identifier RRS feed

  • Question

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


    Nitin Pawar

    Tuesday, July 6, 2010 5:50 AM


  • Hi Nitin,

    Connect Identifier would be something like this

    Connect Identifier :


    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 ?




    Wednesday, July 7, 2010 5:52 AM