The connection manager 'OLEDB' is not properly installed on this computer
Please help someone from MSFT!
I've just finished installing the Sep CTP on my laptop. I previously had the April CTP and June CTP. I followed the instructions for removing a previous installation of SQL 2005.
Now, when I try to create an SSIS package, I get a message that says:
TITLE: Microsoft Visual Studio
The new connection manager could not be created.
ADDITIONAL INFORMATION:
The connection manager 'OLEDB' is not properly installed on this computer. (Microsoft.DataTransformationServices.Design)
For help, click:http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.24&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=ConnectionManagerNotInstalled&LinkId=20476
BUTTONS:
OK
I had this issue when I installed the June CTP and could not resolve it, so I abandoned the installation and did development on my server. I thought it would get resolved the next time I installed a new version, but no luck.
Any ideas?
Thanks!
This does look like a registration issue due to installation on a dirty machine. In the few instances we've seen this it has been easier to reset the OS on the box as harsh as that sounds.
You can instead try to uninstall manually by machine sure the registry keys and directories left around by VS and SQL are cleaned up. I'm not aware of any comprehensive list that you could use for this, though... perhaps ask on the SQL and VS setup aliases.
regards,
ash
I have just discovered this while trying to create an OLEDB connection in BI Studio. I have deinstalled and reinstalled SSIS and client tools serveral times. I also wrote a simple test in vbscript to ensure that MDAC 2.81 was installed.
What particular registeries are u talking about? To reset the OS would be drastic.
You can try to run:
regsvr32 dtsconn.dll, for the start.
I'm having this error too and this machine (XP + latest updates) has only seen the RTM version of SQL 2005 (not good for RTM) ....
Any ideas for a solution please?
Reinstalling the OS is not a solution.
Did you try the suggestion?
regsvr32 dtsconn.dll
K
yes and it had not effect :(
still looking for a solution.
Hey All,
I am learning to create packages using SSIS for school. I tried to create a new OLEDB connection, but when I type in my usual login id and password for my local SQL Server and want to 'Test Connection' in the OLEDB connection manager, I get a message 'Test Connection failed because of an error in initializing provider. Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the file specified. ' Looks like the connection information provided by me is not being recognized, as the available DBs are also not being listed in the Connection Manager, to enable me to chose the one I want to connect to. I have no clue as to what I need to do?!!! I'd appreciate if someone can help me asap!!
Thanks ahead!
I tried the above suggestion and it did not work.
Over the weekend, I deinstalled SSIS and client components. Went to regedit and deleted all references to Visual Studio. Reinstalled and still the same problem.
I can create and test a data source that is using the native client. When I try to create a connection in Studio using the data source, it fails again with the following error.
===================================
The connection manager could not be created from one or more data sources. (Microsoft Visual Studio)
===================================
The connection type "OLEDB" specified for connection manager "{F3C4B394-E196-4AFD-A2F6-37AD9AFCA94D}" 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.
(a1)
Any workaround would be welcome.
My install experience
--
I had to install Windows XP Professional SP2 prior to installing the CTP. I also had to deinstall OWC11 as it did not like the upgrade. The machine had SQL Server 2000 SP3a and Analysis Services 2000 SP3a.
I upgraded a SQL2000 database and imported its dts packages that run in compatibility mode. Analysis Services 2000 could not be upgraded and I had to deinstall prior to installing Analysis Services 2005.
Another wild guess - please reboot the machine ;)
If you still have the problem, could you please contact me via e-mail, I'll try to diagnose the problem. Remove "online." from the address in my user properties to get real address.
It would be great if you could send me logs from
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
and content of HKEY_CLASSES_ROOT registry
(I know it is big :) - but should compress well too).
Also - what is your locale in Windows' Regional and Language Option?
Michael,
Rebooted many times :(
I have sent you the requested information.
Michael,
I'm still having this problem as well. I've uninstalled all previous versions of SQL 2005, .NET Framework 2.0 and Visual Studio 2005. I then installed VS 2005 and SQL Server 2005.
But this did not solve the problem. Is there a solution?
Jason,
I'm still having problems .. I contacted Michale@microsoft but still no solution. It might be a good idea for you to email him like he sugests...
If enough of us have this problem then they may look into the problem in more depth ...
I sent Michael the details he requested yesterday. I tried twice this morning with the RTM with no success. I have given my laptop to our IT guy who is clearing the hard disk and doing a fresh install of Win XP Pro SP2 plus base s/w.
Fortunately, I have a desktop and can continue other work. I will still have to add all my dev tools to the laptop. Will keep you posted on progress.
