Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-62

Problem with export from ACCESS

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.12
    • Fix Version/s: 2.0.14, 3.0.1
    • Component/s: None
    • Labels:
      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 "

        Attachments

          Activity

            People

            Assignee:
            Lawrin Lawrin Novitsky
            Reporter:
            Lawrin Lawrin Novitsky
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration