Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8584

connect engine -> unixodbc -> firebird

    Details

      Description

      I like to use connect engine of mariadb to connect to a firebird database via ODBC on a server which is running on Centos 7.

      I have already established a connection to sqlserver.
      The odbc-test to the firebird-database with isql works as well.

      This is my create-statement for remotetable

      CREATE TABLE con.test_table_apys
      ENGINE=CONNECT
      TABLE_TYPE=ODBC
      TABNAME='wsk_lager_st'
      CONNECTION='DSN=apys;UID=SYSDBA;PWD=myownpassword';

      After sending the statement to the server I got this error message:

      ERROR 2006 (HY000): MySQL server has gone away

      This is the content of odbc.ini

      [apys]
      Description     = Firebird
      Driver          = Firebird
      Dbname          = apysdbserver/3051:vm_apys_ori205
      Role            =
      CharacterSet    = WIN1252
      ReadOnly        = No
      NoWait          = No

      But as already mentioned the odbc-connection with isql is working.

        Attachments

        1. hostname.err
          5 kB
        2. odbc_firebird.result
          6 kB
        3. odbc_firebird.test
          0.9 kB
        4. odbc.ini
          0.2 kB
        5. odbcinst.ini
          0.2 kB

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              detommy Thomas
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: