Solved

connection from .NET to Oracle RDBMS v11.1

Posted on 2012-03-22
2
635 Views
Last Modified: 2012-03-22
What is connection string for Oracle RDBMS? Should I  continue to use ADO.NET?

Background: My C#.NET application is using ADO.NET (SQLConnection, SqlCommand, SqlDataReader classes) to select data from Microsoft SQL Server database tables. The data tables are moving from Microsoft to an Oracle RDBMS version 11.0.7.0 database.

The following is my connection string to SQL Server.
Data Source=STEP2SQL;Initial Catalog=ProductSafety;Integrated Security=True

Also ... What is the proper .NET class for use with an Oracle database?
System.Data.OracleClient Namespace is deprecated.
0
Comment
Question by:tonygallo10
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 37753333
Use Oracle's provider: ODP.Net

http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html

Everything should be similar to what you are used to.
0
 
LVL 53

Expert Comment

by:Huseyin KAHRAMAN
ID: 37753466
check:

http://www.infoq.com/news/2009/06/oracleclient_deprecated

I have been using ODP.Net since .Net 2.x
0

Featured Post

Major Incident Management Communications

Major incidents and IT service outages cost companies millions. Often the solution to minimizing damage is automated communication. Find out more in our Major Incident Management Communications infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question