Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Location
    México
    Posts
    2

    Unhappy Unanswered: Problem with OLEDB

    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..!!??
    Last edited by Ismashing; 10-08-03 at 19:19.

  2. #2
    Join Date
    May 2003
    Location
    UK
    Posts
    220
    Howdy

    Whare are you trying to execute the script from when you have this problem? What is the setup of the system you are usiong?

    Cheers

    SG

  3. #3
    Join Date
    Oct 2003
    Location
    México
    Posts
    2
    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.!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •