ADO.NET Programming in Visual Basic .NET By Steve Holzner, Bob Howell
Table of Contents
Chapter 5. Connecting to Databases
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:
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 then resolves everything else.
Before you can access an Oracle database, you must have installed the Oracle client software for the version of Oracle you are using.