Solved

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

Posted on 2006-06-09
3
1,409 Views
Last Modified: 2013-12-03
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
Comment
Question by:vamail2
3 Comments
 
LVL 32

Accepted Solution

by:
bhess1 earned 500 total points
ID: 16873352
There is a possible solution from MS here:

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

0
 
LVL 10

Expert Comment

by:pai_prasad
ID: 16874465
wat kind of connection managers are been used..
0
 

Author Comment

by:vamail2
ID: 16880641
OMG!  Leave it to Adobe - they have nothing better to do but fonts and flash yet they always manage to mess windows up!!!!
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now