Loading an SQL Server table into CAS fails with "ERROR: The connection to the data source driver failed..." when the database name contains a hyphen


When loading a table from Microsoft SQL Server into CAS, you might receive the following error:

ERROR: The connection to the data source driver failed.
ERROR: Unable to set driver connection attribute

This issue occurs if the database name contains a hyphen.

A workaround is to change the name of the database to remove the hyphen or create a view on a different database that references the table that you are loading.