Why do I receive an error message in the output of the DATABASE function when I try to connect to a mySQL database using ODBC with the Database Toolbox?
I am using the Database toolbox to connect to a mySQL database on a Microsoft Windows computer. I am using the ODBC driver to connect to the database. I use the following code at the MATLAB command prompt:
conn = database('unixIndexDB','','');conn.message
However, I get the following error message in the "message" field of the output structure "conn":
ans = [MySQL][ODBC 3.51 Driver]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Connecting to mySQL' at line 1
Best Answer