python + access + odbc + linux

[Philippe Martin]

Hi,

I understand that access can be accessed through an ODBC driver under
windows (instead of Jet).

I am wondering if the same can be done under Linux.

Regards,

Philippe

 

[Felipe Almeida Lessa]

Em Seg, 2006-04-10 às 10:38 -0500, Philippe Martin escreveu:

I understand that access can be accessed through an ODBC driver under
windows (instead of Jet).

I am wondering if the same can be done under Linux.

As far as I know, no. But there is that http://mdbtools.sourceforge.net/
that may help you, but when I tried I had limited success.

Cheers,

 

[Philippe Martin]

Thanks a lot Felipe.

Regards,


Philippe

Em Seg, 2006-04-10 às 10:38 -0500, Philippe Martin escreveu:

As far as I know, no. But there is that http://mdbtools.sourceforge.net/
that may help you, but when I tried I had limited success.

Cheers,

 

[Dennis Lee Bieber]

Hi,

I understand that access can be accessed through an ODBC driver under
windows (instead of Jet).

Technically, you would be using JET without Access... Access is a
GUI report/form creation tool whose native RDBM is JET (unless you are
using "access data projects" which use M$ SQL Server as the RDBM).

And ODBC would be used on JET in place of DAO or ADO.

I am wondering if the same can be done under Linux.

That, I can't help with... A generic ODBC adapter doesn't care about
the database at the other end -- it is the (Windows) DSN definition that
links the name to the backend driver, and I don't know if those can go
from Linux to a Windows machine to activate JET...

If you mean: can you copy an MDB file to a Linux box, and use ODBC
to access it -- I suspect "NO".
--