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

[Dieter Adriaenssens]

Hi,

Are you trying to do something similar like described in
https://mariadb.com/blog/getting-microsoft-sql-server-data-mariadb-connect-storage-engine
?

Kind regards,
Dieter

2016-09-22 17:34 GMT+02:00 Sam Yang <login0307 at gmail.com>:

> 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
>
> _______________________________________________
> pkg-mysql-maint mailing list
> pkg-mysql-maint at lists.alioth.debian.org
> http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint
>



-- 
Kind regards,

Dieter Adriaenssens
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20160929/1e31d586/attachment.html>