OleDbConnection::Open Method ()
Opens a database connection with the property settings specified by the ConnectionString.
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. |
Available since 1.1