|
 |
access_asp thread: Microsoft JET Database Engine error '80004005' already opened or permission needed?
Message #1 by "Trevor Mosher" <lil_huge@h...> on Tue, 30 Oct 2001 19:05:17
|
|
Microsoft JET Database Engine error '80004005'
The Microsoft Jet database engine cannot open the
file '\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.
Okay now here is my connection string which is contained in the
onstart_session of the global.asa
Session ("strConn") = "Provider = Microsoft.Jet.OLEDB.4.0; Data
Source=\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb"
and this is in the asp page.
Set connDB = Server.CreateObject ("ADODB.Connection")
connDB.Open session("strConn")
The database is on a G: drive which is a commom drive for my department.
THere are different G drives it is what they call the common drive for
each department. the ldoa307a\sek is the actual machine path. now this
is not on the server machine though, so I am tryin to figure out how to
connect to this access database. It must stay on the G: drive because it
links to excel sheets that cannot be moved.
if there is any suggestion, help is appreciated
Message #2 by "Frank Kech" <fkech@s...> on Tue, 30 Oct 2001 14:06:39 -0600
|
|
Change the web application's authentication to basic. It's probably because
your server is trying to authenticate to your remote drive but unfortunately
browsers do not supply a password that the server can use for Challenge and
Response authentication. Good luck.
-----Original Message-----
From: Trevor Mosher [mailto:lil_huge@h...]
Sent: Tuesday, October 30, 2001 7:05 PM
To: Access ASP
Subject: [access_asp] Microsoft JET Database Engine error '80004005'
already opened or permission needed?
Microsoft JET Database Engine error '80004005'
The Microsoft Jet database engine cannot open the
file '\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.
Okay now here is my connection string which is contained in the
onstart_session of the global.asa
Session ("strConn") = "Provider = Microsoft.Jet.OLEDB.4.0; Data
Source=\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb"
and this is in the asp page.
Set connDB = Server.CreateObject ("ADODB.Connection")
connDB.Open session("strConn")
The database is on a G: drive which is a commom drive for my department.
THere are different G drives it is what they call the common drive for
each department. the ldoa307a\sek is the actual machine path. now this
is not on the server machine though, so I am tryin to figure out how to
connect to this access database. It must stay on the G: drive because it
links to excel sheets that cannot be moved.
if there is any suggestion, help is appreciated
Message #3 by "Trevor Mosher" <lil_huge@h...> on Tue, 30 Oct 2001 20:35:37
|
|
Thanks I'll take that up with OI department, unfortunetly got other
departments that i have to go through to do anything with the servers or
permissions. Hope it works,
> Change the web application's authentication to basic. It's probably
because
> your server is trying to authenticate to your remote drive but
unfortunately
> browsers do not supply a password that the server can use for Challenge
and
> Response authentication. Good luck.
>
>
>
> -----Original Message-----
> From: Trevor Mosher [mailto:lil_huge@h...]
> Sent: Tuesday, October 30, 2001 7:05 PM
> To: Access ASP
> Subject: [access_asp] Microsoft JET Database Engine error '80004005'
> already opened or permission needed?
>
>
> Microsoft JET Database Engine error '80004005'
>
> The Microsoft Jet database engine cannot open the
> file '\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb'. It is already opened
> exclusively by another user, or you need permission to view its data.
>
>
> Okay now here is my connection string which is contained in the
> onstart_session of the global.asa
>
> Session ("strConn") = "Provider = Microsoft.Jet.OLEDB.4.0; Data
> Source=\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb"
> and this is in the asp page.
> Set connDB = Server.CreateObject ("ADODB.Connection")
> connDB.Open session("strConn")
>
> The database is on a G: drive which is a commom drive for my department.
> THere are different G drives it is what they call the common drive for
> each department. the ldoa307a\sek is the actual machine path. now this
> is not on the server machine though, so I am tryin to figure out how to
> connect to this access database. It must stay on the G: drive because it
> links to excel sheets that cannot be moved.
>
> if there is any suggestion, help is appreciated
>
Message #4 by "Ken Schaefer" <ken@a...> on Thu, 1 Nov 2001 13:26:49 +1100
|
|
Create an account on the DB server that has the same username and password
as the account being used for anonymous access on the webserer. Assign this
account permissions to the share and file/folder.
You can't directly assign permissions to the anonymous internet user to the
remote share because the IUSR_<webserver> account is local to the webserver.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Trevor Mosher" <lil_huge@h...>
To: "Access ASP" <access_asp@p...>
Sent: Tuesday, October 30, 2001 7:05 PM
Subject: [access_asp] Microsoft JET Database Engine error '80004005' already
opened or permission needed?
: Microsoft JET Database Engine error '80004005'
:
: The Microsoft Jet database engine cannot open the
: file '\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb'. It is already opened
: exclusively by another user, or you need permission to view its data.
:
:
: Okay now here is my connection string which is contained in the
: onstart_session of the global.asa
:
: Session ("strConn") = "Provider = Microsoft.Jet.OLEDB.4.0; Data
: Source=\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb"
: and this is in the asp page.
: Set connDB = Server.CreateObject ("ADODB.Connection")
: connDB.Open session("strConn")
:
: The database is on a G: drive which is a commom drive for my department.
: THere are different G drives it is what they call the common drive for
: each department. the ldoa307a\sek is the actual machine path. now this
: is not on the server machine though, so I am tryin to figure out how to
: connect to this access database. It must stay on the G: drive because it
: links to excel sheets that cannot be moved.
Message #5 by patrick.frenette@s... on Wed, 31 Oct 2001 12:49:16
|
|
Hi there,
Before going trough with permissions try closing your database before
using on the web...
If it is opened by an admin person, you can't work on it as a iuser
> Microsoft JET Database Engine error '80004005'
>
> The Microsoft Jet database engine cannot open the
> file '\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb'. It is already opened
> exclusively by another user, or you need permission to view its data.
>
>
> Okay now here is my connection string which is contained in the
> onstart_session of the global.asa
>
> Session ("strConn") = "Provider = Microsoft.Jet.OLEDB.4.0; Data
> Source=\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb"
> and this is in the asp page.
> Set connDB = Server.CreateObject ("ADODB.Connection")
> connDB.Open session("strConn")
>
> The database is on a G: drive which is a commom drive for my
department.
> THere are different G drives it is what they call the common drive for
> each department. the ldoa307a\sek is the actual machine path. now this
> is not on the server machine though, so I am tryin to figure out how to
> connect to this access database. It must stay on the G: drive because
it
> links to excel sheets that cannot be moved.
>
> if there is any suggestion, help is appreciated
Message #6 by "Trevor Mosher" <lil_huge@h...> on Wed, 31 Oct 2001 19:43:24
|
|
Thank you for your help,
Unfortunetly still no go. what we have now is a problem between the
database and the excel sheets that it is linked to. Everything is now on
the webserver itself. the Access DB and even the Excel sheets in the same
folder. the links have been remade using the \\ldo\ type path. The error
though remains the same this time it reads the Database but the error now
comes at the level of the spreadsheets says
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database
engine cannot open the
file '\\ldoa311a\inetpub\wwwroot\SEK\CurrentFY\TestExcel.xls'. It is
already opened exclusively by another user, or you need permission to view
its data.
here is my command code maybe something wrong with it
Set connDB = Server.CreateObject ("ADODB.Connection")
connDB.Open Application("ScoreCardDB_ConnectionString")
set cmdBuyer = server.CreateObject("ADODB.Command")
cmdBuyer.ActiveConnection = Application
("ScoreCardDB_ConnectionString")
cmdBuyer.CommandType = 4 ' Stored Procedure Type
cmdBuyer.CommandText = "TestExcelQ"
' cmdBuyer.Parameters.Refresh
set recBuyer = server.createObject("ADODB.RECORDSET")
set recBuyer = cmdBuyer.Execute
This is a major delay and help is greatly appreciated
> Create an account on the DB server that has the same username and
password
> as the account being used for anonymous access on the webserer. Assign
this
> account permissions to the share and file/folder.
>
> You can't directly assign permissions to the anonymous internet user to
the
> remote share because the IUSR_<webserver> account is local to the
webserver.
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> ----- Original Message -----
> From: "Trevor Mosher" <lil_huge@h...>
> To: "Access ASP" <access_asp@p...>
> Sent: Tuesday, October 30, 2001 7:05 PM
> Subject: [access_asp] Microsoft JET Database Engine error '80004005'
already
> opened or permission needed?
>
>
> : Microsoft JET Database Engine error '80004005'
> :
> : The Microsoft Jet database engine cannot open the
> : file '\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb'. It is already opened
> : exclusively by another user, or you need permission to view its data.
> :
> :
> : Okay now here is my connection string which is contained in the
> : onstart_session of the global.asa
> :
> : Session ("strConn") = "Provider = Microsoft.Jet.OLEDB.4.0; Data
> : Source=\\ldoa307a\sek\ScoreCardDB\ScoreCardDB.mdb"
> : and this is in the asp page.
> : Set connDB = Server.CreateObject ("ADODB.Connection")
> : connDB.Open session("strConn")
> :
> : The database is on a G: drive which is a commom drive for my
department.
> : THere are different G drives it is what they call the common drive for
> : each department. the ldoa307a\sek is the actual machine path. now
this
> : is not on the server machine though, so I am tryin to figure out how to
> : connect to this access database. It must stay on the G: drive because
it
> : links to excel sheets that cannot be moved.
>
>
|
|
|
View Cart
