O'Reilly logo

ADO.NET Programming in Visual Basic™ .NET by Bob Howell, Steve Holzner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Oracle Data Provider

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required