By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,527 Members | 1,192 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,527 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Simple" <wo*****@excite.com> wrote in message
news:2c**************************@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:
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")
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.