Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
qh8519a
Starting Member
1 Post |
 Posted - 2009-09-22 : 08:06:56
|
| Good Morning,I linked 2 servers together (A linked to B) and they both run SQL 2000. I get the following error when I try to run a query from server A against server B using the 4 part naming convention:OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB returned 0x80040154].Msg 7302, Level 16, State 1, Line 1Could not create an instance of OLE DB provider 'SQLOLEDB'.I get the same error when I try to create an ad-hoc link using an open rowset query. The part that throws me off is that when I linked server B to server A, I can query from B to A with no problem. The research that I have done leads me to believe that it is with a DLL or MDAC. Server A is running Windows 2000 with SP 4 and MDAC 2.8. Any direction would be helpful.ThanksDrew |
|
|
tripodal
Constraint Violating Yak Guru
259 Posts |
Posted - 2009-09-22 : 15:04:57
|
| Is server B running the same version of MDAC?Sometimes people have recommended reinstalling MDAC even if it is the correct version. I imagine the service pack levels of SQL windows .net or mdac are not identical. With server B probably being newer. |
 |
|
|
|
|
|
Could not create an instance of OLE DB provider