my condition
winxp, delphi 7 ,dbisam 4.17, iis with xp . ntfs

i wrtie a isapi to get some data from form and save it to db ,but when i use it ,it reports a "can not modify a read-only dataset" error , i had check
the permission of the data dir , and i foud the permission of the directory is set to readonly but the data file is not readly ,and i found i can not
change the permission of the dir ,if i change the permission of directory to read and write , after i applied ,it changed to readonly ,and i found if i
creat a new directroy on winxp ,the permission of the directory is readonly by default and you can not change it ,i had tried it on my desktop pc ,my
note book ,and computer of my parteners .

so ,how can i solve this ? is there any one can help me ?

here is the code

 with DBISAMTable1 do
 begin
   Open;
   Append;
   FieldByName('estado').Value:='test1';
   Post;
   Close;
 end;
 Response.Content:=DataSetTableProducer1.Content;
 Handled:=True;
and i use a database  a session and a table . i put session first and set active,auto session name  to true


lifayan <lifayan@gmail.com> wrote:

my condition
winxp, delphi 7 ,dbisam 4.17, iis with xp . ntfs

i wrtie a isapi to get some data from form and save it to db ,but when i use it ,it reports a "can not modify a read-only dataset" error , i had check
the permission of the data dir , and i foud the permission of the directory is set to readonly but the data file is not readly ,and i found i can not
change the permission of the dir ,if i change the permission of directory to read and write , after i applied ,it changed to readonly ,and i found if i
creat a new directroy on winxp ,the permission of the directory is readonly by default and you can not change it ,i had tried it on my desktop pc ,my
note book ,and computer of my parteners .

so ,how can i solve this ? is there any one can help me ?

my isapi works fine under introbob and idebug ,it just throws exceptions under iis.

It would appear that you have to have the server administrator change the
permissions on the folder. You can't override this without the proper
permissions.

Jerry

Lifayan,

<< i wrtie a isapi to get some data from form and save it to db ,but when i
use it ,it reports a "can not modify a read-only dataset" error , i had
check the permission of the data dir , and i foud the permission of the
directory is set to readonly but the data file is not readly ,and i found i
can not change the permission of the dir ,if i change the permission of
directory to read and write , after i applied ,it changed to readonly ,and i
found if i creat a new directroy on winxp ,the permission of the directory
is readonly by default and you can not change it ,i had tried it on my
desktop pc ,my note book ,and computer of my parteners . >>

DBISAM must obey the permissions set in the file system in terms of access
to the actual tables, therefore you must change the permissions for the
applicable folders in order for DBISAM to be able to access the tables in a
read/write fashion and not just read-only.  Under WindowsXP, you must be an
administrator or have the ability to change file/folder permissions in order
to do this.

--
Tim Young
Elevate Software
www.elevatesoft.com

hi
 thanks for your reply
I am always  login in my computer as a admininstratro ,and i found the reason yesterday ,since my iis is running under a guest so it can not write
the db file ,and now i changed the account of my iis service to administrator ,it works fine ,but it is dangers let iis runs under administrator account  
so how can i solve this problem? Can run dbisam at client/server mode solve it ?
 

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Lifayan,

<< i wrtie a isapi to get some data from form and save it to db ,but when i
use it ,it reports a "can not modify a read-only dataset" error , i had
check the permission of the data dir , and i foud the permission of the
directory is set to readonly but the data file is not readly ,and i found i
can not change the permission of the dir ,if i change the permission of
directory to read and write , after i applied ,it changed to readonly ,and i
found if i creat a new directroy on winxp ,the permission of the directory
is readonly by default and you can not change it ,i had tried it on my
desktop pc ,my note book ,and computer of my parteners . >>

DBISAM must obey the permissions set in the file system in terms of access
to the actual tables, therefore you must change the permissions for the
applicable folders in order for DBISAM to be able to access the tables in a
read/write fashion and not just read-only.  Under WindowsXP, you must be an
administrator or have the ability to change file/folder permissions in order
to do this.

--
Tim Young
Elevate Software
www.elevatesoft.com

Lifayan,

<< I am always  login in my computer as a admininstratro ,and i found the
reason yesterday ,since my iis is running under a guest so it can not write
the db file ,and now i changed the account of my iis service to
administrator ,it works fine ,but it is dangers let iis runs under
administrator account  so how can i solve this problem? Can run dbisam at
client/server mode solve it ? >>

You don't need to run the web users under an administrator account, you
simply need to run them under an account that has read/write access to the
database directory that you're using.  Refer to your IIS docs for
information on how to set the permissions for IIS users.

--
Tim Young
Elevate Software
www.elevatesoft.com