[debian-mysql] Bug#838578: mariadb-connect-engine-10.0: Unsupported table type ODBC

[Sam Yang]

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
     ineffective)?
	 
	 install package using apt-get install
	 mariadb-server
	 mariadb-connect-engine-10.0
     unixodbc
	 unixodbc-bin
	 unixodbc-dev
	 freetds-bin
	 freetds-common
	 freetds-dev

	 edit /etc/freetds/freetds.conf file
	 add 
	 [SQLSERVER]
	 	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"
	 1> 
	 type sql query also reutrn reslut
	 It seems connected.

	 edit /etc/odbcinst.ini
	 [FreeTDS]
	 Description = FreeTDS driver
	 Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
	 Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so

	 edit /etc/odbc.ini
	 [SQLSERVER]
	 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                                  |
	 |                                       |
	 +---------------------------------------+
	 SQL> 
	 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