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
"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:bqko1r$q3d10@kcweb01.netnews.att.com...
> "Jonathan E. (NZ)" <s_pam_stop.RemoveThis@hotmail.comTAKEOUTTHESECAPS> wrote in
message
> news:ex1wIrSuDHA.3196@TK2MSFTNGP11.phx.gbl...
> > 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:
<font color=purple> > <a style='text-decoration: underline;' href="http://www.aspfaq.com/show.asp?id=2009</font" target="_blank">http://www.aspfaq.com/show.asp?id=2009</font</a>>
>
>
> --
> Tom Kaminski IIS MVP
> <a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running
IIS
<font color=purple> > <a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/</font" target="_blank">http://mvp.support.microsoft.com/</font</a>>
<font color=purple> > <a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/</font" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</font</a>>
>
>
><!-- ~MESSAGE_AFTER~ -->
>> Stay informed about: What services are required for IIS and DAO & MDAC etc?