Visual Basic with Oracle: need Provider OLE DB for Oracle

How can I add Mi开发者_运维知识库crosoft Provider OLE DB for Oracle. I had Microsoft ODBC for Oracle, but I want to add a provider mentioned above.

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.