ODBCConnection.RobustConnect Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Returns or sets how ODBC connection connects to its data source. Read/write XlRobustConnect.

public:
 property Microsoft::Office::Interop::Excel::XlRobustConnect RobustConnect { Microsoft::Office::Interop::Excel::XlRobustConnect get(); void set(Microsoft::Office::Interop::Excel::XlRobustConnect value); };

public Microsoft.Office.Interop.Excel.XlRobustConnect RobustConnect { get; set; }

Public Property RobustConnect As XlRobustConnect

Property Value

XlRobustConnect

XlRobustConnect

Remarks

If you use robust connectivity, when Microsoft Excel is unable to establish a connection using the workbook connection information, Excel will check if the workbook connection has a path to an external connection file. If it does, Excel will open the external connection file and try to connect using the information contained in the external connection file. If a connection can be established after using the external connection file, Excel will then update the workbook's connection object.

This provides robust connectivity in scenarios where an Information Technology Department maintains and updates connections in a central place, permitting a user's workbook to automatically fetch those updates whenever the previous version of the connection (cached within the workbook) fails.