ADO Connection Object: Open Method
The Open method opens a connection to a data source. When the connection is
open, you can execute commands against the data source.
Syntax
connection.Open connectionstring,userID,password,options
|
Example
Set conn = New ADODB.Connection
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;"
& _
"data source=F:\MaterialMaster\Material_Master.mdb;"
userID=91128;
password=planning"
|
| Parameter |
Description |
| connectionstring |
Optional. A string value that contains information
about the connection. The string is composed of a series of
parameter=value statements separated by semicolons.
Provider= the name of the provider
File Name= the file that contains the connection information
Remote Provider= the name of the provider to open a client-side
connection
Remote Server= the path name to the server to open a client-side
connection
URL= the absolute URL address to use for the connection.
See the
ConnectionString property for details. |
| userID |
Optional. A String value that contains a user name for
the connection
|
| password |
Optional. A String value that contains a password for
the connection
|
| options |
Optional. A ConnectOptionEnum value that determines
whether this method should return after or before the connection is
established.
|
ConnectOptionEnum
| Constant |
Value |
Description |
| adConnectUnspecified |
-1 |
Default. Opens the connection synchronously (after). |
| adAsyncConnect |
16 |
Opens the connection asynchronously (before). |
|