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/
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp