Groups > dBase > dBase deployment > Re: permission denied .copy() temporary table




permission denied .copy() temporary table

permission denied .copy() temporary table
Mon, 28 Jan 2008 16:20:34 -050
Good day,
I have a client with an application installed on a Windows NT type server.
Clients use Remote Desktop to log into the terminal server. The application has
been executing for severl years without problems.  

Lately the program is failing, with a "Permission Denied" error. I
catch the exception and put the messange and line number to a log file, so I can
see that this is happening when a temporary table is being overwrtiite
u.destination = "qdtemp.dbf"
u.copy() // this overwrites

it also 
copy table "dd1.dbf" to "cudtemp.dbf" 
fails with the same error.

This must be something with the server, since this code has executed thousands
of times over the last 3 years with no problems.
Anything to suggest to the IT department?

Post Reply
Re: permission denied .copy() temporary table
Mon, 28 Jan 2008 23:25:10 -050
In article <SxdieOfYIHA.1532@news-server>, adevita@clinsaver.com says...
> Good day,
> I have a client with an application installed on a Windows NT type server.
Clients use Remote Desktop to log into the terminal server. The application has
been executing for severl years without problems.  
> 
> Lately the program is failing, with a "Permission Denied" error.
I catch the exception and put the messange and line number to a log file, so I
can see that this is happening when a temporary table is being overwrtiite
> u.destination = "qdtemp.dbf"
> u.copy() // this overwrites
> 
> it also 
> copy table "dd1.dbf" to "cudtemp.dbf" 
> fails with the same error.
> 
> This must be something with the server, since this code has executed
thousands of times over the last 3 years with no problems.
> Anything to suggest to the IT department?
> 
> Adam
> 

Adam,

To me it sounds like the users' access rights have somehow been reduced. 
They don't see to have the ability to create and/or delete files. It 
could be their overall rights or just the rights to folder where you 
data is stored. Perhaps they have recently changed the default profile 
for Remote Desktop logins so that it is more restrictive? (Just 
guessing)

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
Post Reply
Re: permission denied .copy() temporary table
Tue, 29 Jan 2008 09:30:22 -050
Good day,

We called IT to log on to the server itself as Administrator and execute the
code. Still the same story. The really odd thing is that it doesn't fail on the
first copy file into the directory.

Adam
Geoff Wass [dBVIPS] Wrote:

> In article <SxdieOfYIHA.1532@news-server>, adevita@clinsaver.com
says...
> > Good day,
> > I have a client with an application installed on a Windows NT type
server. Clients use Remote Desktop to log into the terminal server. The
application has been executing for severl years without problems.  
> > 
> > Lately the program is failing, with a "Permission Denied"
error. I catch the exception and put the messange and line number to a log file,
so I can see that this is happening when a temporary table is being overwrtiite
> > u.destination = "qdtemp.dbf"
> > u.copy() // this overwrites
> > 
> > it also 
> > copy table "dd1.dbf" to "cudtemp.dbf" 
> > fails with the same error.
> > 
> > This must be something with the server, since this code has executed
thousands of times over the last 3 years with no problems.
> > Anything to suggest to the IT department?
> > 
> > Adam
> > 
> 
> Adam,
> 
> To me it sounds like the users' access rights have somehow been reduced. 
> They don't see to have the ability to create and/or delete files. It 
> could be their overall rights or just the rights to folder where you 
> data is stored. Perhaps they have recently changed the default profile 
> for Remote Desktop logins so that it is more restrictive? (Just 
> guessing)
> 
> -- 
> Geoff Wass [dBVIPS]
> Montréal, Québec, Canada
> 
> .|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
> .|.|.| ---------------------------------------------------------- |.|.|.
> .|.|.|             IT Consultant http://Geoff_Wass.com            |.|.|.
Post Reply
Re: permission denied .copy() temporary table
Tue, 29 Jan 2008 23:25:15 -080
When you say Windows NT "type" server, what do you mean?
Is this a Windows NT server or something like it?
Assuming it is a Win NT Server you consider the following:
The best thing to do in this case is to open a DOS window change directory 
to that folder and do some manual overwriting, creating and deleting of 
files.

Isn't is possible that someone has changed the permissions on the folder?
Overwriting requires delete rights (i think?).

Double check to be sure that there is not file opened with the same name as 
the destination file name.

Greg Hill


"Adam DeVita" <adevita@clinsaver.com> wrote in message 
news:SxdieOfYIHA.1532@news-server...
> Good day,
> I have a client with an application installed on a Windows NT type server.

> Clients use Remote Desktop to log into the terminal server. The 
> application has been executing for severl years without problems.
>
> Lately the program is failing, with a "Permission Denied" error.
I catch 
> the exception and put the messange and line number to a log file, so I can

> see that this is happening when a temporary table is being overwrtiite
> u.destination = "qdtemp.dbf"
> u.copy() // this overwrites
>
> it also
> copy table "dd1.dbf" to "cudtemp.dbf"
> fails with the same error.
>
> This must be something with the server, since this code has executed 
> thousands of times over the last 3 years with no problems.
> Anything to suggest to the IT department?
>
> Adam 

Post Reply
Re: permission denied .copy() temporary table
Tue, 29 Jan 2008 23:25:22 -050
In article <0ud56NoYIHA.1240@news-server>, adevita@clinsaver.com says...
> Good day,
> 
> We called IT to log on to the server itself as Administrator and execute
the code. Still the same story. The really odd thing is that it doesn't fail on
the first copy file into the directory.
> 
> Adam


Adam,

I wonder if it is a manifestation of the DEP problem. DEP is described 
below and the second link describes how to deal with it:

http://www.goldenstag.net/dbase/  (scroll down)

http://howto.landisc.com/dep.html

-- 
Geoff Wass [dBVIPS]
Montréal, Québec, Canada

.|.|.|        dBASE info at http://geocities.com/geoff_wass       |.|.|.
.|.|.| ---------------------------------------------------------- |.|.|.
Post Reply
<< Previous 1 2 Next >>
( Page 1 of 2 )
about | contact