The Microsoft OLEDB provider for Oracle databases can be used to connect to Oracle 7 and higher databases. A typical Connection string for Oracle looks like this:
Provider=MSDAORA.1;Password=MANAGER;User ID=SYSTEM;Data Source=ORACLEDB
This Connection string uses the default user and password that comes with the Oracle release. There really isn’t much to say about the Oracle provider. Since the Oracle client architecture is radically different than SQL Server’s, most of the tuning and such is done via other methods that are beyond the scope of this book.
For the Oracle provider, the Data Source property must reference a valid Oracle security identifier (SID), which you must set up using the Oracle Net Manager. The SID ...