Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 10 of 13 total
Thread 11013 LAN network
Fri, Aug 8 2008 2:35 AMPermanent Link

Phil Read
Hi Tim & Team,

I have an application running on a clients LAN network, the database is
on the server and the connected PC's are using a UNC path to point to
the servers data folder. The provateDIR is set to a temp folder.

Now this is the puzzling part, they get a 11013 error when they use the
program, so I log in using windows remote desktop which uses an account
called remote btw. And when I run the program it works perfectly. But
then they use their owner account and run the software they get 11013.

I have looked at permissions, they are both ADMIN accounts with full
access and permissions. I also checked the antivirus software settings
and tried everything previously suggested.

Has anyone else seen this before where 1 admin account works fine and
another causes 11013 errors?

Thanks,

Phil.
Fri, Aug 8 2008 7:53 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Phil,

What about the PrivateDir - do they have the required permissions in this
directory?
Another possibility is if the application is trying to open a table
exclusively and the table is already open.
Can you say what is the application doing when they get the error?

--
Fernando Dias
[Team Elevate]

Sat, Aug 9 2008 12:41 AMPermanent Link

Phil Read
Hi Fernando,

Nothing is opened exclusively. We have tried several privateDIR and even
tested creating a manual .dat text file in the private directory and the
database UNC path to the server where the data is stored and no problems
at all.

It seems like it has to be a protection / access problem, since running
the program on the same PC but under different USERS causes the problem.

It appears to cause an 11013 error anytime a query is executed.

I hope that helps,

Thanks


Fernando Dias wrote:
> Phil,
>
> What about the PrivateDir - do they have the required permissions in this
> directory?
> Another possibility is if the application is trying to open a table
> exclusively and the table is already open.
> Can you say what is the application doing when they get the error?
>
Sat, Aug 9 2008 12:43 AMPermanent Link

Phil Read
Just in addition... They had this problem for a few days after
isntalling it, then the phoned to say it was all working which it did
for several weeks then it stopped working. I have to think it can't be
the software but something fishy on the their network.
Sat, Aug 9 2008 1:04 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Phil,

I forgot to ask - what version of DBISAM are you using?

> for several weeks then it stopped working. I have to think it can't be
> the software but something fishy on the their network.

Or maybe they changed some user permissions...
If it happens when the app executes queries, then I think it may have to
do with permissions on PrivateDir because of the temporary tables
created when DBISAM executes canned queries. Is PrivateDir set to a
local directory in each computer? You said both users are
Administrators, but are they both Administrators in ALL computers?
Also, the fact that they are Administrators doesn't imply they have all
permissions in all directories...

--
Fernando Dias
[Team Elevate]
Sun, Aug 10 2008 12:25 AMPermanent Link

Phil Read
Hi Fernando,

I'm using DBISAM 4.26 build 3 and the PC in question has it's privateDir
set to it's local C:\Windows\Temp and we have also tried the local
program folder where the EXE is located. If I try creating a manual file
using notepad and name it to say someting.dat then I'm not restricted or
blocked in either of theses locations.


Fernando Dias wrote:
> Phil,
>
> I forgot to ask - what version of DBISAM are you using?
>
>> for several weeks then it stopped working. I have to think it can't be
>> the software but something fishy on the their network.
>
> Or maybe they changed some user permissions...
> If it happens when the app executes queries, then I think it may have to
> do with permissions on PrivateDir because of the temporary tables
> created when DBISAM executes canned queries. Is PrivateDir set to a
> local directory in each computer? You said both users are
> Administrators, but are they both Administrators in ALL computers?
> Also, the fact that they are Administrators doesn't imply they have all
> permissions in all directories...
>
Sun, Aug 10 2008 7:59 AMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Phil,

If you are sure it's not a permissions issue and that nothing is being
open exclusively, then the only other cause I can think of for this
problem is Anti-Virus software, but you said that you verified that
also, so I'm sorry but I don't know what else to suggest.

I can only tell you what I normally do in my application to minimize the
number of occurrences for this kind of problem:

1.I always use Client/Server for network installations, so I never have
to deal with users permissions in the server because only DBISAM server
need access the database folders.

2.Whenever possible, temporary tables are created in memory. When that's
not possible, a temporary folder is created inside the "Temp" folder in
the user profile. This completely eliminates the possibility of
permissions problems.


--
Fernando Dias
[Team Elevate]
Mon, Aug 11 2008 1:30 AMPermanent Link

Phil Read
Hi Fernando,

The thing that screams permission or protection issue to me, is the fact
2 different login accounts on the same PC and one causes the 11013 error
and the other allows the software to work perfectly. So surely it has to
be something with permission or protection software blocking it.
Mon, Aug 11 2008 7:38 PMPermanent Link

Fernando Dias

Team Elevate Team Elevate

Phil,

What is the exact error message you are getting?
IOW, what is (or are) the name of the table in the error message?
Are they names of tables belonging to the database?

Just another "shot in the dark":
Are you using "SELECT INTO..." in your queries, and if yes:
1. Is there the possibility that sometimes the users are executing more
than one instance of the application, causing those queries to use the
same temporary table?
2. Are you using a path for the "INTO" table that can be problematic in
terms of write permissions?


--
Fernando Dias
[Team Elevate]
Sat, Aug 30 2008 4:34 AMPermanent Link

"C. Sunguray [Turkey]"
I have same problem. I'm connecting client/server. On the server settings
PrivateDir is set up to 'c:\temp'. Only one PC get 11013 error.
Full message is :
DBISAM Engine Errror # 11013 Access denied to table or backupfile 'query
(45805)'

I'm using DBIsam 4.22, Delphi 7 Ent. Windows XP Pro (Client), Windows Server
2003 (Server)



"Phil Read" <phil@vizualweb.com> wrote in message
news:23C22BFD-2F61-4121-A812-36F9176F0164@news.elevatesoft.com...
> Hi Tim & Team,
>
> I have an application running on a clients LAN network, the database is on
> the server and the connected PC's are using a UNC path to point to the
> servers data folder. The provateDIR is set to a temp folder.
>
> Now this is the puzzling part, they get a 11013 error when they use the
> program, so I log in using windows remote desktop which uses an account
> called remote btw. And when I run the program it works perfectly. But then
> they use their owner account and run the software they get 11013.
>
> I have looked at permissions, they are both ADMIN accounts with full
> access and permissions. I also checked the antivirus software settings and
> tried everything previously suggested.
>
> Has anyone else seen this before where 1 admin account works fine and
> another causes 11013 errors?
>
> Thanks,
>
> Phil.

Page 1 of 2Next Page »
Jump to Page:  1 2
Image