OleDbException executing reader on Access stored view

  • Thread starter Thread starter Marco Frontini
  • Start date Start date
M

Marco Frontini

I had a strange error in asp.net when try to execute a simple select
statement like "Select * From ViewName" if the stored view contains a where
clause.
The connection is made on Access database using System.Data.OleDb objects
and Jet 4.0 oledb provider.
The same code works fine in windows forms application.
Removing the where clause from the stored view or adding ASPNET user into
"Power Users" or "Administrators" groups, all works also in asp.net.
My first idea was a security/permission problem, but is strange that all
works properly without the where clause.

The error happens on Win xp sp2 with .NET 1.1 sp1 and don't happens on Win
xp sp1 with .NET 1.1 sp1.

???????
Any ideas?

Thanks so much for your help, Marco.
 
It sounds like a permissions issue on the fileshare considering that
it works if you add ASPNET to Administrators. So immediately *remove*
ASPNET from Administrators and Power Users (this is a truly giant
security hole) and grant it the necessary ACLs on the file share that
contains the mdb and the mdw file. I really have no idea why the WHERE
clause makes a difference, but at least it's something to try.

--Mary
 
Back
Top