connect to Oracle 9i

Posted on 2005-03-02
Medium Priority
Last Modified: 2010-05-18
I have worked with asp.net and have connected to MS Access and SQL server, but I have never connected to Oracle. Can I connect to Oracle without ODP, for example with OLE, has anyone an example of connection to oracle from asp.net application.

Question by:dragy
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
1 Comment

Accepted Solution

stu_pb earned 120 total points
ID: 13443643
I have done this with the following code:

OleDbConnection connection = new OleDbConnection("Provider=OraOLEDB.Oracle;Data Source=theDataSource;User ID=theUserID;Password=thePassword;");

Then you can use the OleDbCommand object to query the database.

This assumes you have the Oracle 9i OLE DB drivers installed on the web server.

Good Luck!

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this post we will learn how to make Android Gesture Tutorial and give different functionality whenever a user Touch or Scroll android screen.
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
Suggested Courses

777 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