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 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, July 10, 2000 9:45 AM
> > To: modperl
> > Subject: Interfacing from Apache to Access
> >
> >
> > 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 (Access 97).
> >
> > The problem is that in order to get the script to talk to the
> > web pages i am currently designing, the script must run on
> > the School's network, which is a Unix Solaris machine running Apache.
> > Both the School's Web Administrator have been struggling (and
> > so far failing) to find an ODBC-like driver that will enable
> > Unix to talk to Access via my Perl script.
> >
> > The implications of not been able to create some connection
> > between these various componenets are massive.
> >
> > Any solutions/pointers/advice anyone might have would be
> > greatly appreciated. I can't believe I'm the first person to
> > have come across this problem!
> >
> >
> > Please respond either to [EMAIL PROTECTED] .
> >
> > TIA,
> >
> > Lorenzo Gordon.
> >
--
__________________________________________________________
Mr. Erich L. Markert [EMAIL PROTECTED]
Computer Learning Center TEL (914)422-4328
Pace University
1 Martine Ave
White Plains, New York 10606-1932
Those who do not understand Unix are condemned to reinvent it, poorly.
-- Henry Spencer