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)
------------------------------
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!
The connection manager 'OLEDB' is not properly installed on this computer
WackyNET
You can try to run:
regsvr32 dtsconn.dll, for the start.
goofu555
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!
Oscar Ivan Gil
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.
Amshanti
Rebooted many times :(
I have sent you the requested information.
Albert Yen - MS
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
William Kirchhoff
Hello Jason...I am expiriencing the same error. Have you found any solutions yet Thanks,
Error:
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.26&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=ConnectionManagerNotInstalled&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Kozin
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 ...
footballdirector
What particular registeries are u talking about To reset the OS would be drastic.
PeterX
still looking for a solution.
eaglefire82
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
James Wang
regsvr32 dtsconn.dll
K
hector santos
Any ideas for a solution please
Reinstalling the OS is not a solution.
jziemian
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
Boudy
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.