ODBCConnection Members
Office 2010
Represents the ODBC connection.
The ODBCConnection type exposes the following members.
| Name | Description | |
|---|---|---|
|
CancelRefresh | Cancels all refresh operations in progress for the specified ODBC connection. |
|
|
Refresh | Refreshes an ODBC connection. |
|
|
SaveAsODC | Saves the ODBC connection as a Microsoft Office Data Connection file. |
| Name | Description | |
|---|---|---|
|
|
AlwaysUseConnectionFile | True if the connection file is always used to establish connection to the data source. Read/write Boolean. |
|
|
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. |
|
|
BackgroundQuery | True if queries for the ODBC connection are performed asynchronously (in the background). Read/write Boolean. |
|
|
CommandText | Returns or sets the command string for the specified data source. Read/write Object. |
|
|
CommandType | Returns or sets one of the XlCmdType constants. Read/write XlCmdType. |
|
|
Connection | Returns or sets a string that contains ODBC settings that enable Microsoft Excel to connect to an ODBC data source. Read/write Object. |
|
|
Creator | Returns a constant in the XlCreator enumeration that indicates the application in which this object was created. Read-only. |
|
|
EnableRefresh | True if the connection can be refreshed by the user. The default value is True. Read/write Boolean. |
|
|
Parent | Returns the parent object for the specified object. Read-only. |
|
|
RefreshDate | Returns the date on which the ODBC connection was last refreshed. Read-only DateTime. |
|
|
Refreshing | True if a background ODBC query is in progress for the specified ODBC connection. Read/write Boolean. |
|
|
RefreshOnFileOpen | True if the connection is automatically updated each time the workbook is opened. The default value is False. Read/write Boolean. |
|
|
RefreshPeriod | Returns or sets the number of minutes between refreshes. Read/write Integer. |
|
|
RobustConnect | Returns or sets how ODBC connection connects to its data source. Read/write XlRobustConnect. |
|
|
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. |
|
|
ServerCredentialsMethod | Returns or sets the type of credentials that should be used for server authentication. Read/write XlCredentialsMethod. |
|
|
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. |
|
|
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. |
|
|
SourceData | Returns the data source for the ODBC connection, as shown in the table. Read/write Object. |
|
|
SourceDataFile | Returns or sets a String indicating the source data file for an ODBC connection. Read/write. |
