Problem reading data from Access 2000

From: Ed (Please_at_NoEmail.com)
Date: 09/03/04 

Date: Thu, 02 Sep 2004 21:22:17 -0500

I cereated a database with only one table (person) in Access 2000 and
created and ODBC system DNS (PersonDB). I have following code in my ASP.Net

string ConStr = "DSN=PersonDB";
string ComStr = "Select Name from Person";
OdbcDataAdapter dataAdapter = new OdbcDataAdapter(ComStr, ConStr);
DataSet dataSet = new DataSet();
dataAdapter.Fill(dataSet, "Person");

I am using the same machine as server and client. I ran this after
restarting the machine so I know DB is not used. I get the followin
error on the last line above.

ERROR [HY000] [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. ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY000] [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.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code. I have given read
access to ths mdb to IUSR_ account.

Thanks

Exception Details: Microsoft.Data.Odbc.OdbcException: ERROR [HY000]
[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.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed ERROR [HY000] [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.

Relevant Pages

  • OleDbException (0x80004005):
    ... The Microsoft Jet database engine cannot open the ... permission to view its data. ... dataTable, IDbCommand command, CommandBehavior behavior) ...
    (microsoft.public.vsnet.general)
  • Access and database connection
    ... The Microsoft Jet database engine cannot open the ... or you need permission ... group Administrators, ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • DTS error -2147467259
    ... It works great if I run the package manually. ... Error source: Microsoft JET Database Engine ... DTSRun OnStart: Copy Data from Results to Results Step ...
    (microsoft.public.sqlserver.dts)
  • Re: dts and access db
    ... The pkg doesn't fail manually, ... Error source: Microsoft JET Database Engine Help file: ...
    (microsoft.public.sqlserver.dts)
  • Dragonfly Shopping Cart Multiple vulnerabilities
    ... Microsoft JET Database Engine error '80040e07' ... Data type mismatch in criteria expression. ...
    (Bugtraq)