I have a VB Script that I call from my ASP page. One of the first
things it does is:
'Launch Access
Server.CreateObject("Access.Application")
'Open DB
'Preview Report
This works fine on IIS 5.x, on Windows XP. But when I try this on
Windows 2003 (with the latest IIS that ships with it), it does not
work. I can see in the IIS Log that the Server.CreateObject failed.
What I'm trying to achieve has been well explained in:
http://www.4guysfromrolla.com/webtech/042600-1.shtml
I tried playing around with the user/permissions (for IIS Out-Of-Proc,
DCom Config - Access DB/App), etc in Component Services and IIS (Pool,
Website properties). But to no avail.
I'm trying this on the local machine, where IIS and Access 2002 are
installed. Other ASP and ASP.Net pages work fine on this box. So there
are no generic configuration / network / firewall issues, per se.
Your ideas/suggestions will be deeply appreciated.
Thanks.