Access is a pc database. It doesn't run on unix. Why people insist on beating their heads against the wall in this manner I will never know. Ignorance I suppose. The alternative is to have your friend use a relational database and have a few simple forms that will allow him to insert/update/delete. Best of both worlds, and the open source/free databases mysql/postgresql are used on thousands of websites every day.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, August 24, 2003 11:55 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: [PHP] Reading an MS Access Database file on *NIX platform using PHP I'm building a small web application for a friend using PHP. He'd like to use MS Access to keep the data in, and update the data on the site by FTP'ing Access files he edits on his machine up to the web host. The web host is unix-based (FreeBSD, slightly hacked by Verio, I believe), so this means COM functions aren't available. ODBC was my next thought, but I've never used it, and there are a few things I don't understand. Setting up a DSN is one of them -- apparently this isn't as simple as constructing a string, and all the tutorials I can find seem to involve going into a Windows control panel and making a setting. This of course will not be possible, since there are no windows control panels on FreeBSD. In short: can anyone offer any quick tips on how to use the odbc database functions or PEAR::DB to query data from an MS Access file sitting on a UNIX box? Thanks, Weston -- 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