OleDbConnection.Open Method ()

 
System_CAPS_noteNote

The .NET API Reference documentation has a new home. Visit the .NET API Browser on docs.microsoft.com to see the new experience.

Opens a database connection with the property settings specified by the ConnectionString.

Namespace:   System.Data.OleDb
Assembly:  System.Data (in System.Data.dll)

Public Overrides Sub Open

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.

System_CAPS_noteNote

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.

.NET Framework
Available since 1.1
Return to top
Show: