hi,
here's another problem i've and hopefully someone will have the solution. I am trying to connect to oracle 9i using ODP .net (I installed ODP .net). But when i compile my .cs file in command line (as i don't have visual studio and use Dreamweaver), i get the following errors...

The above error is getting generated from these two lines:
a help would be highly appreciated..

regards.

Hi Masum,

I found this:
You need to either add a reference to your web.config file or copy the Oracle.DataAccess.dll file into your webapp's bin directory

or

When you compile your app at the command line just add the Oracle.DataAccess.dll as a reference. Like so,

csc mywebpage1.aspx, mywebpage2.aspx /out: myapp /reference: c:\oracle\ora92\bin\oracle.dataaccess.dll /target:library

You can visit this link for more information:
Using Oracle Database Transactions

Cheers,
Paramesh.

__________________

Don't walk in front of me, I may not follow.
Don't walk behind me, I may not lead.
Just walk beside me and be my friend.

Thnx Ramesh. I tried that already. Now i've got another problem. Now its giving me the following error.
Error:
Unable to load DLL(OraOps9.dll)

I don't have OraOps9.dll file in the bin directory(where its supposed to be) of the oracle home. But i have OraOps9.dll file in ODP .NET bin directory. I copied the file across to the oracle home bin directory but still having the same problem.

I think i should make it clear that i am using oracle 9.0.1.1.1 and ODP .NET 9.02....I was reading in Oracle site that you have to have Oracle 9.0.2 version or something, but in some forum somewhere i was reading that u can even use ODP .NET with oracle 8i. So please help me out here, whether i can or can't use Oracle 9.0.1 with ODP .net?

Regards,

Hi,
Try this link:
FAQS

Or try this:
grant permissions to the Oracle home directory to the asp.net
account(and possibly the iuser_machinename account). The oracle home
directory isn't generally visible to non-interactive accounts. You may need
read/execute on the oracle_home\bin directory.

Regards,
Paramesh.

__________________

Don't walk in front of me, I may not follow.
Don't walk behind me, I may not lead.
Just walk beside me and be my friend.