The Provider property sets or returns a string value that contains the provider name for a specific Connection object. Default is MSDASQL (Microsoft OLE DB provider for ODBC). Look at Provider Codes
Provider属性的作用是：设置或返回包含详细连接对象的技术提供对象[provider]名称的字符串值。默认值为MSDASQL（Microsoft OLE DB provider for ODBC）。请参照Provider代码。

This property is read/write when the connection is closed.
当连接被关闭时，该属性是可读/可写的。

The provider name can also be set with the ConnectionString property of the Connection object or the ConnectionString parameter of the Open method.
技术提供对象的名称可以通过Connection对象中的ConnectionString属性进行设置，或者通过Open方法中的ConnectionString参数进行设置。

Note: Never set the provider for a specific Connection in more than one place.
注意：不要在多处为详细连接设置技术提供对象[provider]。

Syntax
语法

connobj.Provider

Example
案例

<%
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
%>

评论 (0) All