[Monetdb-developers] ODBC call-failed

Sjoerd Mullender sjoerd at acm.org
Tue Feb 16 17:14:31 CET 2010


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 at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers


-- 
Sjoerd Mullender

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 371 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20100216/3c2eb151/attachment.sig>


More information about the developers-list mailing list