I created a basic Form/Subform using the Form Wizard. The form is pulling data from 2 tables linked via ODBC to MySql Workbench. When I run the form, it returns a syntax error (HY000 code 1000 error message). I did not have this issue until I linked my tables to MySql Workbench using an ODBC connection. Before the ODBC connection, it worked find. And another issue is in the Form properties. The form is pulling data from my table (in MySql Workbench) but I’m not able to view the data in the table from the … button. (I am able to edit the data when I go directly into the table so I don’t believe it’s a user access issue).
Have a look at Edit → Database → Advanced Settings → Special settings.
Might be “Replace named parameters with ‘?’” will help.
By the way: Isn’t MySQLWorkbench a tool for MySQL database? If it is so you never link to MySQLWorkbench.
Thanks Robert. I checked my advance settings and the “replace named parameters with ?” was already checked. MySQL Workbench is where my tables reside. LibreOffice base is the interface for forms and reports.
So we have to look to the ODBC-connection.
Which system do you use? Under Linux there will be an odbc.ini for connection settings.
Is this what you’re looking for
[ODBC 32 bit Data Sources]
NameofmydbODBC=MySQL ODBC 9.2 ANSI Driver (32 bit)
[NameofmydbODBC]
Driver32=C:\Program Files\MySQL\MySQL Connector ODBC 9.2\myodbc9a.dll
Don’t know much about Windows, but what you show there is the driver, not the entries for the configuration. There will be a GUI to define the configuration in Windows, where you could set the port for the database, charset and so on…