Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Red face Unanswered: Lost OLE DB Providers

    I lost in SQL Server 2000 with SP3a on W2K Server Ole DB Provider.
    When I trying make new linked server I cannot select Provider name,
    because menu is empty. Existing link between SQL servers returning error message Error 7302: Could not create an instance of OLE DB provider 'SQLOLEDB'. OLE DB error trace [Non/interface error: CoCreate of DSO for SQLOLEDB returned 0x80004002]. I tried completly uninstall SQL from server and I installed server again without success.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Install the latest version of mdac from microsoft's download site.

  3. #3
    Join Date
    Jan 2004
    Posts
    2

    Thumbs down

    Originally posted by rnealejr
    Install the latest version of mdac from microsoft's download site.
    I installed MDAC 2.8 and server was restarted, but error still exist.

Posting Permissions

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