This is a short guide to help those who need to run the CandyPress shopping cart under Windows Vista and Internet Information Server (IIS) 7, including solving the mysterious error -2147467259 (Unspecified Error)

Enable Classic ASP on IIS7
Classic ASP is disabled by default in IIS7 (in favor of ASP.NET). To enable Classic ASP you need to go open IIS7's new management interface and go to "Control Panl / Programs and Features / Windows Components / IIS / Classic ASP"
Install the Jet Database Engine
Jet's latest version can be downloaded from
here (Microsoft). Theoretically, having MS Office installed should suffice but in practice it did not work for me and I had to install this standalone package.
Note for 64 bit users: You are out of luck here as Jet won't work under the 64 bit editios of Windows. The recommended upgrade path is to go to SQL Server Express 2005.
Privilege and Security Configuration
- Enable "Parent Paths" on IIS7 for the CandyPress website we are trying to install. Be careful here and enable it only for the websites you need, since "Parent Paths" is a well-known potential security hole.
- Grant read/write privileges to all IUSR_something users on the store's MDB (database) file.
- Do the same for the "C:\Windows\ServiceProfiles\NetworkService\AppData\Local" folder
- Notes:
- This last step is what is needed to solve error -2147467259 (Unknown Error). How did I get to this? Using this amazing tool called Process Monitor from SysInternals (now Microsoft). SysInternal's Process Monitor can be downloaded from here (Microsoft).
Test
Point your browser to the local URL for the store (
http://localhost/cp or similar) and now everything should work.