Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163

    Unanswered: Error open/accessing a MSSQL Linked Server

    Hi!

    Iím having the fallowing error when I try to open/access a linked server
    Error:
    Error 7302: Could not create an instance of OLE DB provider 'MSOLAP.2'.
    OLE DB error trace [Non-interface error: CoCreate of DSO for MSOLAP.2 returned 0x80004005].

    I have already tried to create the server using SEM and also with SQL syntax in ISQLW.
    Code:
    EXEC sp_addlinkedserver
    @server='LINKED_OLAP',
    @srvproduct='',
    @provider='MSOLAP.2',
    @datasrc='MyServerName.MyDomainí,
    @catalog='MyDataBase'

    Iím allowed to create the linked server but I canít use it.

    Information:
    OS: Windows 2003EE
    SQL: MSSQL 2000 + SP3a
    MDAC: MDAC2.8 rtm

    Thanks,
    Paulo

  2. #2
    Join Date
    Jan 2005
    Posts
    10
    when referring to objects defined in a linked server, you should use the convention:
    servername.databasename.userid.object

  3. #3
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163
    That it's not the problem for sure.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd see if any of Microsoft's ideas help.

    -PatP

  5. #5
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163
    Thanks, but none of the links apply to.

    Paulo

Posting Permissions

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