Morning everyone, I was hoping to use mdbtools to extract data from some Access databases overnight. I have yum installed the tools from Dag and also downloaded and (eventually!) compiled the latest release from the mdbtools web site, but I either get 'buffer overflow' errors or no output from most of the tools. I have been trying to cvs checkout the latest development version but sourceforge's cvs login keeps timing out. Is anyone hereabouts using mdbtools successfully, or can anyone suggest any other tools that will dump access databases on a scheduled basis? I have done test migrations using the MySQL gui tools and that works fine, but I don't think the operation can be scripted. On a side note, I also need to do the same for MS-SQL data - does anyone have any favourite tools for automating data extraction? Everything ultimately needs to end up in a MySQL database Any advice appreciated. Thanks Nigel Kendrick -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20080620/a2e6800f/attachment-0002.html>
> From: centos-bounces at centos.org [mailto:centos-bounces at centos.org] OnBehalf Of Nigel Kendrick > Sent: Friday, June 20, 2008 9:25 AM > To: 'CentOS mailing list' > Subject: [CentOS] mdbtools on CentOS > > Morning everyone,> > I was hoping to use mdbtools to extract data from some Access databasesovernight. I have yum installed the tools from Dag and also downloaded and (eventually!) compiled the latest> release from the mdbtools web site, but I either get 'buffer overflow'errors or no output from most of the tools. I have been trying to cvs checkout the latest development version but> sourceforge's cvs login keeps timing out. >[Snip] OK - managed to login to CVS at last and download the latest development version. A straight configure/make created tools that ran, but generated no output. I re-did the configure with some suggested options (below) and it works!!! ./configure --enable-sql --with-unixodbc=/usr/local It seems these options are needed even though I am accessing the mdb file directly off disk and not via odbc or SQL Thanks to all who were just about to chip in with suggestions ;-) -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.centos.org/pipermail/centos/attachments/20080620/484634bd/attachment-0002.html>