asked on

Connect to Oracle Database Using C# Without Installing Oracle on the Computer

Hello friends,

I would like to connect to an Oracle database sitting on a server, and I really do not want to install Oracle XE in my computer, since I don't need the Oracle DB in my computer anyway. I just need to connect from my C# code. I downloaded this from Oracle and put it in my C: drive:

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

I'm not sure what to do next after this. I'm pretty slick with using SQL Server with C#, but I haven't done this for an Oracle database before.

Thanks in advance for your assistance.

Jazon

SOLUTION

oleggold

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

oleggold

depending on Your vs installation You may already have the later and some sort of ado.net

piratepatrol

ASKER

Hi oleggold,

How do I find out if I already have the prerequisites?

Thanks,

Jazon

SOLUTION

Rahul Gade

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Praveen Kumar Chandrashekatr

download the proper version of oracle ODBC client or ODP.Net package from the oracle site mention in your post and then follow steps mention in the below site.

http://stackoverflow.com/questions/1626636/connecting-c-sharp-to-oracle

piratepatrol

ASKER

Hey guys,

I downloaded the "Client Package - Basic Lite" from http://www.oracle.com/technetwork/topics/winx64soft-089540.html

How do I get my Visual Studio to know how to access the DLLs in this client package? I see code samples online that says I need to do this...

using System.Data.OracleClient;

or this...

using Oracle.DataAccess.Client;

but my Visual Studio doesn't even know what OracleClient or Oracle is?

Thanks in advance for your help.

piratepatrol

ASKER

Help. :)

Praveen Kumar Chandrashekatr

check this doc for configuring ODP.Net for C#.

http://www.oracle.com/technetwork/topics/dotnet/index-085163.html

http://www.oracle.com/technetwork/database/windows/downloads/odpmbetainstall-1696475.html

step by steps to install ODC.NET

http://support.dundas.com/Dashboard25.Installing_the_Oracle_Data_Provider_for_dot_NET_%28ODP_dot_NET%29.ashx

https://forums.oracle.com/forums/thread.jspa?messageID=10724956

Hope these doc help you to configure

piratepatrol

ASKER

Hi praveencpk,

It seems that the above requires that I install ODC.NET on my computer. I was really hoping not to have to install anything. :( Isn't there an approach where I just refer Visual Studio to a folder with all the Oracle DLLs instead of actually installing ODC.NET?

Thanks again.

Jazon

ASKER CERTIFIED SOLUTION

Praveen Kumar Chandrashekatr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

piratepatrol

ASKER

Thank you, guys.