OLEDBConnection Object Members

  • Article
Excel Developer Reference

Represents the OLE DB connection.

Methods

  Name Description
Bb242376.methods(en-us,office.12).gif CancelRefresh Cancels all refresh operations in progress for the specified OLE DB connection.
Bb242376.methods(en-us,office.12).gif MakeConnection Establishes a connection for the specified OLE DB connection.
Bb242376.methods(en-us,office.12).gif Refresh Refreshes an OLE DB connection.
Bb242376.methods(en-us,office.12).gif SaveAsODC Saves the OLE DB connection as an Microsoft Office Data Connection file.

Properties

  Name Description
Bb242376.properties(en-us,office.12).gif ADOConnection Returns an ADO connection object if the PivotTable cache is connected to an OLE DB data source. Read-only.
Bb242376.properties(en-us,office.12).gif AlwaysUseConnectionFile True if the connection file is always used to establish connection to the data source. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Office Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object. Read-only.
Bb242376.properties(en-us,office.12).gif BackgroundQuery True if queries for the OLE DB connection are performed asynchronously (in the background). Read/write Boolean.
Bb242376.properties(en-us,office.12).gif CommandText Returns or sets the command string for the specified data source. Read/write Variant.
Bb242376.properties(en-us,office.12).gif CommandType Returns or sets one of the XlCmdType constants. Read/write XlCmdType.
Bb242376.properties(en-us,office.12).gif Connection Returns or sets a string that contains OLE DB settings that enable Microsoft Excel to connect to an OLE DB data source. Read/write Variant.
Bb242376.properties(en-us,office.12).gif Creator Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Bb242376.properties(en-us,office.12).gif EnableRefresh True if the connection can be refreshed by the user. The default value is True. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif IsConnected Returns True if the MaintainConnection property is True. Returns False if it is not currently connected to its source. Read-only Boolean.
Bb242376.properties(en-us,office.12).gif LocalConnection Returns or sets the connection string to an offline cube file. Read/write String.
Bb242376.properties(en-us,office.12).gif MaintainConnection Returns True if the connection to the specified data source is maintained after the refresh operation and until the workbook is closed. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif MaxDrillthroughRecords Returns or sets the maximum number of records to retrieve. Read/write Long.
Bb242376.properties(en-us,office.12).gif OLAP Returns True if the OLE DB connection is connected to an Online Analytical Processing (OLAP) server. Read-only Boolean.
Bb242376.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242376.properties(en-us,office.12).gif RefreshDate Returns the date on which the OLE DB connection was last refreshed. Read-only Date.
Bb242376.properties(en-us,office.12).gif Refreshing True if a background OLE DB query is in progress for the specified OLE DB connection. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif RefreshOnFileOpen True if the connection is automatically updated each time the workbook is opened. The default value is False. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif RefreshPeriod Returns or sets the number of minutes between refreshes. Read/write Long.
Bb242376.properties(en-us,office.12).gif RetrieveInOfficeUILang True if the data and errors are to be retrieved in the Office user interface display language when available. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif RobustConnect Returns or sets how OLE DB connection connects to its data source. Read/write XlRobustConnect.
Bb242376.properties(en-us,office.12).gif SavePassword True if password information in an OLE DB connection string is saved in the connection string. False if the password is removed. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif ServerCredentialsMethod Returns or sets the type of credentials that should be used for server authentication. Read/write XlCredentialsMethod.
Bb242376.properties(en-us,office.12).gif ServerFillColor True if the fill color format for the OLAP server is retrieved from the server when using the specified connection. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif ServerFontStyle True if the font style format for the OLAP server is retrieved from the server when using the specified connection. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif ServerNumberFormat True if the number format for the OLAP server is retrieved from the server when using the specified connection. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif ServerSSOApplicationID Returns or sets a single sign-on application (SSO) identifier that is used to perform a lookup in the SSO database for credentials. Read/write String.
Bb242376.properties(en-us,office.12).gif ServerTextColor True if the text color format for the OLAP server is retrieved from the server when using the specified connection. Read/write Boolean.
Bb242376.properties(en-us,office.12).gif SourceConnectionFile Returns or sets a String indicating the Microsoft Office Data Connection file or similar file that was used to create the connection. Read/write.
Bb242376.properties(en-us,office.12).gif SourceDataFile Returns or sets a String indicating the source data file for an OLE DB connection. Read/write.
Bb242376.properties(en-us,office.12).gif UseLocalConnection True if the LocalConnection property is used to specify the string that enables Microsoft Excel to connect to a data source. False if the connection string specified by the Connection property is used. Read/write Boolean.