DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

does ole dataProvider needs oracle client to be installed ?

redologger-OCDec 17 2014 — edited Dec 17 2014

Hi guys,

not too sure i can ask the above question here.

Do you need to install oracle client when you want to use OLE data provider for your application?

sample code for using OLE :

using System.Data.OleDb;

...

OleDbConnection oracleConn = new OleDbConnection();

oracleConn.ConnectionString = "Provider=\"OraOLEDB.Oracle.1\";

User ID=scott;Password=tiger;

Data Source=yourSource; <----is define via the tnsname.ora (installation from oracle client)

Extended Properties="";

Persist Security Info=False";

oracleConn.Open();

I am asking this question cos -->:

If the connection is settle on the application server why i still see oracle client being install on the database server.

The application is in 32bit. Will it have problem connecting to the oracle database (64bit) ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2015

Added on Dec 17 2014

#oracle-provider-for-ole-db, #windows-and-net

8 comments

2,270 views