| Author |
 Topic Search  Topic Options
|
zMaestro 
Senior Member
Joined: 11 May 2003
Location: Egypt
Status: Offline
Points: 1183
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Database Access Permissions
Posted: 06 August 2003 at 6:35am |
i have a database that contains a log files for more than one domain, I want these domains to update in it, I use the Local Path of the server to access the database, but I get this error:
Microsoft JET Database Engine error '80004005'
The Microsoft Jet database engine cannot open the file 'D:\SiteData\webppliance\conf\domains\mydomain\
Inetpub\wwwroot\dotASP\dotBase\myDB.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
How can I've this permission?,
n.b. there is no password for the database.
Edited by zMaestro
|
 |
zaboss
Senior Member
Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 August 2003 at 7:39am |
|
This error means that either the db is open - or the temp file that access creates everytime it opens the db wasn't deleted, or it is under a directory for which you do not have the right permissions (read only, blabla).
|
|
|
|
Mart
Senior Member
Joined: 30 November 2002
Status: Offline
Points: 2304
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 August 2003 at 9:32am |
If it is permissions look in the asp section on Web Wiz.
Mart.
|
|
zMaestro
Senior Member
Joined: 11 May 2003
Location: Egypt
Status: Offline
Points: 1183
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 August 2003 at 9:58am |
 zaboss wrote:
This error means that either the db is open - or the temp file that access creates everytime it opens the db wasn't deleted, or it is under a directory for which you do not have the right permissions (read only, blabla). |
neither the first nor the second... it is the third...
It functions normally when I access it from inside the domain itself, and I use the local path.
It doesn't function when I try yo access it from another domain, using local path too... Although the local path is the same.
I want to update the database through the local path from another domain either than that which it is in , i.e. login through www.Web Wiz.com and updates at www.Web Wiz.info using the local path, both domains are on the same server but under different directories.
sorry for bothering you... i am too confused...
|
|
zaboss
Senior Member
Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 August 2003 at 11:44am |
If this is the case, you simply can not do this. Chances there are that the sites are not even on the same machine so you can not actualy use the phisical path! Which is... phisical only realtive to the domain itself. What I mean is that you may have a d: drive on machine 12 and a d: drive on machine 34! Both of them having the same directory structure, but ... Get the picture?
So, if you want that option, you might want to consider SQL Server.
|
|
|
|
zMaestro
Senior Member
Joined: 11 May 2003
Location: Egypt
Status: Offline
Points: 1183
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 August 2003 at 1:04pm |
It is not Physical relative to the domain itself, it is physical relative to the Server.
Both Domains are located on the same Server on the same HDD, even using the same Control Panel.
and both can be accessed through the Physical path of the server but only from inside the domain.
'D:\SiteData\webppliance\conf\domains\my1stdomain\
Inetpub\wwwroot\dotASP\dotBase\myDB.mdb'
'D:\SiteData\webppliance\conf\domains\my2nddomain\
Inetpub\wwwroot\dotASP\dotBase\myDB.mdb'
if I accessed any of these from outside its domain, i.e. 1st domain from the 2nd, or 2nd from the 1st, I get permission denied... although I can access normally using the local path from inside the domain itself....
I'll try asking the server administrator about this.. may be he has a solution about this permission, and will be back to you.
Thanks for your help
|
|
zaboss
Senior Member
Joined: 20 August 2002
Location: Romania
Status: Offline
Points: 454
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 August 2003 at 11:56pm |
zMaestro wrote:
It is not Physical relative to the domain itself, it is physical relative to the Server.
Both Domains are located on the same Server on the same HDD, even using the same Control Panel.
|
Did you know that for a fact? I mean, I know for a fact that even all of my sites have the same phisical path (d:/webs/site1/db/mydb1.mdb, d:/webs/site2/db/mydb2.mdb and d:/webs/site3/db/mydb3.mdb) and I use the same control panel, 2 of them are indeed on the same machine, but the third is in another box. And as I said I doubt that you will be allowed to access them from another domain as this would mean that your db will be exposed(security reasons, think about it, that if it is allowed to do this anybody can access your db as they know the phisical path to it!).
|
|
|
|
zMaestro
Senior Member
Joined: 11 May 2003
Location: Egypt
Status: Offline
Points: 1183
|
Post Options
Thanks(0)
Quote Reply
Posted: 07 August 2003 at 3:16am |
yes, the last point in absolutely true...
zaboss wrote:
And as I said I doubt that you will be allowed to access them from another domain as this would mean that your db will be exposed(security reasons, think about it, that if it is allowed to do this anybody can access your db as they know the phisical path to it!). |
locally I'm using Windows XP and it is working normally... problems is just when I upload it to the server... I though that as it works locally.. it will work normally...
for the 1st point.. it is all in the same box... using the same Physical path (at least on my server), I know that if it is relative to the domain itself and not to the server.. it is named Virtual Path and not Physical Path.
Locally... I can include a file using the ../ but on the server it says that this is not allowed... I thought it is something like this....
|
|
