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

[Simple]

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:
[url]http://www.4guysfromrolla.com/webtech/042600-1.shtml[/url]

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.

[McKirahan]

"Simple" <workset@excite.com> wrote in message
news:2c48820c.0407130849.11ccaf40@posting.google.c om...

> 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:
> [url]http://www.4guysfromrolla.com/webtech/042600-1.shtml[/url]
>
> 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")