Share via

ODBCConnection Object Members

  • Article
Excel Developer Reference

Represents the ODBC connection.

Methods

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

Properties

  Name Description
Bb242369.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.
Bb242369.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.
Bb242369.properties(en-us,office.12).gif BackgroundQuery True if queries for the ODBC connection are performed asynchronously (in the background). Read/write Boolean.
Bb242369.properties(en-us,office.12).gif CommandText Returns or sets the command string for the specified data source. Read/write Variant.
Bb242369.properties(en-us,office.12).gif CommandType Returns or sets one of the XlCmdType constants. Read/write XlCmdType.
Bb242369.properties(en-us,office.12).gif Connection Returns or sets a string that contains ODBC settings that enable Microsoft Excel to connect to an ODBC data source. Read/write Variant.
Bb242369.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.
Bb242369.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.
Bb242369.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb242369.properties(en-us,office.12).gif RefreshDate Returns the date on which the ODBC connection was last refreshed. Read-only Date.
Bb242369.properties(en-us,office.12).gif Refreshing True if a background ODBC query is in progress for the specified ODBC connection. Read/write Boolean.
Bb242369.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.
Bb242369.properties(en-us,office.12).gif RefreshPeriod Returns or sets the number of minutes between refreshes. Read/write Long.
Bb242369.properties(en-us,office.12).gif RobustConnect Returns or sets how ODBC connection connects to its data source. Read/write XlRobustConnect.
Bb242369.properties(en-us,office.12).gif SavePassword True if password information in an ODBC connection string is saved in the connection string. False if the password is removed. Read/write Boolean.
Bb242369.properties(en-us,office.12).gif ServerCredentialsMethod Returns or sets the type of credentials that should be used for server authentication. Read/write XlCredentialsMethod.
Bb242369.properties(en-us,office.12).gif ServerSSOApplicationID Returns or sets a single sign-on application (SSO) identifier that is used to do a lookup in the SSO database for credentials. Read/write String.
Bb242369.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.
Bb242369.properties(en-us,office.12).gif SourceData Returns the data source for the ODBC connection, as shown in the table. Read/write Variant.
Bb242369.properties(en-us,office.12).gif SourceDataFile Returns or sets a String indicating the source data file for an ODBC connection. Read/write.