Package: mariadb-connect-engine-10.0
Version: 10.0.27-0+deb8u1
Severity: normal

Dear Maintainer,

*** Reporter, please consider answering these questions, where appropriate ***

   * What led up to the situation?
   After execute query in mariadb returns 'unsupported table type ODBC'
   Query: create table foo engine=CONNECT table_type=ODBC
   tabname='comCustomer' connection='DSC=SQLSERVER'
   * What exactly did you do (or not do) that was effective (or
         install package using apt-get install

         edit /etc/freetds/freetds.conf file
                host = <server_ip>
                port = <server_port>
                tds version = 7.3

         and execute connect query using tsql:

         $ tsql -S SQLSERVER -U <user> 
         returns below:
         Password: input <password> 
         returns below:
         locale is "en_US.utf8"
         locale charset is "UTF-8"
         using default charset "UTF-8"
         type sql query also reutrn reslut
         It seems connected.

         edit /etc/odbcinst.ini
         Description = FreeTDS driver
         Driver = /usr/lib/x86_64-linux-gnu/odbc/
         Setup = /usr/lib/x86_64-linux-gnu/odbc/

         edit /etc/odbc.ini
         Driver = FreeTDS
         Server = <server_ip>
         Port = 1433
         Database = <database_name>
         UID = <user>
         Password = <password>

         and excute connect query using isql:
         $ isql -v SQLSERVER <user> <password>
         returns below:
         | Connected!                            |
         |                                       |
         | sql-statement                         |
         | help [tablename]                      |
         | quit                                  |
         |                                       |
         type sql query also return.

         login into mariadb console and type sql query to create table
         in order to connect foreigner sqlserver

         MariaDB [DBNAME]> create table comCustomer engine=CONNECT
         table_type=ODBC tabname='comCustomer' connection='DSN=SQLSERVER'
         return: ERROR 1105 (HY000): Unsupported table type ODBC

   * What was the outcome of this action?
     I cannot connect to sqlserver using mariadb-connect-engine-10.0

   * What outcome did you expect instead?
     Fix the problem manual or waitting the package update released.

*** End of the template - remove these template lines ***

-- System Information:
Both are the same issue in (raspberrypi)
Description:    Raspbian GNU/Linux 8.0 (jessie)
Release:        8.0
Codename:       jessie
Linux raspberrypi 4.4.13-v7+ #894 SMP Mon Jun 13 13:13:27 BST 2016
armv7l GNU/Linux

and (normal pc)
Debian Release: 8.5
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.16.0-4-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-connect-engine-10.0 depends on:
ii  libc6                2.19-18+deb8u4
ii  libstdc++6           4.9.2-10
ii  libxml2              2.9.1+dfsg1-5+deb8u2
ii  mariadb-server-10.0  10.0.27-0+deb8u1
ii  unixodbc             2.3.1-3
ii  zlib1g               1:1.2.8.dfsg-2+b1

mariadb-connect-engine-10.0 recommends no packages.

mariadb-connect-engine-10.0 suggests no packages.

-- no debconf information

Reply via email to