ADO.NET Provider for Microsoft Excel

Build 23.0.8839

CredentialsLocation

The location of the settings file where MFA credentials are saved.

Data Type

string

Default Value

"%APPDATA%\\CData\\Excel Data Provider\\CredentialsFile.txt"

Remarks

MFA credentials are short-lived and typically expire after an hour. At that point, you must specify a different MFAToken to continue connecting. MFA tokens only work once, so in the case of multi-threaded or multi-process applications, the credentials must be centrally located and shared to avoid problems. When MFAToken is not specified, this property does nothing.

If left unspecified, the default location is "%APPDATA%\\CData\\Excel Data Provider\\CredentialsFile.txt" with %APPDATA% being set to the user's configuration directory:

Platform %APPDATA%
Windows The value of the APPDATA environment variable
Mac ~/.config
Linux ~/.config

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839