Re: Interfacing from Apache to Access

2000-07-11 Thread Eric Strovink
Lorenzo Gordon wrote: Hello, I am a software developer for The London School of Hygiene Tropical Medicine, UK. My query is the following: I have been able to successfully run a Perl script from MS-DOS that would pull out the necessary info. from an Access database I wrote last year

Re: Interfacing from Apache to Access

2000-07-11 Thread David Mitchell
From: Eric Strovink [EMAIL PROTECTED] wrote: Write a simple socket interface to connect Apache Perl to your existing Windoze Perl script (which you'll hack to set up as a simple server). Invent your own protocol. Locking issues will come up, but you can manage this yourself with a little

Re: Interfacing from Apache to Access

2000-07-11 Thread Fabrice Scemama
DBD::Proxy does work the way you describe it. I've used it with succes to address MSSQL DBs. So far, with Access I met a few difficulties with memos (Access' BLOBs), but maybe I didn't find the way to do it. Fabrice David Mitchell wrote: From: Eric Strovink [EMAIL PROTECTED] wrote: Write

Re: Interfacing from Apache to Access

2000-07-11 Thread Mike Miller
On Tue, 11 Jul 2000 14:52:58 +0100 (BST), David Mitchell wrote: From: Eric Strovink [EMAIL PROTECTED] wrote: Write a simple socket interface to connect Apache Perl to your existing Windoze Perl script (which you'll hack to set up as a simple server). Invent your own protocol. Locking

Re: Interfacing from Apache to Access

2000-07-11 Thread rise
On Tue, 11 Jul 2000, Mike Miller wrote: Not good for heavy use, but for the 3-4 times a month it gets used in production, it works perfectly okay. There is one significant issue with using DBD::Proxy / DBI::ProxyServer on Windows: lack of fork. If you're going to be using it you probably want

Re: Interfacing from Apache to Access

2000-07-11 Thread Mike Miller
On Tue, 11 Jul 2000 15:10:25 -0600 (MDT), rise wrote: On Tue, 11 Jul 2000, Mike Miller wrote: Not good for heavy use, but for the 3-4 times a month it gets used in production, it works perfectly okay. There is one significant issue with using DBD::Proxy / DBI::ProxyServer on Windows: lack of

RE: Interfacing from Apache to Access

2000-07-10 Thread Geoffrey Young
look into DBI and DBD::ODBC on CPAN (http://www.perl.com/CPAN-local/modules/by-module/) from the DBI mailing list, I gather lots of folks use DBD::ODBC for perl-MSAccess connectivity... HTH --Geoff -Original Message- From: Lorenzo Gordon [mailto:[EMAIL PROTECTED]] Sent: Monday,

Re: Interfacing from Apache to Access

2000-07-10 Thread John D Groenveld
This question is better suited for the dbi-users mailing list. See http://www.symbolstone.org/technology/perl/DBI/ I've successfully used DBD::ODBC under Solaris to access Access via Openlink's middleware. http://www.openlinksw.com/ John [EMAIL PROTECTED]

Re: Interfacing from Apache to Access

2000-07-10 Thread Erich L. Markert
Look! It's a big orange burning circle in the sky... Run away, RUN AWAY If you have any say in things DO NOT implement a web interface to an access DB. Migrate the access DB to a true SQL server that won't suffer the many problems that access does. Geoffrey Young wrote: look into DBI