Problem Note 69538: 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.
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Microsoft SQL Server | Linux for x64 | Viya | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-10-25 14:03:31 |
| Date Created: | 2022-09-09 15:30:00 |
