Problem to access Oracle DB

[Kevin Spencer]

Do you have the Oracle Client and Networking components installed on the
machine on which you're running this app?

HTH,

Kevin Spencer
Microsoft FrontPage MVP
Internet Developer
[url]http://www.takempis.com[/url]
Some things just happen.
Everything else occurs.

"Shaw" <shaw_zhu@yahoo.com> wrote in message
news:00fe01c3457d$b9d44270$a501280a@phx.gbl...

> I try to build a very simple sample to access Oracle
> database in ASP.NET, and get an error message when web
> page launched (failed at adapter.fill method). The error
> said:
>
> "Oracle client and networking components were not found.
> These components are supplied by Oracle Corporation and
> are part of the Oracle Version 7.3.3 or later client
> software installation. Provider is unable to function
> until these components are installed."
>
> It's only happened in ASP.NET. I run similar UI and code
> in WinForm and it is just fine. I don't have problem to
> access Oracle DB in WinForm. So, is the DB access
> different in Oracle between WinForm and WebPage?
>
> I use "Microsoft OLE DB Provider for Oracle", Is it right
> provider to use?
>
> Any idea? Thanks for your help!
>
> Shaw

[Shaw Zhu]

Thanks Kevin, I checked my Oracle installation. It said "Oracle Net
Services 9.2.0.1.0 installed".

I have a question about version compatibility.The Oracle database I
installed is later version of Oracle 9i DB 9.2.0.1. Does "Microsoft OLE
DB Provider for Oracle" only support earlier Oracle DB version, such as
8i?

Can we only access Oracle 9.2 through ODP.NET (Oracle Data Provider for
..NET)?

I installed everything in one Windows XP Pro computer, MS Visual studio,
IIS and Oracle DB 9.2. When I run WinForm app debug version with Oracle
DB, it's fine. And I don't have problem to run "SQL*Plus" client on
Oracle PL/SQL. Thanks.

Shaw


*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!