Re: ASP database connections not working

Well, the only time I've seen exactly that error message is when a) someone
messed up the FrontPage security (used by Interdev) so that no author had
permission to destroy the lock file, but that was when trying to edit rather
than just browse. b) When I tried to use a DSN with an UNC path in it.


All the documentation suggests NTFS permissions for the IUSR account as
being the most likely problem. Have you checked for a stray lock file in the
database directory?

Is the database username and password correct. Could be a simple typo
somewhere. If you're using DSN-less connection are you certain that the
syntax is still OK and hasn't somehow got changed?

Have you checked the security log on the server (as well as the web server
logs) to see if that shows any errors? You try regmon and filemon from
www.sysinternals.com to see what's actually failing.

Can't think of anything else at the moment. But don't reinstall, as you've
discovered, you've got to remove it first and it usually causes more
problems than it fixes.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
  Kathy
  DNRC  Minister for Useful but Irritating Information and Trivia
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
----- Original Message -----
From: Susan Duncan <sduncan(at)malico.com>
To: Kathy Evans <kje(at)vendetta.co.uk>
Cc: Hwg-Servers (E-mail) <hwg-servers(at)hwg.org>
Sent: Friday, May 12, 2000 4:39 AM
Subject: Re: ASP database connections not working


> Kathy,
>
> Jet is currently writing temp files to the winnt folder for Cold Fusion
> applications and I don't have the winnt directory open on it or another
system I
> played with.  The database is on the same machine as the web server so UNC
paths
> aren't a problem.
>
> As a test, I set up my own system with a clean install of Option Pack and
moved
> the files over there after doing setup and it worked fine.  Same basic
system,
> the only differences being a) a new install and b) I have access installed
on
> the second machine.
>
> I tried doing an Option Pack re-install on the first one but it sees the
> installed components so doesn't try to re-install.  I have about a dozen
servers
> set up on that machine so removing and re-installing isn't high on my list
of
> favorite things to do if I can avoid it.
>
> p.s. I'm using Access and Cold Fusion on a database with 14,000 records
and a
> site that gets about 400,000 impressions per month so it should be able to
> handle this application.
>
> Kathy Evans wrote:
>
> > You may need to give the IUSR account add and read perms to the winnt
folder
> > so that jet can write temp files. Does it work with a simple system DSN?
You
> > often have problems if the DSN contains an UNC path, esp if the resource
is
> > secured and trying to use challenge and response for authentication
instead
> > of basic. Access isn't at all good if they expect more  than a few hits
BTW.
> >
> > Also sending text of two other useful TechNet Qs, but not to the list.
> >
> > Kathy
> >
> > ----- Original Message -----
> > From: Susan Duncan <sduncan(at)malico.com>
> > To: Clif Warren <dodger(at)zianet.com>; Hwg-Servers (E-mail)
> > <hwg-servers(at)hwg.org>
> > Sent: Tuesday, May 09, 2000 2:07 AM
> > Subject: Re: ASP database connections not working
> >
> > > Everything is on the one machine.
> > >
> > > Clif Warren wrote:
> > >
> > > > Susan,
> > > >
> > > > Normally this error occurs when the database file resides on a
different
> > > > machine than the ASP files...  The MS Knowledge Base has some
> > information
> > > > about this at:
> > > >
> > > > http://support.microsoft.com/support/kb/articles/Q166/0/29.asp
> > > >
> > > > HTH,
> > > > - Clif
> > > >
> > > > At 12:52 AM 5/6/00 -0400, Susan Duncan wrote:
> > > > >I don't usually work with ASP but a client site hosts a couple of
other
> > sites
> > > > >and one of them has a newly redesigned site done in ASP.  I have
set up
> > the
> > > > >databases in the ODBC area and I can access them via ColdFusion but
not
> > > > ASP.  I
> > > > >have downloaded the latest MDAC files but no joy there.
> > > >
> > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > > >       Clif Warren,  MCP
> > > >     Lazerlite Enterprises
> > > >        1981 Bayard Ct.
> > > >     Las Cruces, NM  88001
> > > >     Phone: (505) 526-1355
> > > >  E-Mail:  clif(at)lazerlite.com
> > > >   http://www.lazerlite.com/
> > > > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> > >
> > > --
> > >           Making the Web Work for You (tm)
> > >
> > > Susan Duncan (sduncan(at)malico.com) Voice: (613) 744-3283
> > > Director, Internet Development      Fax: (613) 744-1825
> > > http://www.malico.com         Toll Free: (877) WEB-PROS
> > > http://www.OttawaWEB.COM
> > > MALICO - Graphic Design and Internet Development
> > > Founders: Ottawa-Hull Chapter-Int'l Webmasters Association
> > >
> > >
> > >
>
> --
>           Making the Web Work for You (tm)
>
> Susan Duncan (sduncan(at)malico.com) Voice: (613) 744-3283
> Director, Internet Development      Fax: (613) 744-1825
> http://www.malico.com         Toll Free: (877) WEB-PROS
> http://www.OttawaWEB.COM
> MALICO - Graphic Design and Internet Development
> Founders: Ottawa-Hull Chapter-Int'l Webmasters Association
>
>
>

HWG: hwg-servers mailing list archives, maintained by Webmasters @ IWA