MySQL Forums
Forum List  »  Connector/ODBC

Re: Source character set not supported by client error on SHOW TABLES command
Posted by: David Webb
Date: June 22, 2018 10:17PM

After writing the previous reply, I found a solution. It turns out that Microsoft Office 365 makes Office available in both 32-bit and 64-bit versions, although the default download is 32-bit. So I uninstalled 32-bit office and installed 64-bit office. Microsoft Access 64-bit connects to MySQL using the 64-bit 8.0.11 ODBC connector, and my system is (almost) working again! I am using the unicode connector, by the way.

HOWEVER, there is a bug in ODBC Connector which prevents updates to recordsets when the cursorType is adOpenForwardOnly (the default in ADO). You can add rows, but you can't update existing rows. The workaround for that is to change all my code to use adOpenKeyset instead. See:
https://www.w3schools.com/asp/prop_rs_cursortype.asp

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.