Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

the connection type "MSORA" is not recognized as a valid connection name Expand / Collapse
Author
Message
Posted Saturday, May 10, 2014 11:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, May 10, 2014 11:43 AM
Points: 1, Visits: 0
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.
Post #1569541
Posted Saturday, May 10, 2014 1:14 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:40 AM
Points: 3,093, Visits: 8,768
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?
Post #1569550
Posted Tuesday, January 6, 2015 4:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, March 4, 2015 9:06 AM
Points: 70, Visits: 163
Hi there!

I have exactly the same problem. I am attempting to transfer my Development environment from 1 machine to another, and am getting this error on the new machine. Everything works fine on the old one.

There is clearly something that I need to install on my new machine, but I don't know what it is!
Post #1648599
Posted Tuesday, January 20, 2015 8:40 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:13 PM
Points: 1,432, Visits: 7,295
Oracle Client and the use of OracleOleDB?
MSOra is probably the old deprecated oracle driver
Post #1652806
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse