servers

After upgrading a SQL Server 2000 SP3 server from Windows 2000 to Windows
2003 we get this message when trying to use a linked server...
Could not create an instance of OLE DB provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB
returned 0x8007007f].
Any thoughts?Questar,
See these threads:
http://groups.google.com/groups?q=jczypinski+oledb32r
http://groups.google.com/groups?q=kotuby+oledb32.dll+solved
A wrong version of oledb32.dll might be the issue.
Steve Kass
Drew University
Questar wrote:
>After upgrading a SQL Server 2000 SP3 server from Windows 2000 to Windows
>2003 we get this message when trying to use a linked server...
>Could not create an instance of OLE DB provider 'SQLOLEDB'.
>OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB
>returned 0x8007007f].
>Any thoughts?
>
>|||Good call. Problem solved. Thank you!
"Steve Kass" wrote:
> Questar,
> See these threads:
> http://groups.google.com/groups?q=jczypinski+oledb32r
> http://groups.google.com/groups?q=kotuby+oledb32.dll+solved
> A wrong version of oledb32.dll might be the issue.
> Steve Kass
> Drew University
> Questar wrote:
> >After upgrading a SQL Server 2000 SP3 server from Windows 2000 to Windows
> >2003 we get this message when trying to use a linked server...
> >
> >Could not create an instance of OLE DB provider 'SQLOLEDB'.
> >OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB
> >returned 0x8007007f].
> >
> >Any thoughts?
> >
> >
> >
>