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 <login0...@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-ma...@lists.alioth.debian.org > http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-mysql-maint > -- Kind regards, Dieter Adriaenssens