Re: [CentOS] Using an MS Access database from CentOS release 5.7 (Final)
On Wed, Dec 14, 2011 at 3:21 PM, Ron Young ronyo...@nc.rr.com wrote: @Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business. Does anyone have experience doing so? I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x. Is there another way to get read and write access to the mdb file from apache/php running from the linux box? A couple of hours of googling last night has resulted in finding very expensive odbc drivers for the linux box and nothing really foss except the odbc driver managers. The best approach to doing this is to convert the access tables to use a sql server instead of the native mdb. This may or may not be practical/easy, but access can work over ODBC with the db on linux/postgresql (among others) where you would have a matching php client.Next best would be to write something to give web server access to the data you need on the windows box, and access it remote via http. -- Les Mikesell lesmikes...@gmail.com ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Using an MS Access database from CentOS release 5.7 (Final)
Try the Sybase driver. I can connect Perl to Microsoft SQL Server using Sybase drivers it so might work with Access. Parts of this might be useful: http://www.peceny.de/misc/freetds.html --Russell -Original Message- From: centos-boun...@centos.org [mailto:centos-boun...@centos.org] On Behalf Of Les Mikesell Sent: Thursday, 15 December 2011 10:58 a.m. To: CentOS mailing list Subject: Re: [CentOS] Using an MS Access database from CentOS release 5.7 (Final) On Wed, Dec 14, 2011 at 3:21 PM, Ron Young ronyo...@nc.rr.com wrote: @Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business. Does anyone have experience doing so? I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x. Is there another way to get read and write access to the mdb file from apache/php running from the linux box? A couple of hours of googling last night has resulted in finding very expensive odbc drivers for the linux box and nothing really foss except the odbc driver managers. The best approach to doing this is to convert the access tables to use a sql server instead of the native mdb. This may or may not be practical/easy, but access can work over ODBC with the db on linux/postgresql (among others) where you would have a matching php client.Next best would be to write something to give web server access to the data you need on the windows box, and access it remote via http. -- Les Mikesell lesmikes...@gmail.com ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos === Attention: The information contained in this message and/or attachments from AgResearch Limited is intended only for the persons or entities to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipients is prohibited by AgResearch Limited. If you have received this message in error, please notify the sender immediately. === ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Using an MS Access database from CentOS release 5.7 (Final)
On 12/14/11 6:05 PM, Smithies, Russell wrote: I can connect Perl to Microsoft SQL Server using Sybase drivers it so might work with Access. Parts of this might be useful:http://www.peceny.de/misc/freetds.html Access native databases use the 'Jet' database engine, and they are files accessed over SMB/CIFS, not proper client-server like a 'real' database engine. This is going to be painful no matter how you do it. -- john r pierceN 37, W 122 santa cruz ca mid-left coast ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Using an MS Access database from CentOS release 5.7 (Final)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ron Young said the following on 14/12/11 22:21: @Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business. Does anyone have experience doing so? I had to import some customer's data from an Access application for a new (PHP) version of that application I wrote. I used mdbtools http://mdbtools.sourceforge.net/ I scripted the conversion this way: mdb-export -I -S -X -DF accessfile.mdb accesstablename | sed 's/accesstablename/sqltablename/g' | sed 's/$/;/g' /tmp/aaa cat header.sql /tmp/aaa import.sql mysql --user=user --password=password import.sql header.sql file contains just this line: use database; Ciao, luigi - -- / +--[Luigi Rosa]-- \ It is not the strongest of the species that survives, nor the most intelligent, but the one most responsive to change. --Charles Darwin -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk7pe24ACgkQ3kWu7Tfl6ZRCswCgxwgjhEYh8mzVwpXMxjS2g3QF 8yUAoI1BDogfHFCfrMPNzzK+Pe/faQxC =rC14 -END PGP SIGNATURE- ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
Re: [CentOS] Using an MS Access database from CentOS release 5.7 (Final)
On 12/15/2011 05:45 AM, Luigi Rosa wrote: I used mdbtools http://mdbtools.sourceforge.net/ This is also found in the epel repository. Mogens -- Mogens Kjaer, m...@lemo.dk http://www.lemo.dk ___ CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
