From owner-freebsd-questions@FreeBSD.ORG Tue Nov 10 15:18:05 2009 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 00DC11065676 for ; Tue, 10 Nov 2009 15:18:05 +0000 (UTC) (envelope-from dan@dan.emsphone.com) Received: from email1.allantgroup.com (email1.emsphone.com [199.67.51.115]) by mx1.freebsd.org (Postfix) with ESMTP id B4C0A8FC1B for ; Tue, 10 Nov 2009 15:18:04 +0000 (UTC) Received: from dan.emsphone.com (dan.emsphone.com [199.67.51.101]) by email1.allantgroup.com (8.14.0/8.14.0) with ESMTP id nAAFI2Fw077888 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 10 Nov 2009 09:18:03 -0600 (CST) (envelope-from dan@dan.emsphone.com) Received: from dan.emsphone.com (smmsp@localhost [127.0.0.1]) by dan.emsphone.com (8.14.3/8.14.3) with ESMTP id nAAFI2Ht067282 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Tue, 10 Nov 2009 09:18:02 -0600 (CST) (envelope-from dan@dan.emsphone.com) Received: (from dan@localhost) by dan.emsphone.com (8.14.3/8.14.3/Submit) id nAAFI1hw067280; Tue, 10 Nov 2009 09:18:01 -0600 (CST) (envelope-from dan) Date: Tue, 10 Nov 2009 09:18:01 -0600 From: Dan Nelson To: Matthias Apitz Message-ID: <20091110151800.GG89052@dan.emsphone.com> References: <20091110150158.GA6500@current.Sisis.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20091110150158.GA6500@current.Sisis.de> X-OS: FreeBSD 7.2-STABLE User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: ClamAV version 0.94.1, clamav-milter version 0.94.1 on email1.allantgroup.com X-Virus-Status: Clean X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-2.0.2 (email1.allantgroup.com [199.67.51.78]); Tue, 10 Nov 2009 09:18:03 -0600 (CST) X-Scanned-By: MIMEDefang 2.45 Cc: freebsd-questions@freebsd.org Subject: Re: FreeBSD && remote MS ACCESS database X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 10 Nov 2009 15:18:05 -0000 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