Hi Guillaume, Yes my apology, it’s version 10.1.7 Sorry a typo.
Bruce Carlson Front End Systems Administrator / Developer Nepean Building and Infrastructure [Description: Description: Description: NepeanLogo_bw] bruce.carl...@nepean.com<mailto:bruce.carl...@nepean.com> 117 - 153 Rookwood Road (PO Box 57) Yagoona NSW 2199 Australia Phone: +61 2 9707 5000 Fax: +61 2 9769 1744 Mobile: +61 (0) 447 744 172 Website: www.nepean.com<http://www.nepean.com/> From: Guillaume Lefranc [mailto:guillaume.lefr...@mariadb.com] Sent: Thursday, 19 November 2015 6:59 PM To: Bruce Carlson; maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] Connect Engine with ODBC Hi Bruce, There is no 10.1.17 version of MariaDB. You might be getting confused... Either you have 10.0.17 installed, or 10.1.7. Could you make sure of that? On Thu, Nov 19, 2015 at 1:04 AM Bruce Carlson <bruce.carl...@nepean.com<mailto:bruce.carl...@nepean.com>> wrote: Hi, I’ve been experimenting with the new Connect engine and the ODBC table type. I’ve installed MariaDB 10.1.17 on a test machine. I have an ODBC diver connected to a C-ISAM database. I am able to use this ODBC to connect from a MS Access 2013 database and despite some restrictions related to the C-ISAM DB it works well I have also been able to connect successfully from MariaDB and create connect tables. The only issue I’m having with the ODBC table type is the lack of indexes. However, I have noticed that in the MariaDB documentation accessible from https://mariadb.com/kb/en/mariadb/connect-table-types-odbc-table-type-accessing-tables-from-other-dbms/ there is a note :- “Version 1.04 (from MariaDB 10.1.6<https://mariadb.com/kb/en/mariadb-1016-release-notes/>) adds remote indexing facility to the ODBC table type.” As I’ve now installed 10.1.17 on my test machine, would someone be able to provide more information on the status of remote indexing, how it works and on how I may be able to make use of this? I am using HeidiSQL (Vers. 9.1.0.4867) as a front end tool and when I try to create indexes for the connect tables I get a message “SQL Error (1105): Table type ODBC is not indexable”. Kind Regards, Bruce Carlson _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net<mailto:maria-discuss@lists.launchpad.net> Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp -- Guillaume Lefranc Remote DBA Services Manager MariaDB Corporation
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
