Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1452
  • Last Modified:

SQL 2005 Import Error " Could not set up data flow connections....is not recognized as a valid connection manager type"

Using SQL 2005 (client and server) on my desktop, I can access the tables in my two databases "A" and "B"   I've created.  They are identical.  But when I go to import or import  data from Table A to Table B:  I get this error:


===================================

Could not set up data flow connections.

The connection type "OLEDB" specified for connection manager "{0F36F8D6-3491-4017-A0FC-6C043B9B11F6}" is not recognized as a valid connection manager type. 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.
 (SQL Server Import and Export Wizard)

===================================

The connection type "OLEDB" specified for connection manager "{0F36F8D6-3491-4017-A0FC-6C043B9B11F6}" is not recognized as a valid connection manager type. 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.
 ({894E67DD-130A-4ACC-9E39-A11516959442})

------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnections90.Add(String bstrConnectionType)
   at Microsoft.SqlServer.Dts.DtsWizard.Execute.SetupConnections(Exception& ex)


I am totally confused.  Any suggestions or ideas?
0
vamail2
Asked:
vamail2
1 Solution
 
Brendt HessSenior DBACommented:
There is a possible solution from MS here:

http://support.microsoft.com/kb/913817/en-us

0
 
pai_prasadCommented:
wat kind of connection managers are been used..
0
 
vamail2Author Commented:
OMG!  Leave it to Adobe - they have nothing better to do but fonts and flash yet they always manage to mess windows up!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now