🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Thread View: comp.lang.pascal.delphi.databases
4 messages
4 total messages Started by Craig Manley Sat, 04 Apr 1998 00:00
Urgent: How do you set up NT permissions for BDE on IIS?
#183
Author: Craig Manley
Date: Sat, 04 Apr 1998 00:00
52 lines
2783 bytes
Hi,

http://www.activo.nl/skybound/cgi-bin/bdetest.exe

I've got to run a CGI program on my providers server. I gave them a
deployment of the BDE that I also installed on my test NT server. I then
ran this program that opens a dBASE file in read only mode and displays
it in HTML format.

On my server using FAT on shared partition C: (where BDE resides) and
NTFS on D: (where \InetPub directory and dBASE file reside) everything
works.

My provider has given the \InetPub directory and subdirectories on the
D: partition fullaccess to IUSR (the username of the IIS). My provider
has given the C: partition access to Admins only.

Does the C: partition need other access permissions to for programs
running under the permissions of the IUSR to use the BDE?

The URL above returns error code $2B05 = Permission denied.

Greetings,
Craig Manley.
-- 
    (^>
 |  ||                       O
 |--||--========--__________/
<   craig @skybound.demon.nl | http://www.skybound.demon.nl/craig
 |------.-----------,--, ====| ICQ: 9429416
 |        '---------    \    |
                         \___|
              ___/^\___
                |   |
             !==|   |==!
 _______________|/^\|_______________
| C R A I G     |___|   M A N L E Y |
|____________   | . |   ____________|
|____________|__|<O>|__|____________|
|               |\ /|               |
                |   |
                | | |
            ____/|||\____
           |_____|||_____|
           |_____|||_____|
                  "
                                  _     ___
 ___________________________     |_\___/_|_\__ |
|Java Delphi Perl CGI ISAPI |----|_______===__|=
 ---------------------------      o         |  |
                                            O
Re: Urgent: How do you set up NT permissions for BDE on IIS?
#180
Author: Ray Porter
Date: Mon, 06 Apr 1998 00:00
74 lines
3256 bytes
IUSR needs pretty much full access to the Winnt\System directory.  The BDE
tries to create/write/delete temporary files in that directory.  The name
escapes me right now but there is a utility that will let you see exactly
where and what these files are.

Craig Manley wrote:

> Hi,
>
> http://www.activo.nl/skybound/cgi-bin/bdetest.exe
>
> I've got to run a CGI program on my providers server. I gave them a
> deployment of the BDE that I also installed on my test NT server. I then
> ran this program that opens a dBASE file in read only mode and displays
> it in HTML format.
>
> On my server using FAT on shared partition C: (where BDE resides) and
> NTFS on D: (where \InetPub directory and dBASE file reside) everything
> works.
>
> My provider has given the \InetPub directory and subdirectories on the
> D: partition fullaccess to IUSR (the username of the IIS). My provider
> has given the C: partition access to Admins only.
>
> Does the C: partition need other access permissions to for programs
> running under the permissions of the IUSR to use the BDE?
>
> The URL above returns error code $2B05 = Permission denied.
>
> Greetings,
> Craig Manley.
> --
>     (^>
>  |  ||                       O
>  |--||--========--__________/
> <   craig @skybound.demon.nl | http://www.skybound.demon.nl/craig
>  |------.-----------,--, ====| ICQ: 9429416
>  |        '---------    \    |
>                          \___|
>               ___/^\___
>                 |   |
>              !==|   |==!
>  _______________|/^\|_______________
> | C R A I G     |___|   M A N L E Y |
> |____________   | . |   ____________|
> |____________|__|<O>|__|____________|
> |               |\ /|               |
>                 |   |
>                 | | |
>             ____/|||\____
>            |_____|||_____|
>            |_____|||_____|
>                   "
>                                   _     ___
>  ___________________________     |_\___/_|_\__ |
> |Java Delphi Perl CGI ISAPI |----|_______===__|=
>  ---------------------------      o         |  |
>                                             O



--
================================================
Ray Porter
Applications Analyst Programmer
Administrative Information Services, UNC-CH
Phone: 966-5878
email: lrp@email.adp.unc.edu
         dragon@email.unc.edu
Home Page: http://www.adp.unc.edu/~allrp/

"Meddle not in the affairs of dragons,
for you are crunchy and taste good with ketchup."
Re: Urgent: How do you set up NT permissions for BDE on IIS?
#181
Author: KONTO d.o.o. Pozega, Varazdin -B...
Date: Mon, 06 Apr 1998 00:00
74 lines
3276 bytes
On Sat, 04 Apr 1998 16:44:40 +0200, Craig Manley
<Craig@skybound.demon.nl> wrote:

>Hi,
>
>http://www.activo.nl/skybound/cgi-bin/bdetest.exe
>
>I've got to run a CGI program on my providers server. I gave them a
>deployment of the BDE that I also installed on my test NT server. I then
>ran this program that opens a dBASE file in read only mode and displays
>it in HTML format.
>
>On my server using FAT on shared partition C: (where BDE resides) and
>NTFS on D: (where \InetPub directory and dBASE file reside) everything
>works.
>
>My provider has given the \InetPub directory and subdirectories on the
>D: partition fullaccess to IUSR (the username of the IIS). My provider
>has given the C: partition access to Admins only.
>
>Does the C: partition need other access permissions to for programs
>running under the permissions of the IUSR to use the BDE?
>
>The URL above returns error code $2B05 = Permission denied.
>
>Greetings,
>Craig Manley.
>-- 
>    (^>
> |  ||                       O
> |--||--========--__________/
><   craig @skybound.demon.nl | http://www.skybound.demon.nl/craig
> |------.-----------,--, ====| ICQ: 9429416
> |        '---------    \    |
>                         \___|
>              ___/^\___
>                |   |
>             !==|   |==!
> _______________|/^\|_______________
>| C R A I G     |___|   M A N L E Y |
>|____________   | . |   ____________|
>|____________|__|<O>|__|____________|
>|               |\ /|               |
>                |   |
>                | | |
>            ____/|||\____
>           |_____|||_____|
>           |_____|||_____|
>                  "
>                                  _     ___
> ___________________________     |_\___/_|_\__ |
>|Java Delphi Perl CGI ISAPI |----|_______===__|=
> ---------------------------      o         |  |
>                                            O


When you open Access table one file is temporary written on disk.
Something like recordlocking. Put your mdb file on disk with write
access and check BDE settings.

Shalom,

Mladen Kuzminski
BORLAND distribucija
KONTO d.o.o. Pozega, Ured Varazdin
042/231-994, 231-713

mailto:borland@konto.hr
http://www.konto.hr

LEGALNO JE SIGURNO! BSA g.i.u.
http://www.bsa.hr
mailto:hotline@bsa.hr
Re: Urgent: How do you set up NT permissions for BDE on IIS?
#182
Author: Craig Manley
Date: Mon, 06 Apr 1998 00:00
13 lines
1650 bytes
Hi Doug and everybody using the BDE in CGI's or ISAPI DLL's,

I found out what the problem was. My provider has the http directories
on the D: drive. By giving full-access to IUSR on D: and then slowly
removing the permissions we found out that the IUSR needed list
permissions in the root of D:. The DatabaseName in my CGI app is a path
to a directory on D: that contains DBF files (where the IUSR has full
access). Weird that the BDE needs a list permission there but now it
works at last.

Greetings,
Craig Manley.
Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads