Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.0.12
-
None
-
None
Description
(copying from here)
" 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: An 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 for your help Jean-Louis PIERREY
Complementary Infos:
The problem 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 and 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 "