Home > Archive > ASP > June 2005 > Error in Connect Access Database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error in Connect Access Database
|
|
| Thomas Tsang 2005-06-06, 8:55 am |
| I am using ASP + IIS + MS access, when running the
following codes:
set Conn=Server.CREATEOBJECT("ADODB.CONNECTION")
conn.open "DRIVER={Microsoft Access Driver
(*.mdb)}; " & Server.MapPath("db.mdb")
The following erorr is show:
General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x508
Thread 0x634 DBC 0x2181024 Jet'.
I have shared the MS knowledge base and try to
grant the modify Permissions to IUSR_SERVER on the
folder that holding the database, and set the
script authority in IIS, the error is still exist.
If I create a system DNS for that Access file and
modify the second code as
conn.Open "AKmobile"
Another error is show:
[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.
But there is no problem when conencting with MS
SQL Server.
Please help. Thnak a lot.
| |
| Bob Barrows [MVP] 2005-06-06, 3:55 pm |
| Thomas Tsang wrote:
> I am using ASP + IIS + MS access, when running the
> following codes:
>
> set Conn=Server.CREATEOBJECT("ADODB.CONNECTION")
> conn.open "DRIVER={Microsoft Access Driver
> (*.mdb)}; " & Server.MapPath("db.mdb")
>
Change your connection string to :
dim sConnect
sConnect = "Provider=microsoft.jet.oledb.4.0;" & _
"Data Source=" & Server.MapPath("db.mdb")
conn.open sConnect
The native OLEDB provider needs no access to the Registry. Using the
obsolete ODBC driver can lead to this error.
> The following erorr is show:
> General error Unable to open registry key
> 'Temporary (volatile) Jet DSN for process 0x508
> Thread 0x634 DBC 0x2181024 Jet'.
>
>
> Another error is show:
> [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.
>
The IUSR account needs read/write permissions for the FOLDER containing the
database, not just the database. All database users must be able to create,
modify and delete the locking file (db.ldb) in order for multiuser activity
to be allowed.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
| |
| Thomas Tsang 2005-06-06, 3:55 pm |
| Thank you for your information, but 'Unspecified
error' is show when using
sConnect = "Provider=microsoft.jet.oledb.4.0;" &
"Data Source=" & Server.MapPath("db.mdb")
conn.open sConnect
And in fact I have already grant the full control
authority to the IUSR on the folder containing the
Access database, but still failure....
"Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> ¦b
¶l¥ó news:%237MmSwoaFHA.3364@TK2MSFTNGP09.phx.gbl
¤¤¼¶¼g...
> Thomas Tsang wrote:
the[color=darkred]
Conn=Server.CREATEOBJECT("ADODB.CONNECTION")[color=darkred]
> Change your connection string to :
>
> dim sConnect
> sConnect = "Provider=microsoft.jet.oledb.4.0;" &
_
> "Data Source=" & Server.MapPath("db.mdb")
> conn.open sConnect
>
> The native OLEDB provider needs no access to the
Registry. Using the
> obsolete ODBC driver can lead to this error.
>
0x508[color=darkred]
file[color=darkred]
by[color=darkred]
its[color=darkred]
>
> The IUSR account needs read/write permissions
for the FOLDER containing the
> database, not just the database. All database
users must be able to create,
> modify and delete the locking file (db.ldb) in
order for multiuser activity
> to be allowed.
>
> Bob Barrows
> --
> Microsoft MVP - ASP/ASP.NET
> Please reply to the newsgroup. This email
account is my spam trap so I
> don't check it very often. If you must reply
off-line, then remove the
> "NO SPAM"
>
>
| |
| Bob Barrows [MVP] 2005-06-06, 3:55 pm |
| Thomas Tsang wrote:
> Thank you for your information, but 'Unspecified
> error' is show when using
> sConnect = "Provider=microsoft.jet.oledb.4.0;" &
> "Data Source=" & Server.MapPath("db.mdb")
> conn.open sConnect
>
You need to reinstall or install a later version of MDAC. Go to
msdn.microsoft.com and search for the latest MDAC.
Be sure to download and install the Jet components which are not included
with the MDAC installation.
Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"
|
|
|
|
|