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, [email protected] 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-developers -- Sjoerd Mullender
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
