Link exchange question

  • Hi everybody,

    I have a problem.  I'm creating an intranet for the company where i work.  That intranet will manage task.  So, whenever a task is create, i want to create it in Exchange/Task of that person.  I want to link exchange with my SQL Server to create those task with a SQL request but i have a lot of problem doing it.  I cant seem to find a clear answer on the net.  I tried a looooot of stuff to get this to work.  So far, i'm only able to link to "public folders" of exchange.  But the user arent there.  They are in the MBX folder.  Is it possible ?  Does anybody have an idea?

  • Can you post details of what you tried?

  • Well, first, I tried to access it trought my asp page.  I pass the last 3 days trying to pull a code that work but, i'm not lucky!  So now, with sql server, I tried to link directly througth the MBX folder with EM but theres always an error in the table or view.  But, in the public folders it work.  But like I said, the data I need are in the MBX folder.  I also tried via the sql query.  I tried the code in the MSDN.  But i correct the "localhost" error.  But my view never work and my data arent there.  The view generator gives me the 7301 error i think but i'm not sure. I'm not a the office.   I tried a couple of other thing but, like i said, i'm not at the office.

    EXEC sp_addlinkedserver 'exchange',

    'Exchange OLE DB provider',

    'exoledb.DataSource.1',

    'file:\\.\backofficestorage\localhost\public folders'

  • Hi Denillenium,

    Are you able to access Exchange public folder from SQL Server after creating Linked Server ????

    I have created linked server in SQL Server and I am now able to see the Public folders in SQL Server but its contents ????

    Microsoft Article 287753 says some thing else.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply