OleDbException executing reader on Access stored view

Discussion in 'ASP .Net' started by Marco Frontini, Jan 12, 2005.

  1. 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 to an Access database using System.Data.OleDb objects
    and Jet 4.0 oledb provider.
    The same code works fine in windows form 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 it is strange that all
    properly works 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.

    ???????
    Some ideas?

    Thanks so much for your help, Marco.
     
    Marco Frontini, Jan 12, 2005
    #1
    1. Advertising

  2. Exceptions have messages. Odd that you danced all around the exception
    without managing to mention what exactly it IS. How about it?

    --
    HTH,

    Kevin Spencer
    Microsoft MVP
    ..Net Developer
    Neither a follower nor a lender be.

    "Marco Frontini" <> wrote in message
    news:ucslziM%...
    >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 to an Access database using System.Data.OleDb
    > objects and Jet 4.0 oledb provider.
    > The same code works fine in windows form 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 it is strange that
    > all properly works 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.
    >
    > ???????
    > Some ideas?
    >
    > Thanks so much for your help, Marco.
    >
     
    Kevin Spencer, Jan 12, 2005
    #2
    1. Advertising

  3. A generic "Internal OLE Automation Error" isn't so usefull.


    "Kevin Spencer" <> ha scritto nel messaggio
    news:O8pWebN%...
    > Exceptions have messages. Odd that you danced all around the exception
    > without managing to mention what exactly it IS. How about it?
    >
    > --
    > HTH,
    >
    > Kevin Spencer
    > Microsoft MVP
    > .Net Developer
    > Neither a follower nor a lender be.
    >
    > "Marco Frontini" <> wrote in message
    > news:ucslziM%...
    >>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 to an Access database using System.Data.OleDb
    >> objects and Jet 4.0 oledb provider.
    >> The same code works fine in windows form 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 it is strange that
    >> all properly works 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.
    >>
    >> ???????
    >> Some ideas?
    >>
    >> Thanks so much for your help, Marco.
    >>

    >
    >
     
    Marco Frontini, Jan 12, 2005
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?VDg=?=
    Replies:
    1
    Views:
    5,927
    Keith
    Nov 7, 2003
  2. Joe
    Replies:
    0
    Views:
    531
  3. Guilherme Grillo

    reader inside a reader

    Guilherme Grillo, Nov 7, 2007, in forum: ASP .Net
    Replies:
    5
    Views:
    540
    sloan
    Nov 7, 2007
  4. Parthiv Joshi
    Replies:
    1
    Views:
    775
    Samuel L Matzen
    Jul 6, 2004
  5. Pokkai Dokkai
    Replies:
    1
    Views:
    244
    Hassan Schroeder
    Mar 24, 2008
Loading...

Share This Page