Permissions

Jun 14, 2011 at 4:24 PM

I have configured a site in IIS (Xp Pro SP3), dropped the files in and now i can see my pages etc. However, any attempt to write casues an error, beit by writing to a text file or the data folder, I get something like:

 

Caught .NET exception, source: tableauth err#= 111 line= 782 Cannot update the cursor USERS, since it is read-only.111 Cannot update the cursor USERS, since it is read

 

Is there something obvious I am missing here?

 

Thanks

Coordinator
Jun 14, 2011 at 7:38 PM

You probably need to give WRITE rights to the folders where you're trying to write or update files.  You can do this in IIS manager by going to the properties of that directory.  By default I think they're read-only.

Jun 14, 2011 at 8:48 PM

Hi Thanks for your reply. I have given the rights, now to all folders! Not sure what I'm missing here. It doesn't write to a text file, or to the data folder. But it clearly opens the DBF.

 

Strange.. It was in the program files folder but I've moved it from there into c:\mywebappname

 

Please help !

Coordinator
Jun 14, 2011 at 9:58 PM
Edited Jun 14, 2011 at 10:00 PM

So the directory with the files you want to write looks like this in iis manager??? (giving the directory Write in addition to Read is ALL you should have to do):

Jun 15, 2011 at 12:58 PM

Yes, thanks for your reply.

 

I have now even set read/write on all subfolders, without any luck. As I mentioned, it used to reside in PF, but its now in the root, undert its app name.

 

I'm not sure what could possibly be wrong here?

 

here is the code (although I can't see this as a problem. I was using it under the last version of aVFP)

Set Exact On
Locate For Alltrim(Lower(username)) = Alltrim(Lower(lcName))
If Found()
    If Upper(Alltrim(m.lcPassWord)) == Upper(Alltrim(Users.Password))
        Release GnUserID,GnName,GnFirstName,GnLastName

        If Users.Firstlogin={}
            Replace Users.Firstlogin With Datetime()
        Endif
        writejournal("Help")
        Replace Users.Lastlogin With Datetime()

 

How do I post a screenshot here?

 

 

Coordinator
Jun 15, 2011 at 6:14 PM

1.) Are you signed in as Administrator when you make these changes??

2.) Are the changes being saved (go back to IIS manager and check that they are there)??

3.) It's simple to just copy the install to another directory, create a new virtual directory/app over it (in IIS Manager), and give the Data directory within it Write rights (by right clicking it in IIS Manager).  You are using IIS Manager to setup, right??  Can the Demo app update tables correctly???  

These instructions have worked for everyone so if you're sticking to them I don't know what could be wrong.

Images can be inserted here just by pointing an img http link to the server you copied your image to like:

<img src="http://download.codeplex.com/Project/Download/FileDownload.aspx?ProjectName=activevfp&amp;DownloadId=249776" alt="" />

Jun 16, 2011 at 10:22 AM

1)  Yes

2) Yes, they are

3) Yes!

Your right, they do work for everybody. I failed to set permissions on the files / folders in Windows. I set this and hey presto I'm up and running.

 

Thanks!

(I posted this in case anybody else managed to get stuck on this!)