Board index » delphi » Cannot modify read only table error

Cannot modify read only table error


2003-07-24 10:57:10 PM
delphi46
Hi,
I'm developing a ISAPI application. So, I have a TWebModule
with a TTable component on it (just to keep it simple). I can
open and retrieve all the records, but when I want to do the
following : Table.Edit, I am receiving a "Cannot modify a
read-only dataset.
The table itself is a paradox table and is located under the
wwwroot\db folder. I have created that folder and set Read/Write
access in the IIS admin console.
The same component + code works well in a normal desktop application, so it must have something to do with the IIS (I
guess), or am I doing something wrong ?
Many thanks in advance,
Nico Callewaert
 
 

Re:Cannot modify read only table error

By default, IIS uses the IUSER_XXX account when processing web requests.
This account needs read/write permissions to that directory. You could also
make that account a member of the Administrator Group and it will have all
the access that the Administrator has (then you don't have to keep
specifying each folder). Not safe for a production box, but makes life
easier on a development box.
DaveH
"Nico Callewaert" <XXXX@XXXXX.COM>writes
Quote

Hi,

I'm developing a ISAPI application. So, I have a TWebModule
with a TTable component on it (just to keep it simple). I can
open and retrieve all the records, but when I want to do the
following : Table.Edit, I am receiving a "Cannot modify a
read-only dataset.
The table itself is a paradox table and is located under the
wwwroot\db folder. I have created that folder and set Read/Write
access in the IIS admin console.
The same component + code works well in a normal desktop application, so
it must have something to do with the IIS (I
guess), or am I doing something wrong ?

Many thanks in advance,

Nico Callewaert
 

Re:Cannot modify read only table error

Hi Dave,
It works !!!
Thanks a lot for the respons...
Nico
"DaveH" <XXXX@XXXXX.COM>writes:
Quote
By default, IIS uses the IUSER_XXX account when processing web requests.
This account needs read/write permissions to that directory. You could also
make that account a member of the Administrator Group and it will have all
the access that the Administrator has (then you don't have to keep
specifying each folder). Not safe for a production box, but makes life
easier on a development box.

DaveH


"Nico Callewaert" <XXXX@XXXXX.COM>writes
news:3f1ff3c6$XXXX@XXXXX.COM...
>
>Hi,
>
>I'm developing a ISAPI application. So, I have a TWebModule
>with a TTable component on it (just to keep it simple). I can
>open and retrieve all the records, but when I want to do the
>following : Table.Edit, I am receiving a "Cannot modify a
>read-only dataset.
>The table itself is a paradox table and is located under the
>wwwroot\db folder. I have created that folder and set Read/Write
>access in the IIS admin console.
>The same component + code works well in a normal desktop application, so
it must have something to do with the IIS (I
>guess), or am I doing something wrong ?
>
>Many thanks in advance,
>
>Nico Callewaert