|
 |
asp_databases thread: Sorry folks .. its another 80004005
Message #1 by "Bleddyn Davies" <bbd75800@g...> on Wed, 22 Nov 2000 17:50:11 -0000
|
|
can anyone tell me why my application works when I connect to a database
on my c: drive as follows:
appDBpath = "C:\ES_Dev\ESComponents1.mdb"
set mcConn= server.createobject("ADODB.connection")
strConnStr="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & appDBPath
mcConn.open strConnStr
but falls over with the good ol' 80004005 error when I specify a database
on a share as follows :
appDBpath
"\\UKZ513\BBD75800$\BBD75800\Eng_Stores_DB\ESComponents.mdb"
set mcConn= server.createobject("ADODB.connection")
strConnStr="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & appDBPath
mcConn.open strConnStr
The resultant error is :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot open the file '(unknown)'. It is already opened exclusively
by another user, or you need permission to view its data.
/WEBPUB/global.asa, line 15 (line 15 is the mcConn.open strConnStr line).
I'm running personal web server on a windows NT box.
Help !!!!!
Message #2 by ckoski@w... on Wed, 22 Nov 2000 14:26:33 -0500
|
|
your share needs the same permissions that your website has... give your
mdb file the permissions for the IUSR_manchine account...
----- Original Message -----
From: "Bleddyn Davies" <bbd75800@g...>
To: "ASP Databases" <asp_databases@p...>
Sent: Wednesday, November 22, 2000 12:50 PM
Subject: [asp_databases] Sorry folks .. its another 80004005
> can anyone tell me why my application works when I connect to a database
> on my c: drive as follows:
>
> appDBpath = "C:\ES_Dev\ESComponents1.mdb"
> set mcConn= server.createobject("ADODB.connection")
> strConnStr="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & appDBPath
> mcConn.open strConnStr
>
> but falls over with the good ol' 80004005 error when I specify a database
> on a share as follows :
>
> appDBpath
> "\\UKZ513\BBD75800$\BBD75800\Eng_Stores_DB\ESComponents.mdb"
> set mcConn= server.createobject("ADODB.connection")
> strConnStr="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & appDBPath
> mcConn.open strConnStr
>
> The resultant error is :
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine cannot open the file '(unknown)'. It is already opened exclusively
> by another user, or you need permission to view its data.
>
> /WEBPUB/global.asa, line 15 (line 15 is the mcConn.open strConnStr line).
>
> I'm running personal web server on a windows NT box.
>
> Help !!!!!
>
>
>
>
Message #3 by "Matthew Lohr" <mlohr@t...> on Wed, 22 Nov 2000 14:55:33 -0500
|
|
It seems that although you have right to this share that your
iuser_machinename (where machine name is that of the server the web site
(asp script) is actually on) account does not. Make sure this user has
rights
-----Original Message-----
From: Bleddyn Davies [mailto:bbd75800@g...]
Sent: Wednesday, November 22, 2000 12:50 PM
To: ASP Databases
Subject: [asp_databases] Sorry folks .. its another 80004005
can anyone tell me why my application works when I connect to a database
on my c: drive as follows:
appDBpath = "C:\ES_Dev\ESComponents1.mdb"
set mcConn= server.createobject("ADODB.connection")
strConnStr="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & appDBPath
mcConn.open strConnStr
but falls over with the good ol' 80004005 error when I specify a database
on a share as follows :
appDBpath
"\\UKZ513\BBD75800$\BBD75800\Eng_Stores_DB\ESComponents.mdb"
set mcConn= server.createobject("ADODB.connection")
strConnStr="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & appDBPath
mcConn.open strConnStr
The resultant error is :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot open the file '(unknown)'. It is already opened exclusively
by another user, or you need permission to view its data.
/WEBPUB/global.asa, line 15 (line 15 is the mcConn.open strConnStr line).
I'm running personal web server on a windows NT box.
Help !!!!!
Message #4 by "Ken Schaefer" <ken@a...> on Thu, 23 Nov 2000 09:51:37 +1100
|
|
The IUSR_<machinename> account on the webserver needs to have the
appropriate permissions to the share, folder and files on the remote
machine. It seems, at the moment, that it does not have permissions to
either the Access file, or to create the .ldb lockfile on the remote share.
Cheers
Ken
----- Original Message -----
From: "Bleddyn Davies" <bbd75800@g...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, November 23, 2000 4:50 AM
Subject: [asp_databases] Sorry folks .. its another 80004005
> can anyone tell me why my application works when I connect to a database
> on my c: drive as follows:
>
> appDBpath = "C:\ES_Dev\ESComponents1.mdb"
> set mcConn= server.createobject("ADODB.connection")
> strConnStr="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & appDBPath
> mcConn.open strConnStr
>
> but falls over with the good ol' 80004005 error when I specify a database
> on a share as follows :
>
> appDBpath
> "\\UKZ513\BBD75800$\BBD75800\Eng_Stores_DB\ESComponents.mdb"
> set mcConn= server.createobject("ADODB.connection")
> strConnStr="Driver={Microsoft Access Driver (*.mdb)};DBQ=" & appDBPath
> mcConn.open strConnStr
>
> The resultant error is :
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
> engine cannot open the file '(unknown)'. It is already opened exclusively
> by another user, or you need permission to view its data.
>
> /WEBPUB/global.asa, line 15 (line 15 is the mcConn.open strConnStr line).
>
> I'm running personal web server on a windows NT box.
>
> Help !!!!!
Message #5 by "Bleddyn Davies" <bbd75800@g...> on Thu, 23 Nov 2000 11:42:38 -0000
|
|
Thanks Ken, again a much appreciated response.
is the IUSR user configurable in Personal Web Server - this is currently
what I'm running the application on as it's not yet been migrated to a
production environment.
If so, how can I access it ?
Thanks again .. Bleddyn
Message #6 by "Ken Schaefer" <ken@a...> on Fri, 24 Nov 2000 11:48:43 +1100
|
|
Ay, now you're in trouble...
If the webserver is running on your local machine which is Win95/98, and the
database is residing on another machine (WinNT) then you'll probably have a
little problem. I'm not sure what context PWS runs in on a Win95/98
machine - my guess is the local logged on user.
Try creating an account on the WinNT machine that has the same
username/password that you are using to log on to your local Win95/98
machine, and give that user permissions to the share, folder and file on the
WinNT machine.
Make sure you are logging on to your Win95/98 machine using the Client for
Microsoft Networks (not the generic Windows Logon) to make sure you are
initialising the relevant protocol stacks. (you can check by right-clicking
Network neighbourhood and choosing Properties).
That all said, I think your best bet is to either move the database onto the
local machine, or move your webpages to the remote machine (or at least to
another WinNT machine)
Cheer
sKen
----- Original Message -----
From: "Bleddyn Davies" <bbd75800@g...>
To: "ASP Databases" <asp_databases@p...>
Sent: Thursday, November 23, 2000 10:42 PM
Subject: [asp_databases] Re: Sorry folks .. its another 80004005
> Thanks Ken, again a much appreciated response.
>
> is the IUSR user configurable in Personal Web Server - this is currently
> what I'm running the application on as it's not yet been migrated to a
> production environment.
>
> If so, how can I access it ?
>
> Thanks again .. Bleddyn
|
|
|
View Cart
