Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

connect to Oracle 9i

Hi,
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.

Thanks
0
dragy
Asked:
dragy
1 Solution
 
stu_pbCommented:
I have done this with the following code:

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

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!
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now