The Ultimate Guide to High Availability with MariaDB

Comments - CONNECT ODBC Table Type: Accessing Tables From Another DBMS

4 years ago Radim Machů
Connection to view in MS Access database returns Error: Unsupported SQL type -2

I run 10.4.12-MariaDB on Windows10 and I use 64-bit ODBC driver to connect tables from MS Access to MariaDB database.

Unfortunately, I am not able to connect view from mdb file.

Running such a query

CREATE TABLE <view_name> ENGINE=CONNECT table_type=ODBC
  block_size=10 tabname='view_name_in_mdb'  DATA_CHARSET = cp1250
   Connection='..connection_string..';

returns an error: Unsupported SQL type -2. As I expected, the same error is return when I tried to do some workaround and I added to previous connect a definition SRCDEF='select * from qAgSKzPoh'.

My question is: is there a possibility to make a connection to views stored in the mdb database?

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.