|
| 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
|
|
|
|
|
|
|
|
|
|