visual basic with oracle (Need Provider oledb for oracle)

Question

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

Answer 1

If I understood your question correctly,

http://www.connectionstrings.com/

will usually help you.

You need (if I remember correctly) OraOLEDB.

Answer 2

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.