The Oracle Data Provider

Team-Fly team-fly    

 
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:

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


Team-Fly team-fly    
Top


ADO. NET Programming in Visual Basic. NET
ADO.NET Programming in Visual Basic .NET (2nd Edition)
ISBN: 0131018817
EAN: 2147483647
Year: 2005
Pages: 123

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net