Scheduler and Orchestrator silently fail to connect if a database provider is not installed

[hbpe-aarhus]

When connecting to Orchestrator or Scheduler, no error is shown if the database provider specified in the connection string is not available.

Example:

mssql+pyodbc://sqlserver123/sqldatabase123?trusted_connection=yes&driver=ODBC+Driver+17+for+SQL+Server

If ODBC Driver 17 is not installed on the local machine trying to connect, no error is shown when clicking 'Connect'.

It would be nice if an error was output either in the Orchestrator GUI as a popup, or in the command prompt from which the Scheduler was started, or both.

[ghbm-itk]

There are multiple issues when a connection fails.
I have tried multiple fixes but I gave up after some time.

Both the Scheduler and Orchestrator run in async frameworks, which makes it more complicated than my brain could handle at the time.