Open
ADO Open metodi
❮ Connection obyektining to‘liq ma’lumotnomasi
Open metodi ma’lumotlar manbaiga ulanishni ochadi. Ulanish ochiq bo‘lganda ma’lumotlar manbaiga nisbatan buyruqlarni bajarishingiz mumkin.
Sintaksis
connection.Open connectionstring,userID,password,options
| Parametr | Tavsif |
|---|---|
| connectionstring | Ixtiyoriy. Ulanish haqidagi ma’lumotlarni o‘z ichiga olgan string qiymat. String nuqtali vergul bilan ajratilgan parameter=value ko‘rinishidagi ko‘rsatmalar ketma-ketligidan tashkil topadi. Provider= provayder nomi Batafsil ma’lumot uchun ConnectionString xususiyatiga qarang. |
| userID | Ixtiyoriy. Ulanish uchun foydalanuvchi nomini o‘z ichiga olgan String qiymat |
| password | Ixtiyoriy. Ulanish uchun parolni o‘z ichiga olgan String qiymat |
| options | Ixtiyoriy. Bu metod ulanish o‘rnatilgandan keyin yoki undan oldin qaytishi kerakligini belgilovchi ConnectOptionEnum qiymati. |
Misol
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"
%>
ConnectOptionEnum
| Konstanta | Qiymat | Tavsif |
|---|---|---|
| adConnectUnspecified | -1 | Standart qiymat. Ulanishni sinxron ochadi (keyin). |
| adAsyncConnect | 16 | Ulanishni asinxron ochadi (oldin). |
❮ Connection obyektining to‘liq ma’lumotnomasi
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!