Have you checked out FreeTDS? We use FreeTDS to connect PHP on Linux to SQL Server 2000. Best of luck. Nate Tobik (412)661-5700 x206 VigilantMinds -----Original Message----- From: tg-php@xxxxxxxxxxxxxxxxxxxxxx [mailto:tg-php@xxxxxxxxxxxxxxxxxxxxxx] Sent: Wednesday, August 03, 2005 10:47 AM To: php-general@xxxxxxxxxxxxx Cc: davidwills@xxxxxxx Subject: Re: Access and PHP Just looked into this recently and here's a brief rundown of what I've found: 1. If you run PHP on a non-Windows system, your only option seems to be making a connection to a remote ODBC data source (hosted on a Windows machine presumably). There was something..err.. ODBTP (?) that would work on linux to connect to remote ODBC connections If you run PHP on a Windows server, then you have the following options: 2. ODBC connection via DSN 3. DSNLess connection (you can do this with a DB abstraction layer like ADODB) 4. COM connection (requires Access be installed on the server and, in my opinion, is the worst solution out of the group due to it's resource use) There doesn't appear to be a good direct way to read Access files on a linux machine. I may have come across a commercial Access driver ($$$) for linux, but can't remember. If I did, I would have dismissed it fairly quickly as 'free' is more my budget right now :) If you need links to the stuff above, let me know and I'll try to dig up some. I also have a script I wrote using WinBinder and ADODB on a Windows box to hit an Access database, pull data, scrub it, then insert it into a MySQL database via ODBC. -TG = = = Original message = = = I am looking for some resources to use my Access Databases with PHP, anyone have a good link? David ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
