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
