MySQL Forums
Forum List  »  Connector/ODBC

Error connecting to MySQL 8.0 with ODBC 5.3 (Excel)
Posted by: Mor Sagmon
Date: May 14, 2018 05:07AM

Hi.

After upgrading MySQL to 8.0 on Windows 64bit, I cannot connect through ODBC MySQL Unicode Driver 5.3.10 (32bit) from Excel 2016 (32 bit).

I get this error:
[MySQL][ODBC 5.3(w) Driver][mysqld 8.0.11]Source character set not supported yb client.

The connection string I'm constructing is:
Driver={MySQL ODBC 5.3 Unicode Driver};Server=localhost;Port=3306;Database=dbname;Uid=myusername;Pwd=mypwd;OPTION=16427;

The connection is opened OK, but the error is trapped when accessing the DB for recordset.

(The DB is OK, as I can access it from the Workbench and from another Python application and apply SQL statements).

Please help :)

Options: ReplyQuote


Subject
Written By
Posted
Error connecting to MySQL 8.0 with ODBC 5.3 (Excel)
May 14, 2018 05:07AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.