4 Replies Latest reply on May 29, 2007 11:54 AM by 552423

    Microsoft OLE DB Provider for Oracle error '80040e37'

    552423
      Hi,

      I am getting this error:

      Microsoft OLE DB Provider for Oracle error '80040e37'

      ORA-00942: table or view does not exist

      when I try to access login.asp page from website.

      Actually, I have installed oracle 9.2.0.1 server & client on server.
      Then, I have applied 9.2.0.6 patch. Then by taking export dump of full database from another server, I have restored it on this server.
      After which, I have also verified no. of tables for that schema is correct or not.
      None of the table is missing for that user.

      Though I am getting above error.
      I think it is error related to ole db provider. Do I have to download ole db 9.2.0.7 provider & install it? or it get installed alongwith 9.2.0.6 patch?

      I have tried downloading that provider from oracle site, but unable to download whole file.

      Please help.

      Message was edited by:
      Seema