Hello,

A new question has been asked in "MariaDB Connector/ODBC" by jlpierrey_52563. Please answer it at http://mariadb.com/kb/en/problem-connector-odbc-between-mariadb-and-access/ as the person asking the question may not be subscribed to the mailing list.

-------------------------------- Hello, I have a problem with the connection between ACCESS (2010), running with W7, and a MariaDB installed on a Synology NAS (DS212J). Test of DSN is OK. Import and link tables from NAS towards ACCESS are OK. But export from ACCESS is impossible: alert message says: " "ODBC l'appel a échoué (the call failed) [ma-2.0.10][5.5.49-MariaDB]You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '#O),'C_UFR' INTEGER('#O),'U_SECRETARIAT' VARCHAR,'U-2SECRETARIAT' VAR at line 1 (#1064)" I thank you

Complementary Infos: The pb is the same with 1.0.6 2.0.10 2.0.11 releases of mariadb connector (32 and 64 bits) C_UFR, U_SECRETARIAT ant U_2SECRETARIAT are the three first fields of the table i try to export. Setting of the NAS: • Serveur : Localhost via UNIX socket • Type de serveur : MariaDB • Version du serveur : 5.5.49-MariaDB - Source distribution • Version du protocole : 10 • Jeu de caractères du serveur : UTF-8 Unicode (utf8) Serveur Web: • nginx/1.9.11 • Version du client de base de données : libmysql - mysqlnd 5.0.11-dev - 20120503 - $Id: 76b08b24596e12d4553bd41fc93cccd5bac2fe7a $ • Extension PHP : mysqli curl mbstring • Version de PHP : 5.6.21

--------------------------------

To view or answer this question please visit: http://mariadb.com/kb/en/problem-connector-odbc-between-mariadb-and-access/