[plug] connecting to windoze databases from linux
Leon Brooks
leon at brooks.fdns.net
Tue Sep 4 15:17:04 WST 2001
psteege at tpg.com.au wrote:
> I would like to know how to connect my linux system to a windoze
> machine and get data from a MS database, either by connecting to an
> Access database (*.mdb type), or by connecting to a running sql
> server 7.0.
> I am not totally familiar with ODBC yet, but is that one way to do it
> from Linux?
Yes. The best way for getting at Access databases is to feed them to an
MDB-to-SQL converter and then shoving the resulting SQL into a Linux SQL
database like PostgreSQL. If Access wants the data again, make it use an
ODBC driver and if possible limit it to R/O access.
More information about the plug
mailing list