-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 22-10-2014 12:15, ksotiris wrote: > > Τη Δευτέρα, 20 Οκτωβρίου 2014 8:56:24 μ.μ. UTC+3, ο χρήστης Leonel Câmara > έγραψε: > > Either way, just convert your access database to anything else, it's bound > to be better for your sanity. Seriously, any time spent migrating is > better > spent than making access work with web2py. > > yes I know access mdb is an awfull db. But is used by another old vb program > and > we need to reed this db too. Is very dificult to change the old program. > > We try also the dobtp (http://odbtp.sourceforge.net, > https://github.com/msaavedra/python-odbtp) but we get more problems with the > connection (maybe the Access version is a problem -- ""Remember SQL used by > Access isn't the same as ANSI SQL - and compatibility varies by Access > version.""). > > Finally we will continue using mdptools/executesql making basic queries and > nothing else.... >
Yes, follow Leonel's advice, and profit from the problem by converting it to *anything else* (though I would suggest PostgreSQL). Here is how to do it for PG: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Microsoft_Access - -- Com os melhores cumprimentos, Carlos Correia ========================= MEMÓRIA PERSISTENTE Tel.: 219 291 591 - GSM: 917 157 146 / 967 511 762 e-mail: ge...@memoriapersistente.pt - URL: http://www.memoriapersistente.pt Jabber: m...@jabber.org GnuPG: wwwkeys.eu.pgp.net URL Suporte: https://t5.m16e.com/gps -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlRHmuEACgkQ90uzwjA1SJVlPACfeAbBtkAcKb2yAOcf71h4wKhd 4HQAn0xYZYd2zms1VvfpBOoikYtzhzWw =F7m3 -----END PGP SIGNATURE----- -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
