I have this error when i execute this script(for example)...
exec MYSERVER.master..sp_who active
Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB returned 0x80004002].
But when i execute this in the server, it Works.
exec master..sp_who active
Already install MDAC 2.7 and SQL Service Pack 3
What can i do..!!??
Thanks for your post i have SQL 2000 on Windows 2000 Server...we found the problem it was this hotfix:
MS03-026:Buffer Overrun in RPC May Allow Code Execution
We don't know why but it was uninstalled and it works.....Thanks.!