BookmarkSubscribeRSS Feed
AsSASsin
Quartz | Level 8

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

5 REPLIES 5
gwootton
SAS Super FREQ
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
--
Greg Wootton | Principal Systems Technical Support Engineer
AsSASsin
Quartz | Level 8

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

gwootton
SAS Super FREQ
Are you specifying the "DriverUnicodeType" option?
--
Greg Wootton | Principal Systems Technical Support Engineer
AsSASsin
Quartz | Level 8
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.
gwootton
SAS Super FREQ
I'd recommend you open a technical support ticket.
--
Greg Wootton | Principal Systems Technical Support Engineer

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 359 views
  • 0 likes
  • 2 in conversation