M
Milca
Hi all,
I'm a (or "one more") newcomer in Perl, and ask for very basic help.
Despite some time spent to read all this forum and some CPAN docs, I've
not found a simple explanation of my request however simple.
I'd like to access - read only is sufficient for the beginning - to an
MS ACCESS database from perls scripts. I'm on Win 2K.I'd like to make
simple SQL or SQL-like queries (is that a pure dream ?) :seeing my
tables, seeing the data of each table, bing able to select elementary
data in tables, and even not necessarily with joining them. ... Truly a
"basic access to ACCESS" !
.... And (to be complete) I would like to use these perl scripts from
"unix style" command lines inside a "cygnus" bash shell ... But this
detail is probably useless.
Well, I spent some time trying to configure an ODBC driver found into
the admin tools of Windows. I have "declared" a specific ".mdb" file as
ODBC souce. I have used another tool (WinBatch) which can has sample
scripts for ODBC use and which can normally detect ODBC sources.
This script correctly sees my file as ODBC proposed source. But cannot
access to it. That's why I would like to make this access from Perl scripts.
I have no "SQL server" neither "anything else server" running on my
machine. Should I ? Should I use Win32::OLE ? DBD ? DBI ? ODBC ? or
maybe SHXK::-[~#GMKX ?
What is all the stuff to install / configure / run to finally get this
simple result : simply querying a simple database ?
TIA,
Micla.
I'm a (or "one more") newcomer in Perl, and ask for very basic help.
Despite some time spent to read all this forum and some CPAN docs, I've
not found a simple explanation of my request however simple.
I'd like to access - read only is sufficient for the beginning - to an
MS ACCESS database from perls scripts. I'm on Win 2K.I'd like to make
simple SQL or SQL-like queries (is that a pure dream ?) :seeing my
tables, seeing the data of each table, bing able to select elementary
data in tables, and even not necessarily with joining them. ... Truly a
"basic access to ACCESS" !
.... And (to be complete) I would like to use these perl scripts from
"unix style" command lines inside a "cygnus" bash shell ... But this
detail is probably useless.
Well, I spent some time trying to configure an ODBC driver found into
the admin tools of Windows. I have "declared" a specific ".mdb" file as
ODBC souce. I have used another tool (WinBatch) which can has sample
scripts for ODBC use and which can normally detect ODBC sources.
This script correctly sees my file as ODBC proposed source. But cannot
access to it. That's why I would like to make this access from Perl scripts.
I have no "SQL server" neither "anything else server" running on my
machine. Should I ? Should I use Win32::OLE ? DBD ? DBI ? ODBC ? or
maybe SHXK::-[~#GMKX ?
What is all the stuff to install / configure / run to finally get this
simple result : simply querying a simple database ?
TIA,
Micla.