<div dir="ltr">Hi,<div><br></div><div>Are you trying to do something similar like described in <a href="https://mariadb.com/blog/getting-microsoft-sql-server-data-mariadb-connect-storage-engine">https://mariadb.com/blog/getting-microsoft-sql-server-data-mariadb-connect-storage-engine</a>?</div><div><br></div><div>Kind regards,</div><div>Dieter</div></div><div class="gmail_extra"><br><div class="gmail_quote">2016-09-22 17:34 GMT+02:00 Sam Yang <span dir="ltr"><<a href="mailto:login0307@gmail.com" target="_blank">login0307@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Package: mariadb-connect-engine-10.0<br>
Version: 10.0.27-0+deb8u1<br>
Severity: normal<br>
<br>
Dear Maintainer,<br>
<br>
*** Reporter, please consider answering these questions, where appropriate ***<br>
<br>
* What led up to the situation?<br>
After execute query in mariadb returns 'unsupported table type ODBC'<br>
Query: create table foo engine=CONNECT table_type=ODBC<br>
tabname='comCustomer' connection='DSC=SQLSERVER'<br>
<br>
* What exactly did you do (or not do) that was effective (or<br>
ineffective)?<br>
<br>
install package using apt-get install<br>
mariadb-server<br>
mariadb-connect-engine-10.0<br>
unixodbc<br>
unixodbc-bin<br>
unixodbc-dev<br>
freetds-bin<br>
freetds-common<br>
freetds-dev<br>
<br>
edit /etc/freetds/freetds.conf file<br>
add<br>
[SQLSERVER]<br>
host = <server_ip><br>
port = <server_port><br>
tds version = 7.3<br>
<br>
and execute connect query using tsql:<br>
<br>
$ tsql -S SQLSERVER -U <user><br>
returns below:<br>
Password: input <password><br>
returns below:<br>
locale is "en_US.utf8"<br>
locale charset is "UTF-8"<br>
using default charset "UTF-8"<br>
1><br>
type sql query also reutrn reslut<br>
It seems connected.<br>
<br>
edit /etc/odbcinst.ini<br>
[FreeTDS]<br>
Description = FreeTDS driver<br>
Driver = /usr/lib/x86_64-linux-gnu/<wbr>odbc/libtdsodbc.so<br>
Setup = /usr/lib/x86_64-linux-gnu/<wbr>odbc/libtdsS.so<br>
<br>
edit /etc/odbc.ini<br>
[SQLSERVER]<br>
Driver = FreeTDS<br>
Server = <server_ip><br>
Port = 1433<br>
Database = <database_name><br>
UID = <user><br>
Password = <password><br>
<br>
and excute connect query using isql:<br>
$ isql -v SQLSERVER <user> <password><br>
returns below:<br>
+-----------------------------<wbr>----------+<br>
| Connected! |<br>
| |<br>
| sql-statement |<br>
| help [tablename] |<br>
| quit |<br>
| |<br>
+-----------------------------<wbr>----------+<br>
SQL><br>
type sql query also return.<br>
<br>
login into mariadb console and type sql query to create table<br>
in order to connect foreigner sqlserver<br>
<br>
MariaDB [DBNAME]> create table comCustomer engine=CONNECT<br>
table_type=ODBC tabname='comCustomer' connection='DSN=SQLSERVER'<br>
<br>
return: ERROR 1105 (HY000): Unsupported table type ODBC<br>
<br>
* What was the outcome of this action?<br>
I cannot connect to sqlserver using mariadb-connect-engine-10.0<br>
<br>
* What outcome did you expect instead?<br>
Fix the problem manual or waitting the package update released.<br>
<br>
*** End of the template - remove these template lines ***<br>
<br>
<br>
-- System Information:<br>
Both are the same issue in (raspberrypi)<br>
Description: Raspbian GNU/Linux 8.0 (jessie)<br>
Release: 8.0<br>
Codename: jessie<br>
Linux raspberrypi 4.4.13-v7+ #894 SMP Mon Jun 13 13:13:27 BST 2016<br>
armv7l GNU/Linux<br>
<br>
and (normal pc)<br>
Debian Release: 8.5<br>
APT prefers stable<br>
APT policy: (500, 'stable')<br>
Architecture: amd64 (x86_64)<br>
Foreign Architectures: i386<br>
<br>
Kernel: Linux 3.16.0-4-amd64 (SMP w/4 CPU cores)<br>
Locale: LANG=en_US.utf8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)<br>
Shell: /bin/sh linked to /bin/dash<br>
Init: systemd (via /run/systemd/system)<br>
<br>
Versions of packages mariadb-connect-engine-10.0 depends on:<br>
ii libc6 2.19-18+deb8u4<br>
ii libstdc++6 4.9.2-10<br>
ii libxml2 2.9.1+dfsg1-5+deb8u2<br>
ii mariadb-server-10.0 10.0.27-0+deb8u1<br>
ii unixodbc 2.3.1-3<br>
ii zlib1g 1:1.2.8.dfsg-2+b1<br>
<br>
mariadb-connect-engine-10.0 recommends no packages.<br>
<br>
mariadb-connect-engine-10.0 suggests no packages.<br>
<br>
-- no debconf information<br>
<br>
______________________________<wbr>_________________<br>
pkg-mysql-maint mailing list<br>
<a href="mailto:pkg-mysql-maint@lists.alioth.debian.org">pkg-mysql-maint@lists.alioth.<wbr>debian.org</a><br>
<a href="http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint" rel="noreferrer" target="_blank">http://lists.alioth.debian.<wbr>org/cgi-bin/mailman/listinfo/<wbr>pkg-mysql-maint</a><br>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Kind regards,<br><br>Dieter Adriaenssens</div>
</div>