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

connect engine -> unixodbc -> firebird

    XMLWordPrintable

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. odbcinst.ini
          0.2 kB
        2. odbc.ini
          0.2 kB
        3. odbc_firebird.test
          0.9 kB
        4. odbc_firebird.result
          6 kB
        5. hostname.err
          5 kB

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.