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
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
If I understood your question correctly,
http://www.connectionstrings.com/
will usually help you.
You need (if I remember correctly) OraOLEDB.
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.