Erwin Craps - IT Helps
Erwin.Craps at ithelps.be
Sat Jun 18 04:17:27 CDT 2005
I Was able to locate and solve the problem with aid of the MDAC
component checker.
I noticed that some ADO files where located at "Z:\program Files\Common
Files\system" instead of the normal C: drive.
The NTFS file security for this system folder where not correctly set as
specified in the MS articles.
I always checked the C drive folder!!!
That leaves me with the question why these MDAC are installed in the Z
drive.
My account data specifies drive Z: for the home directory, but again I
don't see the point why my common files are set to the Z drive. I
changed the registry entries from all Z: to C: and noticed the a
registry key commonfilesfolder (or something) was set to the z drive. I
changed that to to C:
To conclude this problem I blmieve what happened is this.
1) I analised my server with MSBA that resulted in a MDAC that needed
updating.
2) I updated the MDAC but also windows updates an SQL SP4 to save time.
3) For some resaon MDAC update installed onto the Z drive instead of the
C
4) The Z: drive is a user folder where only administrators (group) and
the user (in this case the administrator (user) has access to. Due to
NTFS security limitations on the Z drive the IIS could not load MDAC
components using thr IUSR failing all data access from my website.
Probably lost 12 working hours and 3 days of website problems.
Thank you whomever to thank (maybe myself with that home folder thing,
but this has worked for 2 years)
Erwin
-----Oorspronkelijk bericht-----
Van: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] Namens Erwin Craps - IT
Helps
Verzonden: vrijdag 17 juni 2005 21:16
Aan: Access Developers discussion and problem solving
Onderwerp: RE: [AccessD] Urgent
helpneededwithIISserver.CreateObject("ADODB.Connection")
Il give it a shot.
I noticed now that also FSO does not work anymore in ASP...
Must be clearly one of this months windows updates that has caused this.
Erwin
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of MartyConnelly
Sent: Friday, June 17, 2005 5:26 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Urgent help
neededwithIISserver.CreateObject("ADODB.Connection")
Have you tried filemon from sysinternals.com to trace the access
permission error
Erwin Craps - IT Helps wrote:
>Noop, Doesnt solve the problem.
>Already added those.
>
>Problem is persistent..
>
>
>-----Oorspronkelijk bericht-----
>Van: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] Namens Jim Lawrence
>Verzonden: donderdag 16 juni 2005 17:07
>Aan: 'Access Developers discussion and problem solving'
>Onderwerp: RE: [AccessD] Urgent help needed
>withIISserver.CreateObject("ADODB.Connection")
>
>Hi Erwin:
>
>Have you seen this article from MS?
>http://support.microsoft.com/kb/198432/EN-US/
>
><Microsoft>
>Solution:
>You need to give the IUSR_<machine_name> account permissions to launch
>and access your OOP COM object using dcomcnfg by doing the following:
>1. Launch DCOMCNFG by clicking the Start button, selecting Run, and
>typing "Dcomcnfg" in the Run dialog box.
>2. In the Default Security tab, click the "Edit Default" in the
>"Default Access Permissions" frame. The Registry Value Permissions
>dialog box appears.
>3. Add the IUSR_<machine_name>account and the INTERACTIVE account to
>the Registry Value Permissions dialog box, and click OK.
>4. In the Default Security tab, click the Edit Default in the Default
>Launch Permissions frame. The Registry Value Permissions dialog box
>appears.
>5. Add the IUSR_<machine_name> account to the Registry Value
>Permissions dialog box0, and click OK.
></Microsoft>
>
>HTH
>Jim
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps
>- IT Helps
>Sent: Thursday, June 16, 2005 4:43 AM
>To: Access Developers discussion and problem solving
>Subject: [AccessD] Urgent help needed with
>IISserver.CreateObject("ADODB.Connection")
>Importance: High
>
>
>I'm getting desperate over here.
>
>Yesterday I installed this mont security fixes on my W2K server.
>I also took the opportunity to install SQL SP4.
>
>>From that reboot on, non of my database driven website no longer
>functions.
>
>For both "JET 4 MDB" and "SQL server" access I get an error on this
>command where it always used to work before the updates.
>failing command server.CreateObject("ADODB.Connection")
>Retunred error
>Server object error 'ASP 0178 : 80070005'
>Server.CreateObject Access Error
>The call to Server.CreateObject failed while checking permissions.
>Access is denied to this object.
>
>
>
>
>I checked al my NTFS permissons according to the MSKB, but I believe
>everything is ok.
>
>Anyway, it worked for years before this update.
>
>
>
>Is this a bug in the windows fiexes????
>
>
>
>
>
>
>
>Erwin Craps
>
>Zaakvoerder
>
>www.ithelps.be/onsgezin
>
>
>
>This E-mail is confidential, may be legally privileged, and is for the
>intended recipient only. Access, disclosure, copying, distribution, or
>reliance on any of it by anyone else is prohibited and may be a
>criminal offence. Please delete if obtained in error and E-mail
>confirmation to the sender.
>
>IT Helps - I.T. Help Center *** Box Office Belgium & Luxembourg
>
>www.ithelps.be <http://www.ithelps.be/> * www.boxoffice.be
><http://www.boxoffice.be/> * www.stadleuven.be
><http://www.stadleuven.be/>
>
>IT Helps bvba* ** Mercatorpad 3 ** 3000 Leuven
>
>IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail:
>Info at ithelps.be
>
>Box Office ** Fax: +32 16 296 406 ** Box Office E-mail:
>Staff at boxoffice.be <mailto:figures at boxoffice.be>
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
--
Marty Connelly
Victoria, B.C.
Canada
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com