D Stocks wrote:[color=blue]
> Is it possible to have web page hosted by Linux/Apache retrieve data
> from (and insert data to) an MS Access database that resides on an
> (Internet-accessible) MS-based machine? Must the MS machine be running
> MS ISS? I currently use Perl to process scripts (no database linkage)
> but would likely switch to PHP for database interactions.[/color]
Perl has the DBI module that will allow you to work with Access databases
but you wouldn't want that Access database (presumably on a MS OS box) accessible from the
'net. You'd want to control all access to the data store through apache/linux.
The linux/apache box could talk to the MS OS box via Proxy:
http://www.perldoc.com/perl5.6.1/lib/DBD/Proxy.html
Here's one that directly addresses what I think you want to do:
http://www.unix.org.ua/orelly/linux/dbi/ch08_02.htm
More directly:
Yes, an Apache/Linux web server can retrieve and insert to Access database on MS-based
machinge.
No, the MS machine does not need to be running IIS.
I'm not aware of a PHP solution but I'm sure one exists; someone more knowledgeable about
PHP could provide details.
--
'---------------
'John Mishefske
'---------------
