Forum Discussion
ODBC connection with MFA
Have someone a ODBC connection with MFA working in MS Access? If yes, how did you do it.
Standard ODBC drivers do not support MFA. The typical scenario where MFA is used is with a REST web service. If that is indeed your scenario, a library such as this one can be used.
"ODBC Driver 18 for SQL Server" have an option "With Microsoft Entra ID integrated authentication". This option doesn't support MFA?
I have found that connection with MFA is possible with adodb:
conn.ConnectionString = "Provider=MSOLEDBSQL;Server=<server_name>.database.windows.net;Database=<database_name>;Authentication=ActiveDirectoryInteractive;User ID=<user_name>"
Have you ever used this connection?