Re: Server.CreateObject works on IIS 5.x / WinXP Fails on IIS 6.x / Win2K3

From: McKirahan (News_at_McKirahan.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 11:15:30 GMT

"Simple" <workset@excite.com> wrote in message
news:2c48820c.0407130849.11ccaf40@posting.google.com...
> 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.

Is MS-Office XP installed?

Try for XP:

Set oAppXP = Server.CreateObject("Access.Application.10")

Relevant Pages
Loading