Hi Tim ODBTP is a solution that provides full support for MS Access from any platform. Not only does it provide write access and complete SQL suppot for MS Access databases, but it also can easily run stored queries using prepared statements. It also is the best Open Source solution for connecting to MS SQL Server, Visual Foxpro and any other Win32 ODBC accessible database from UNIX/Linux platforms. This is the good news.
The bad news is that the only supported scripting langaage is PHP. This is because I do not have the knowledge nor the time to write a DBD::ODBTP driver with the ODBTP client C library. Requests have been made for this, but since I am not a user of Perl, there is no immediate plan to fulfill them. The C library is wwll documented, and I would not mind helping someone create a DBD::ODBTP driver. Details about ODBTP can be found at http://odbtp.sourceforge.net -- bob On Sun, 1 Feb 2004, Tim Bunce wrote: > Did anything come of this? > > Has anyone tried using DBD::ODBC with the mdbtools ODBC driver to > access an Access .mdb file[*](possibly networked via Samba etc etc)? > > Tim. > > [*] Of course it's really a 'Jet' database engine file, and Jet is > also used in MS Money, Project, IIS, and Exchange etc. > > On Wed, Jun 26, 2002 at 01:05:44AM +0100, Tim Bunce wrote: > > I was simply expressing a preference that if there was to be > > "AnyData::Format::Access.pm using mdbtools" > > then I'd rather there was > > "DBD::Access using mdbtools" > > > > Since I've not looked at mdbtools I can't really comment much more than that. > > > > I saw Brian Bruns (the developer) mention that mdbtools includes a > > (buggy) ODBC driver. So long as it's functional enough now to do > > simple selects then that's probably the best way to go - using > > DBD::ODBC. > > > > Tim. > > > > On Tue, Jun 25, 2002 at 04:11:09PM -0700, Tim Harsch wrote: > > > Forgive my naivity (or just flawed understanding) but how would one go > > > about creating a DBD::Access? For instance DBD::Oracle is built on OCI, > > > does Access have a similar network protocol? I thought that ODBC was > > > about the only MS supported method of communicating to it... > > > > > > > -----Original Message----- > > > > From: Tim Bunce [mailto:[EMAIL PROTECTED] > > > > Sent: Tuesday, June 25, 2002 2:18 PM > > > > To: Jeff Zucker > > > > Cc: Orlando Andico; DBI-Users; dbi-dev; [EMAIL PROTECTED] > > > > Subject: Re: MS Access > > > > > > > > > > > > On Tue, Jun 25, 2002 at 10:27:20AM -0700, Jeff Zucker wrote: > > > > > Orlando Andico wrote: > > > > > > > > > > > It IS possible to read MSAccess files on a Linux box. > > > > > > http://mdbtools.sourceforge.net/ > > > > > > > > > > > > > > > Hmm, I had no idea that was available, forget my advice > > > > about saving the > > > > > Access files as CSV. > > > > > > > > > > At first glance it looks like it would be trivial to build an > > > > > AnyData::Format::Access.pm using mdbtools which would then provide > > > > > direct DBI interface to the MDB files. If anyone is > > > > interested in doing > > > > > this, let me know and I'll help. > > > > > > > > I'd rather someone did a DBD::Access. > > > > > > > > Tim. > > > > > > > >
