Re: MS Access on IIS 5.0

From: Jeff Cochran (jeff.nospam_at_zina.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 13:43:03 GMT

On Wed, 16 Jun 2004 02:56:21 -0700, "Robin"
<anonymous@discussions.microsoft.com> wrote:

>I do in fact have an include file which will save me from
>having to modify each page. I know this is another
>problem which I have to fix but I think I can manage this
>myself *fingers crossed*
>
>I moved the databases to another folder but now I can't
>get the site to pull the info out of them or post into
>it. Page simply displays blank fields where the data
>should populate!?!?!

When you move the file, you need to change the connection string to
match the new location.

>What code do I need in the include file? I'd like to
>avoid configuring any DSN.
>Currently the code looks something like this:
><% Session("databasepath")
>= "D:\Inetpub\wwwroot\sitename\data\databasename.mdb" %>
>Do I leave it this way or change it? If I leave it how
>do I get the database's to work now that I've moved them!

Change this path to wherever you moved the file. If it's moved to
D:\Databases\Sitename\Database.mdb for example, replace the path in
your code with the correct path.

Jeff

>Thanks again for your help!!!
>Very appreciative!
>
>
>>Normally a designer would use an include file for the
>database
>>connections, but some code this into every page and
>unfortunately
>>you'd need to change those pages individually. As for
>permissions,
>>usually just the system account needs access, but if the
>folder is
>>outside that defined in IIS it can't be accessed by a
>HTTP request to
>>download it, no matter what security the folder/file
>has. Also use
>>URLScan if you're on IIS5 to defeat parent paths or
>directory
>>traversing, and make sure the server has current
>security patches.
>>
>>Jeff

Relevant Pages

  • Re: MS Access on IIS 5.0
    ... Its working like a charm! ... >>having to modify each page. ... >>I moved the databases to another folder but now I can't ...
    (microsoft.public.inetserver.iis.security)
  • Why does Outlook 2003 remove all the plus sign prefixes from my t.
    ... Whenever I try to modify the telephone numbers of a contact in the Contacts ... folder, Outlook 2003 will not allow a '+' sign to be prefixed to the numbers ... Why is this and is there a fix for it? ...
    (microsoft.public.outlook.contacts)
  • Re: Word mail merge data source
    ... Word on it) then there may be a problem if the folder containing the data ... Word builds a connection string. ... but just because a user has full admin rights does not necessarily ... superset of other users' permissions - for example, ...
    (microsoft.public.word.vba.general)
  • Re: [lde4.1}Desk top missing
    ... I had for the new users home dir. ... may be able to fix it, ... I copied my orig home folder to the new home oldhome folder. ... BadAccess (attempt to access private resource denied) 10 ...
    (Ubuntu)
  • Re: C:WINNTSYSTEM32AUTOEXEC.NT Error .Help plz if you can !!
    ... Hi Peoples - Well, the fix will run on Win2k, but I'm not sure if it's smart ... In Folder options click on the View tab. ... >> Temp folder and go to Edit> Select All then Edit> Delete to delete ... >> the entire contents of the Temp folder. ...
    (microsoft.public.win2000.general)