OleDbConnection.Open Method
Opens a database connection with the property settings specified by the ConnectionString.
Namespace: System.Data.OleDb
Assembly: System.Data (in System.Data.dll)
| Exception | Condition |
|---|---|
| InvalidOperationException | The connection is already open. |
| OleDbException | A connection-level error occurred while opening the connection. |
The OleDbConnection draws an open connection from the connection pool if one is available. Otherwise, it establishes a new connection to the data source. You can open more than one DataReader on a single OleDbConnection. If the OLEDB provider you use does not support more than one active DataReader on a single connection, the OLEDB provider implicitly opens an additional connection for each.
 Note |
|---|
If the OleDbConnection goes out of scope, it is not closed. Therefore, you must explicitly close the connection by calling Close or Dispose, or using the connection within a Using statement. |
Windows 8, Windows Server 2012, Windows 7, Windows Vista SP2, Windows Server 2008 (Server Core Role not supported), Windows Server 2008 R2 (Server Core Role supported with SP1 or later; Itanium not supported)
The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.
