ADO Tutorial
ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed UpADO Objects
ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypesADO Summary
ADO Examples
ADO ExamplesADO Exam
ADO CertificateADO Open Method
Complete Connection Object Reference
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
| 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 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. |
Example
A DSN-less connection:
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
%>
A DSN-less connection with userID and password
(write the conn.open statement in ONE line):
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;
data source=c:/webdata/northwind.mdb;
userID=xxx;
password=yyy"
%>
An ODBC Database Connection:
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "northwind"
%>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
%>
A DSN-less connection with userID and password
(write the conn.open statement in ONE line):
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;
data source=c:/webdata/northwind.mdb;
userID=xxx;
password=yyy"
%>
An ODBC Database Connection:
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "northwind"
%>
ConnectOptionEnum
| Constant | Value | Description |
|---|---|---|
| adConnectUnspecified | -1 | Default. Opens the connection synchronously (after). |
| adAsyncConnect | 16 | Opens the connection asynchronously (before). |
Complete Connection Object Reference
Your suggestion:
Close [X]
Thank You For Helping Us!
Your message has been sent to W3Schools.
Close [X]
