excel 2013 ole db oracle,Microsoft OLE DB Provider for Oracle

Microsoft OLE DB Provider for OracleMicrosoft OLE DB Provider for Oracle

09/18/2015

本文内容

适用于：Access 2013、Office 2013Applies to: Access 2013, Office 2013

Microsoft OLE DB Provider for Oracle 允许 ADO 访问 Oracle 数据库。The Microsoft OLE DB Provider for Oracle allows ADO to access Oracle databases.

连接字符串参数Connection String Parameters

若要连接到此提供程序，请将 ConnectionString 属性的 Provider 参数设置为：To connect to this provider, set the Provider argument of the ConnectionString property to:

MSDAORA

读取 Provider 属性时，也会返回此字符串。Reading the Provider property will return this string as well.

如果在 Oracle 数据库中执行包含键集或动态游标的连接查询，则将发生错误。Oracle 仅支持静态的只读游标。If a join query with a keyset or dynamic cursor is executed in an Oracle database, an error occurs. Oracle only supports a static read-only cursor.

典型的连接字符串Typical Connection String

此提供程序典型的连接字符串为：A typical connection string for this provider is:

"Provider=MSDAORA;Data Source=serverName;User ID=userName; Password=userPassword;"

该字符串由以下关键字组成：The string consists of these keywords:

关键字Keyword

说明Description

ProviderProvider

指定 OLE DB Provider for Oracle。Specifies the OLE DB Provider for Oracle.

Data SourceData Source

指定服务器的名称。Specifies the name of a server.

User IDUser ID

指定用户名。Specifies the user name.

PasswordPassword

指定用户密码。Specifies the user password.

提供程序特定的连接参数Provider-Specific Connection Parameters

除了支持 ADO 定义的那些参数以外，该提供程序还支持几个提供程序特定的连接参数。与 ADO 连接属性一样，可以通过 Connection 对象的 Properties 集合或将其作为 ConnectionString 的一部分来设置这些提供程序特定的属性。The provider supports several provider-specific connection parameters in addition to those defined by ADO. As with the ADO connection properties, these provider-specific properties can be set via the Properties collection of a Connection or as part of the ConnectionString.

这些参数在《OLE DB 程序员参考》中进行了全面介绍(ADO 动态属性索引提供了这些参数名与对应的 OLE DB 属性之间的交叉引用)。These parameters are fully described in the OLE DB Programmer's Reference. (The ADO Dynamic Property Index provides a cross-reference between these parameter names and the corresponding OLE DB properties.)

参数Parameter

描述Description

Window HandleWindow Handle

指示用于提示附加信息的窗口句柄。Indicates the window handle to use to prompt for additional information.

Locale IdentifierLocale Identifier

指示唯一的 32 位数字(例如 1033)，指定与用户的语言有关的首选项。这些首选项指示设置日期和时间格式的方式、按字母顺序对项排序的方式、比较字符串的方式等。Indicates a unique 32-bit number (for example, 1033) that specifies preferences related to the user's language. These preferences indicate how dates and times are formatted, items are sorted alphabetically, strings are compared, and so on.

OLE DB ServicesOLE DB Services

指示用于指定启用或禁用的各项 OLE DB 服务的位掩码。Indicates a bitmask that specifies OLE DB services to enable or disable.

PromptPrompt

指示在建立连接时是否提示用户。Indicates whether to prompt the user while a connection is being established.

Extended PropertiesExtended Properties

包含提供程序特定的扩展连接信息的字符串。仅对提供程序特定的连接信息(不能通过属性机制描述)使用此属性。A string containing provider-specific, extended connection information. Use this property only for provider-specific connection information that cannot be described through the property mechanism.