Provider
ADO Provider xususiyati
❮ Connection obyektining to‘liq ma’lumotnomasi
Provider xususiyati muayyan Connection obyekti uchun provayder nomini o‘z ichiga olgan string qiymatni o‘rnatadi yoki qaytaradi. Standart qiymati: MSDASQL (ODBC uchun Microsoft OLE DB provayderi). Provayder kodlari bo‘limiga qarang
Ulanish yopiq bo‘lganda bu xususiyat o‘qish/yozish uchun mo‘ljallangan.
Provayder nomini Connection obyektining ConnectionString xususiyati yoki Open metodining ConnectionString parametri orqali ham o‘rnatish mumkin.
Eslatma: Muayyan Connection uchun provayderni hech qachon bir nechta joyda o‘rnatmang.
Sintaksis
connobj.Provider
Misol
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
response.write(conn.Provider)
conn.close
%>
Provayder kodlari
| Provayder kodi | Provider |
|---|---|
| ADSDSOObject | Active Directory Services |
| Microsoft.Jet.OLEDB.4.0 | Microsoft Jet ma’lumotlar bazalari |
| MSDAIPP.DSO.1 | Microsoft Internet Publishing |
| OraOLEDB | Oracle ma’lumotlar bazalari |
| MSDAOSP | Oddiy matnli fayllar |
| MSDASQL | ODBC uchun Microsoft OLE DB provayderi |
| MSDataShape | Microsoft Data Shape |
| MSPersist | Lokal saqlangan fayllar |
| SQLOLEDB | Microsoft SQL Server |
❮ Connection obyektining to‘liq ma’lumotnomasi
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!