Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
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
Medium Priority
?
1,430 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 32

Accepted Solution

by:
Brendt Hess earned 2000 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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

604 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