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

    Unanswered: Stored proc requesting data via an exchange linked server

    I have created a MS Exchange 2000 link server in my MS SQL Server 2k. I have created a stored procedure (and a view...) using info from that linked server. When I am logged on the server as the Administrator, I can call my stored proc without any problems. When I use another computer (and I am not logged as the admin of the server) and I call the stored procedure, the following error is always raised :
    Server: Msg 7302, Level 16, State 1, Procedure test_proc, Line 3
    " Impossible de créer une instance du fournisseur OLE DB 'exoledb.DataSource.1'. "
    <== I know it is a french error but it can be translated as : "Unable to instancied the OLE DB 'exoledb.DataSource.1' provider"

    I would like to know if I can make run my stored proc in the admin account or what should I do to make it work

  2. #2
    Join Date
    Jan 2004


    This is the code of my stored proc :
    CREATE PROCEDURE test_proc
    SELECT Convert(nvarchar(30), "urn:schemas:contacts:sn") LastName
    FROM OpenQuery(Exchange, 'SELECT "urn:schemas:contacts:sn"
    FROM SCOPE(''shallow traversal of ".\Clients et fournisseurs"'')')

    this is the code of my linked server :
    EXEC sp_addlinkedserver 'exchange',
    'Exchange OLE DB provider',
    'file:\\.\backofficestorage\<myhostname>\public folders'

    Thank a lot

Posting Permissions

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