Missing providers when oledb32.dll is not registered by dennis magielse

Closed

as External Help for as External

Type:	Suggestion
ID:	778733
Opened:	2/7/2013 5:48:42 AM
Access Restriction:	Public

Workaround(s)

view

When oledb32.dll is for some reason unregistered SQL Server is missing providers after installation.
During installation of SQL server there is no message in the user interface or in the installation log that dll is not registered
When the oledb32.dll provider is not registered it's not possible to connect to SQL Server with eg. visual studio, excel etc.
It's also not possible to make a linked server connection via server objects

Details (expand)

English

Setup

Check the registration of the oledb32.dll during the sql setup and respond with a message if not registered.
This can explain the missing providers under server objects and the connection problems with other products.

Improved Installation

faster problem solving

File Name	Submitted By	Submitted On	File Size
missing providers.png (restricted)	dennis magielse	2/7/2013	-

Posted by Microsoft on 4/24/2013 at 10:01 AM

Oledb32 is inband with Windows, there is no registration needed at all

Posted by dennis magielse on 4/18/2013 at 12:58 AM

SQL server 2008R2 standard edition on XP workstation

Posted by Microsoft on 2/13/2013 at 9:54 AM

Can we get more detailed info here? What version of the SQL server, etc.

Microsoft