Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Microsoft OLE DB Provider for Oracle error '80040e37'

552423May 29 2007 — edited May 29 2007

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2007

Added on May 29 2007

#database-installation

4 comments

1,364 views