Error creating ODBC data source in SAS Viya 3.5 GUI

HangLui — Wed, 16 Dec 2020 02:48:44 GMT

HI,

My platform is CentOS 7, with MySQL 8.0.22 , unixODBC 2.3.1 and MySQL Connector ODBC 8.0.22.

I can connect to the local MySQL DB without any problem with the isql.

However, I got an error while creating an ODBC data source entry in the Environment Manager, I have included the dm_unicode = utf16 parameter in the 'Advanced' page. The error is as follows:

The connection to the data source driver failed.
ERROR: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
Function failed.
The action stopped due to errors.

Any comment is appreciated.

Thanks!

Lui

Re: Error creating ODBC data source in SAS Viya 3.5 GUI

KS4NCS — Mon, 28 Dec 2020 06:07:57 GMT

Hi Lui,
Recommend you to follow this guide to build the latest unixODBC driver manager as per this SAS Communities How to guide.
https://communities.sas.com/t5/SAS-Communities-Library/How-to-build-the-latest-unixODBC-driver-manager-for-Linux/ta-p/231907
The unixODBC version 2.3.1 is quite old.
Thanks.

topic Re: Error creating ODBC data source in SAS Viya 3.5 GUI in Administration and Deployment

Error creating ODBC data source in SAS Viya 3.5 GUI

Re: Error creating ODBC data source in SAS Viya 3.5 GUI