What services are required for IIS and DAO & MDAC etc?

[Jonathan E. \(NZ\)]

Hi there,
I have a real frustrating thing going on... and I have not managed to sort
it out.

Last week I installed a service pack onto an app I use a lot.
The SP basically wiped my computer out to the point where I thought my hard
drive was stuffed.
Over the course of 3 days I managed to actually get the computer working
enough (albeit very slowly --> 25+ mins just to boot up XP) and I removed
that program I suspect might be a fault.
This sorted it out.
I had to use MSCONFIG numerous times whilst sorting the computer out.
It would seem that MSCONFIG disabled all the SERVICES (as it is designed to)
but for some reason it did so perminantly... i.e. it did not restore them to
how they were previously set up.
I then had to get a list off the net explaining which services I needed to
put back into Manual Start and Auto start mode. All was well...

Yesturday, however, I went to run an .asp based website I have on my local
IIS setup. It has a database that it accesses. Yet I could not longer access
the database.
The Site db access test determines that it does not have the necessary
permissions...
Yet I have not changed the permissions.
I am wondering if there is a service that needs to be running in order for
ADO and MDAC and ODBC etc to work properly?

Does anyone know? Or is there somewhere I can read more on this?
I must say, I have tried starting all that various services that I think
could be related but nothing helped.
Perhaps a whole lot of permissions did get changed during that crash... no
idea. But I have ensured they are set up as instructed in the asp app I
have... no go through. Perhaps ADO / MDAC etc need certain permissions set?
Gosh... I have no idea really!!

Thanks a lot...
My business is on hold until I get this running again...

Regards,

Jonathan

 

[Tom Kaminski [MVP]]

Hi there,
I have a real frustrating thing going on... and I have not managed to sort
it out.

Last week I installed a service pack onto an app I use a lot.
The SP basically wiped my computer out to the point where I thought my hard
drive was stuffed.
Over the course of 3 days I managed to actually get the computer working
enough (albeit very slowly --> 25+ mins just to boot up XP) and I removed
that program I suspect might be a fault.
This sorted it out.
I had to use MSCONFIG numerous times whilst sorting the computer out.
It would seem that MSCONFIG disabled all the SERVICES (as it is designed to)
but for some reason it did so perminantly... i.e. it did not restore them to
how they were previously set up.
I then had to get a list off the net explaining which services I needed to
put back into Manual Start and Auto start mode. All was well...

Yesturday, however, I went to run an .asp based website I have on my local
IIS setup. It has a database that it accesses. Yet I could not longer access
the database.
The Site db access test determines that it does not have the necessary
permissions...

Not really sure what that means, but try starting here:
http://www.aspfaq.com/show.asp?id=2009

 

[Jonathan E. \(NZ\)]

Hi Tom,
I found that site very informative.
What I have done is install MDAC 2.8 onto my system. This has corrected much
of the problem I was having.

I do, however, continue to get another error on a particular connection
script that used to always work.
The error is:
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

----------------------------------------------------------------------------
----

Technical Information (for support personnel)

a.. Error Type:
Microsoft JET Database Engine (0x80004005)
Unspecified error
-----------------------------------------------------------
The connection script is:
"provider=microsoft.jet.oledb.4.0;persist security info=false;data
source=E:\Website Root\siteroot\database.mdb"

This is a pretty generic Jet connection string... It used to work fine but
now gives me the above error.
The info I find on the site you directed me to is that it's a permissions
issue... Yet I have set the correct permissions on the site root, the
database, the system TEMP directory etc etc.

Does anyone have a suggestion as to why I might be getting this error?

With my regards,

Jonathan

 

[Jonathan E. \(NZ\)]

I managed to sort this issue out (as described below re Jet connection).
Thanks.

J