MySQL Forums
Forum List  »  Microsoft Access

Re: Link Breakage using MS Access as frontend to MySQL server
Posted by: Bryce Larsen
Date: January 17, 2022 05:58PM

Hi Peter, Thanks for the quick response.
Yeah, that's what I meant, one table with 1286 rows, and yes I can query it directly from a MySQL command line client. The error message Access was giving said 'ODBC--call failed'.
Now here's where I get to admit what I guess was a foolish mistake on my part. I was doing some further checking trying anything from the trace file that I thought could be a pertinent error code and found something suggesting that users must use the unicode ODBC connector. Sure enough, changing to that appears to have fixed the problem.
Thanks so much for your time!

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Link Breakage using MS Access as frontend to MySQL server
89
January 17, 2022 05:58PM


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.