Re: Problem reading data from Access 2000
From: Ed (Please_at_NoEmail.com)
Date: 09/03/04
- Next message: Jim Mischel: "Unexplained VersionNotFoundException"
- Previous message: Scott M.: "Re: Calling a class in VB"
- In reply to: Ed: "Problem reading data from Access 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 02 Sep 2004 23:09:45 -0500
Ed wrote:
> 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
Never mind. I am used to ASP. I had to give ASPNET (and not IUSR_)
account access to the file.
>
> 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.
>
>
>
- Next message: Jim Mischel: "Unexplained VersionNotFoundException"
- Previous message: Scott M.: "Re: Calling a class in VB"
- In reply to: Ed: "Problem reading data from Access 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
