tags:

views:

59

answers:

2

Dear sir, can you tell me,how can i add a provider for oracle(Microsoft Provider oledb for oracle).Actually i had Microsoft ODBC for oracle but i want to add a provider above mention.

with regards, Ameer

+1  A: 

If I understood your question correctly,

http://www.connectionstrings.com/

will usually help you.

You need (if I remember correctly) OraOLEDB.

Faruz
A: 

Microsoft Provider oledb for Oracle

Means that the connection string will be

Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;

Replace Data Source, user name and password as per your configuration.

Sathya