← Back to team overview

maria-discuss team mailing list archive

Re: Connect Engine with ODBC


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]

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.lefranc@xxxxxxxxxxx]
Sent: Thursday, 19 November 2015 6:59 PM
To: Bruce Carlson; maria-discuss@xxxxxxxxxxxxxxxxxxx
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.Carlson@xxxxxxxxxx<mailto:Bruce.Carlson@xxxxxxxxxx>> wrote:

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. 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@xxxxxxxxxxxxxxxxxxx<mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp
Guillaume Lefranc
Remote DBA Services Manager
MariaDB Corporation

JPEG image