Home Forums SQL Server 2005 Working with Oracle the connection type "MSORA" is not recognized as a valid connection name RE: the connection type "MSORA" is not recognized as a valid connection name

  • May 10, 2014 at 1:14 pm

    #1712412

    jnsosnowski (5/10/2014)

    hello ,

    can anybody help me with the problem:

    when I tried to run package from SQL Server management studio I get the error:

    the connection type "MSORA" specified for connection manager "ConnectionToOracle" is not recognized as a valid connection name

    this error is returned when an attempt is made to create a connection manager for an unknown connection type, check the spelling in the connection type name. Check the speling in the connection type name.

    When I run the project from VisualStudio its runing well.

    What can I do with it.

    please, help.

    Quick questions, is this on the same system and what happens when you run the package with dtexec?

    😎