DBConnection class
DBConnection class
Specifies all properties associated with an ODBC or OLE DB external data connection.
Inheritance: DBConnection
The DBConnection type exposes the following members:
Properties
| Property | Description |
|---|---|
| id | |
| connection_id | |
| class_type | Gets the type of this ExternalConnection object. |
| power_query_formula | Gets the definition of power query formula. |
| type | |
| source_type | |
| sso_id | |
| save_password | |
| save_data | |
| refresh_on_load | |
| reconnection_method_type | |
| reconnection_method | |
| only_use_connection_file | |
| odc_file | |
| source_file | |
| connection_file | |
| is_new | |
| name | |
| keep_alive | |
| refresh_internal | |
| connection_description | |
| is_deleted | |
| credentials_method_type | |
| credentials | |
| background_refresh | |
| parameters | |
| command | The string containing the database command to pass to the data provider API that will interact with the external source in order to retrieve data |
| command_type | Specifies the OLE DB command type. 1. Query specifies a cube name 2. Query specifies a SQL statement 3. Query specifies a table name 4. Query specifies that default information has been given, and it is up to the provider how to interpret. 5. Query is against a web based List Data Provider. |
| connection_string | The connection information string is used to make contact with an OLE DB or ODBC data source. |
| second_command | Specifies a second command text string that is persisted when PivotTable server-based page fields are in use. For ODBC connections, serverCommand is usually a broader query than command (no WHERE clause is present in the former). Based on these 2 commands(Command and ServerCommand), parameter UI can be populated and parameterized queries can be constructed |
| connection_info | The connection information string is used to make contact with an OLE DB or ODBC data source. |
| sever_command | Specifies a second command text string that is persisted when PivotTable server-based page fields are in use. For ODBC connections, serverCommand is usually a broader query than command (no WHERE clause is present in the former). Based on these 2 commands(Command and ServerCommand), parameter UI can be populated and parameterized queries can be constructed |
See Also
- module
aspose.cells.externalconnections - class
DBConnection
