Accessing Oracle 8i server from .Net

[jamesworthy88]

I need to access an Oracle 8i server running on Win2K server. I'll be accessing it from a WinXP Pro laptop and would like to know what client software I need to install and how to get it. It appears that I can't get client software for 8i from the Oracle website anymore.

I inherited a C# project that will only need read access to the db for reporting. (I've got plenty of db experience with Access, MySql, Pervasive but not Oracle)

Can I use newer software (9i, 10g)? I'd like to use the native Oracle driver for performance but I'd consider an OleDb provider, or ODBC drivers if either doesn't require installing the Oracle client software. I just want to get it working. However, I'd prefer to have access to any Oracle client tools that come with to test sql statment too if possible.

If anyone can tell me if I need any licensing to do this that would appreciated too. I will only be writing/testing the app on my laptop and not running it for production purposes (but there is no development db).

Thanks much!

 

[Turkbear]

Hi,
Current Oracle client software is backward compatible from 8i onwards.

You can also use Oracle's Provider for .NET :

http://www.oracle.com/technology/tech/dotnet/aspnet/index.html

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jamesworthy88]

Thanks much for the info. Looks to be exactly what I need.