I have been experiencing problems with accessing the MS Project OLEDB provider, and I can't seem to figure out why. I m also amazed at the lack of support/documentation/help that is available for programatically accessing Project.
We have a block of code that attempts to create a connection to the MS Project OLEDB provider. Out Block of code attempts to make a connection using 1 of 3 Drivers i.e Ms Project OLDB Provider 9,10 and 11. We don't seem to have the same problem every body else has , by accessing the dirver. It seems to be more a permissioned based problem we have. I believe our problem stems form the permission rights between IUSR and ASPNET user accounts on the machine.
IF we do the Following in our Web.Config File.
<authentication mode="Windows" />
<identity impersonate = "false" />
This works fine our code that we use to create a connection to MS Project works fine and we can read all the information in a MS Project fine. Very Cool. This is becuase IIS instructs the ASPNET worker process. Which I believe has access to the OLEDB Provider
Now if I make the following change to our Web.Config file
<authentication mode="Windows" />
<identity impersonate = "true" />
When I Set the web.config file to this, things turn to pot. This is becuase IIS instructs the IUSR account, which I believe does not have access to the OLEDB provider. I thought things would be simple if I just ran a test and placed the IUSR account into the User Group. This still didn't work. So I thought I'd try place the IUSR account into the Administrator group, it still didn't work.
Any help would be appreciated on this.