maria-discuss team mailing list archive

Thread
Date

New Question: Problem Connector ODBC between MariaDB and ACCESS

To: maria-discuss@xxxxxxxxxxxxxxxxxxx
From: AskMonty KB <noreply@xxxxxxxxxxxx>
Date: Mon, 27 Jun 2016 15:55:03 -0000

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/