[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