Re: ASP database connections not working

You may need to give the IUSR account add and read perms to the winnt folder
so that jet can write temp files.

Also may need to be able to delete temp files (definitely for MS Access) so
you need to watch where these are being created (probably same folder as
database) and grant appropriate perms.

Also check that the database AND the DSN are not marked as Exclusive. I also
set connection pooling for the Access driver (which is not the default), and
use ver 4.00.4202.00 of the driver. Mine's only a small intranet, so
there'll be lots I've missed. The vdirectory has only read perms, but the
users (intranet) have read, write and delete (NTFS) to the database folder

 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
>
>
>

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