topic Help for ODBC ACCESS configuration for MySQL in Administration and Deployment

Help for ODBC ACCESS configuration for MySQL

AsSASsin — Tue, 14 Jun 2022 15:18:20 GMT

Dear All,

I'm trying to configure on linux RHEL the ODBC connector for MySQL.

I installed the ODBC DRIVER and filled the ODBC.ini, but when I'm trying to connect I have this error:

ERROR: CLI error trying to establish connection: [DataDirect][ODBC lib] Unicode converter buffer overflow
ERROR: Error in the LIBNAME statement.

Is there a chance to make it works?

Thanks a lot

Re: Help for ODBC ACCESS configuration for MySQL

gwootton — Tue, 14 Jun 2022 15:41:46 GMT

Does this SAS Note apply?

Problem Note 68591: The error "Unicode converter buffer overflow" occurs when you use a DSN-less LIBNAME statement that contains the DriverUnicodeType=1 option
https://support.sas.com/kb/68/591.html

Re: Help for ODBC ACCESS configuration for MySQL

AsSASsin — Tue, 14 Jun 2022 16:00:49 GMT

Is not that case because I'm using DSN configuration in ODBC.ini

Re: Help for ODBC ACCESS configuration for MySQL

gwootton — Tue, 14 Jun 2022 16:45:07 GMT

Are you specifying the "DriverUnicodeType" option?

Re: Help for ODBC ACCESS configuration for MySQL

AsSASsin — Tue, 14 Jun 2022 17:00:11 GMT

I tried that option in DSN configuration, but it returns another error about a sock file for a local installation of MySQL…but it is not that…
I tried the Linux connector ODBC with python and it works well.

Re: Help for ODBC ACCESS configuration for MySQL

gwootton — Tue, 14 Jun 2022 17:26:47 GMT

I'd recommend you open a technical support ticket.