Problem with OracleClient namespace

[burak]

Hello,

 

I want to use the OracleConnection, OracleCommand,

and OracleDataReader classes, so I included the

following namespaces in my code.

 

<%@ import namespace="System"%>

<%@ import namespace="System.Data"%>

<%@ import namespace="System.Data.OracleClient"%>

 

When I ran the page, it came back with the following

error

 

"BC30002: Type 'OracleConnection' is not defined"

 

I researched it on the internet and found I had to

explicitly include the reference in the project. Isaw

that I did not have System.Data.OracleClient.dll

installed, so I downloaded it from the net.

 

I then added the reference to my project but I am

still getting the same error.

 

"error BC30466: Namespace or type 'OracleClient' for

the Imports 'System.Data.OracleClient' cannot be

found."

 

Any ideas?

 

Thank you,

 

Burak

[Robby]

Where did you get the System.Data.OracleClient.dll ?

 

You can use System.Data.OleDb instead.

[wyrd]

OracleClient.dll is the data provider for Oracle, which was made by Oracle themselves I believe (if not then they probably ripped it from the mono project).

 

In any case, MSDN has documentation on it and it's in version 1.1 of the .NET framework.

 

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataoracleclient.asp

 

If you don't have 1.1 you can download it from the Oracle site (you need a login name and all that jazz though)

 

http://otn.oracle.com/software/content.html