[OT] Problems with Win2003 IIS6 ASP Classic

[ukha@xxxxxxxxxxx]

Hi All,

Can anyone help with a Win2003 problem.


I have an ASP application (Classic ASP not ASP.net) that works fine on
XP PRo IIS5 but I just cant get it to run under Win2003 IIS6. As soon
as I try to create a database connection I get the following
error.......


Server object error 'ASP 0178 : 80070005'

Server.CreateObject Access Error

/crm/Includes/AppConn.asp, line 9

The call to Server.CreateObject failed while checking permissions.
Access is denied to this object.



..... the offending line is .....

Set connection = Server.CreateObject("ADODB.Connection")


I have googled extensively and tried all the different settings that
are suggested in the various sites and have gone so far as to give
full access to IUSR_<machinename> and EVERYONE but I still dont get
permission to create the ADODB object.

ASP is definately working because the first page I hit is
"index.asp"
which then redirects to "Welcome.asp" because I am not logged in.
I
complete the login and submit but everything then comes to a halt as I
cant create the database connection.

Hopefully there is a Win2K3 guru out there who can tell me exactly
where I am going wrong !!!

Thanks

Keith