|
 |
asp_databases thread: Converting DB to current vesion of Access breaks connection.
Message #1 by knorsen@y... on Thu, 28 Jun 2001 17:06:39
|
|
Any thoughts on why when a DB is in the original format of Access 97 the
connection works great, but produces the error below when the DB is
converted to the latest MS Office Version?
The error and the code are posted below:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'C:\DB_test.mdb'.
It is already opened exclusively by another user, or you need permission
to view its data.
<%
set oRS=server.createobject("ADODB.recordset")
oRS.open "Select * from People", "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\DB_test.mdb;"
oRS.movefirst
response.write "<b>" & oRS("PeopleNameLast") & "</b>"
%>
Message #2 by "Peter Foti (PeterF)" <PeterF@S...> on Thu, 28 Jun 2001 12:15:20 -0400
|
|
Perhaps try getting the latest MDAC (2.6) and Jet drivers for the
server. You can get them from Microsoft's web site.
-Peter
> -----Original Message-----
> From: knorsen@y... [mailto:knorsen@y...]
> Sent: Thursday, June 28, 2001 5:07 PM
> To: ASP Databases
> Subject: [asp_databases] Converting DB to current vesion of Access
> breaks connection.
>
>
> Any thoughts on why when a DB is in the original format of
> Access 97 the
> connection works great, but produces the error below when the DB is
> converted to the latest MS Office Version?
> The error and the code are posted below:
>
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> The Microsoft Jet database engine cannot open the file
> 'C:\DB_test.mdb'.
> It is already opened exclusively by another user, or you need
> permission
> to view its data.
>
>
> <%
> set oRS=3Dserver.createobject("ADODB.recordset")
> oRS.open "Select * from People",
> "Provider=3DMicrosoft.Jet.OLEDB.4.0; Data
> Source=3DC:\DB_test.mdb;"
> oRS.movefirst
> response.write "<b>" & oRS("PeopleNameLast") & "</b>"
> %>
Message #3 by "Tomm Matthis" <matthis@b...> on Thu, 28 Jun 2001 13:53:58 -0400
|
|
Don't know why it would work in one version and not the other, but
normall you get this if the IUSR_xxx account doesn't have create/delete
access to the directory/folder where the .MDB file resides. IUSR_xxx
needs to be able to create/delete the .LDB (lock) file.
-- Tomm
> -----Original Message-----
> From: knorsen@y... [mailto:knorsen@y...]
> Sent: Thursday, June 28, 2001 5:07 PM
> To: ASP Databases
> Subject: [asp_databases] Converting DB to current vesion of Access
> breaks connection.
>
>
> Any thoughts on why when a DB is in the original format of Access 97
the
> connection works great, but produces the error below when the DB is
> converted to the latest MS Office Version?
> The error and the code are posted below:
>
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> The Microsoft Jet database engine cannot open the file
'C:\DB_test.mdb'.
> It is already opened exclusively by another user, or you need
permission
> to view its data.
>
>
> <%
> set oRS=3Dserver.createobject("ADODB.recordset")
> oRS.open "Select * from People",
> "Provider=3DMicrosoft.Jet.OLEDB.4.0; Data
> Source=3DC:\DB_test.mdb;"
> oRS.movefirst
> response.write "<b>" & oRS("PeopleNameLast") & "</b>"
> %>
Message #4 by "Drew, Ron" <RDrew@B...> on Thu, 28 Jun 2001 13:58:43 -0400
|
|
I agree
-----Original Message-----
From: Tomm Matthis [mailto:matthis@b...]
Sent: Thursday, June 28, 2001 1:54 PM
To: ASP Databases
Subject: [asp_databases] RE: Converting DB to current vesion of Access
breaks connection.
Don't know why it would work in one version and not the other, but
normall
you get this if the IUSR_xxx account doesn't have create/delete access
to
the directory/folder where the .MDB file resides. IUSR_xxx needs to be
able
to create/delete the .LDB (lock) file.
-- Tomm
|
|
|
View Cart
