Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Mon Dec 09, 2019 10:00 am
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 4 posts ] 
Author Message
 Post subject: Repairing (corrupted?) file permissions - Windows 7
PostPosted: Wed Nov 17, 2010 12:10 pm 
Offline

Joined: Wed May 20, 2009 4:43 pm
Posts: 958
I have a file whose file permissions mysteriously have changed on me. The file is a RealSQL database file, and I started getting a 'Read-only' database error in one instance when the program was installed on a user's computer (it had just been installed and run, then after quitting the application and opening it again seconds later, the problem occurred. No other users have mentioned the problem). The problem recurred today (in both instances, it happened on a Windows 7 computer, although I can’t be certain that it is limited to that OS), and I tracked it down to the current user's permissions being 'snarfed' for the file. It looks like the settings for the current user have been deleted/corrupted - here are 2 screen captures of the permissions settings both before and after the problem occurred

Original file:
Image
Snarfed file:
Image

After much googling and trying out different things, I had success using the following shell command to repair the file:
icacls "C:ProgramData\DataFile.rsd" /reset


This looks like it may have fixed the problem, but I stupidly forgot to make a copy of the original snarfed file so I could go back and do any further tests on it. :x

Can anyone shed any light on what might have caused this problem, or if this will be a reliable fix to run in my application in case the problem occurs on a user's machine?

I originally posted this under the 'Database' topics http://forums.realsoftware.com/viewtopic.php?f=3&t=35936 when I first encountered this problem, but I decided to move this discussion to the Windows forum since it isn't directly related to the database.

_________________
RB 2009r4 Windows XP


Top
 Profile  
Reply with quote  
 Post subject: Re: Repairing (corrupted?) file permissions - Windows 7
PostPosted: Thu Apr 19, 2012 2:23 am 
Offline

Joined: Tue Dec 27, 2011 8:54 am
Posts: 139
Location: India
Hi markwalsh,

I am also facing the same problems with the inbuilt real sql databse.

Did you fina any solutions for this ?


Thansk,
prakash

_________________
PK Pothal
Software Developer in REAL STUDIO 2011r4.3, ASP.NET, VB.NET, C# AND SQL SERVER 2005/08
OS:WINDOWS N MAC


Top
 Profile  
Reply with quote  
 Post subject: Re: Repairing (corrupted?) file permissions - Windows 7
PostPosted: Thu Apr 19, 2012 8:47 am 
Offline

Joined: Wed May 20, 2009 4:43 pm
Posts: 958
prakashp wrote:
Hi markwalsh,

I am also facing the same problems with the inbuilt real sql databse.

Did you fina any solutions for this ?


Thansk,
prakash

Sorry, the project this happened with for me was killed by the client, so I haven't had any reoccurences. All of the other database work I have been doing with RS since then has been with a MySql server, so this issue doesn't apply.

I would be interested in knowing if the shell command works for you if you have the same issue. Make a backup of the database file before you try it so you can run it several times to hopefully reverify it works.

_________________
RB 2009r4 Windows XP


Top
 Profile  
Reply with quote  
 Post subject: Re: Repairing (corrupted?) file permissions - Windows 7
PostPosted: Thu Apr 19, 2012 2:27 pm 
Offline

Joined: Tue Dec 27, 2011 8:54 am
Posts: 139
Location: India
Hi markwalsh,

Thanks for your time. I fixed that issue.


Thanks,
Prakash

_________________
PK Pothal
Software Developer in REAL STUDIO 2011r4.3, ASP.NET, VB.NET, C# AND SQL SERVER 2005/08
OS:WINDOWS N MAC


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group