Date: Tue, 10 Nov 2009 09:18:01 -0600 From: Dan Nelson <dnelson@allantgroup.com> To: Matthias Apitz <guru@unixarea.de> Cc: freebsd-questions@freebsd.org Subject: Re: FreeBSD && remote MS ACCESS database Message-ID: <20091110151800.GG89052@dan.emsphone.com> In-Reply-To: <20091110150158.GA6500@current.Sisis.de> References: <20091110150158.GA6500@current.Sisis.de>
next in thread | previous in thread | raw e-mail | index | archive | help
In the last episode (Nov 10), Matthias Apitz said: > Is there any chance to read and update a remote MS ACCSESS database from > FreeBSD 8-CURRENT, via ODBC? Thanks in advance With samba, wine, and a local install of Office, sure. ODBC is a programming API, not a networking protocol, so you need direct access to the .mdb file. MS Access is the only thing that can read .mdb files, so that's why you need wine and a local Office install. If you really need remote access to the data, move the tables into a client-server database (mysql, postgres, etc) so you can get to them directly from Unix, and use linked tables in your .mdb file so Access itself will still work. -- Dan Nelson dnelson@allantgroup.com
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20091110151800.GG89052>