It seems MS Access does a query like SELECT "sys"."tables"."id" FROM "sys"."tables" this is not supported by MonetDB. Both of the following queries do work: SELECT "tables"."id" FROM "sys"."tables" SELECT "id" FROM "sys"."tables" I have no idea how to get around this in MS Access. Before trying this out I had never used MS Access. I guess supporting the three levels should be put on our wish list. On 2010-02-16 13:46, filippo.zonta@it.abb.com wrote:
Hello,
I installed the ODBC driver for windows32 (MonetDB-ODBC-Installer-i386-20100112.msi) and configured an ODBC data source linked to 'demo' database, but using the connection in MS Access I obtain an error
ODBC CONFIGURATION
DB SERVER WINDOWS RUNNING
MS ACCESS LINK TABLE : ONLY 1 TABLE IS LISTED
Using the same connection in Excel instead, the odbc driver works:
Let me know if the ODBC driver doesn't support MS Access table links. Thanks Best Regards
Filippo
Il Gruppo ABB in Italia ha adottato il Modello Organizzativo ai sensi del D.Lgs. 231/2001, in forza del quale l'assunzione di obbligazioni da parte di societa' ABB avviene a firma congiunta di due procuratori muniti di idonei poteri, con la sola eccezione delle persone che rivestono la carica di Amministratore Delegato o di Direttore Generale.Le informazioni contenute in questo messaggio di posta elettronica sono riservate e confidenziali e ne e' vietata la diffusione in qualunque modo eseguita.Qualora Lei non fosse la persona cui il presente messaggio e' destinato, e' invitata a non diffonderlo, e ad eliminarlo, dandone gentilmente comunicazione al mittente.ABB Group in Italy adopts a Compliance Programme under the Italian Law (D.Lgs.231/2001). According to this ABB Compliance Programme, any commitment of ABB Italian Companies is taken by the double signature of ABB Representatives granted by a proper Power of Attorney with the only exception of Managing Director or General Manager.The information included in this e-mail and any attachments are confidential and may also be privileged. If you are not the correct recipient, you are kindly requested to notify the sender immediately, to cancel it and not to disclose the contents to any other person.
------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Sjoerd Mullender