![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 10 of 13 total |
![]() |
Fri, Aug 8 2008 2:35 AM | Permanent 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 AM | Permanent Link |
Fernando Dias ![]() | 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 AM | Permanent 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 AM | Permanent 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 PM | Permanent Link |
Fernando Dias ![]() | 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 AM | Permanent 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 AM | Permanent Link |
Fernando Dias ![]() | 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 AM | Permanent 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 PM | Permanent Link |
Fernando Dias ![]() | 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 AM | Permanent 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 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |