ant has asked for the wisdom of the Perl Monks concerning the following question:
Hi,
I am planning on connecting to a microsoft access database sitting on an
nt server (with activestate perl installed) accross a network from a unix box.
I have installed the Perl Modules and configured the ODBC settings as discussed
in 'Programming the Perl DBI', and I am confident that I will be able to connect to
the database.
My problem is actually querying the data on the the database. Do I issue the queries
in SQL as part of the database handle.
If there are already MIcrosoft Access queries on the database can these be fired from
the Perl script and the results returned?
Many thanks in advance to any answers or information returned.
Ant
I am planning on connecting to a microsoft access database sitting on an
nt server (with activestate perl installed) accross a network from a unix box.
I have installed the Perl Modules and configured the ODBC settings as discussed
in 'Programming the Perl DBI', and I am confident that I will be able to connect to
the database.
My problem is actually querying the data on the the database. Do I issue the queries
in SQL as part of the database handle.
If there are already MIcrosoft Access queries on the database can these be fired from
the Perl script and the results returned?
Many thanks in advance to any answers or information returned.
Ant
|
---|
Replies are listed 'Best First'. | |
---|---|
RE: Accessing Microsoft Access Databases
by mdillon (Priest) on Nov 09, 2000 at 22:12 UTC | |
Re: Accessing Microsoft Access Databases
by Fastolfe (Vicar) on Nov 09, 2000 at 21:00 UTC | |
RE: Accessing Microsoft Access Databases
by ant (Scribe) on Nov 10, 2000 at 16:00 UTC | |
Re: Accessing Microsoft Access Databases
by ashok (Sexton) on Nov 10, 2000 at 00:39 UTC | |
by myocom (Deacon) on Nov 10, 2000 at 00:41 UTC |
Back to
Seekers of Perl Wisdom