On October 17th, Daniel Rozengurtel asked:
> My friend is planing to write an application which will need to
> have a small
> DataBase access. I suppose its going to be either Access or Excell. Can
> anybody suggest of any DBI/DBD modules/pre-installs that he could use for
> this purpose.
Use will need DBI and DBD::ODBC to access Access databases. Save your Access
.mdb on your hard drive somewhere, go:
Start>Settings>Control Panel>Administative Tools>Data Sources (ODBC)
[on a Windows2000 machine]
and set up your database as:
System DNS>Add>Microsoft Access Drive (*.mdb)
set the Data Source Name (DSN) as the name you want to use in your Perl
script, and 'select' the Access mdb. Then use the following in your Perl
code:
use DBI;
$dbh=DBI->connect("dbi:ODBC:DNS_Name","","",{RaiseError=>1, PrintError=>1,
AutoCommit=>1}) || die ("Unable to access database: ".$DBI::errstr."\n");
and you should be to use the Access database as a standard DBI database.
I've
never tried Excel myself, but the setup (if it is supported by Excel) should
be familar.
Richy C.
[speaking personally]
--
Richard Chiswell, Systems Developer.
Cradley Print Group.
All opinions and comments expressed are NOT necessarily those of
Cradley Print.
--
The information contained within this e-mail sent by Cradley Print Ltd. is
confidential and is intended for the named recipient only. If you are not
the intended recipient please notify us by telephone immediately on 01384
414100 (UK)or +(44)1384 414100 (International) or return it to us by e-mail
quoting the name of the sender and the addressee. Please then delete it from
your system.
Encryption and Viruses
==================
Please note that this e-mail and any attachments have not been encrypted.
They may therefore be liable to be compromised. Please also note that it is
your responsibility to scan this e-mail and any attachments for viruses.
Viruses and compromises of security are inherent risks in relation to
e-mail.
We do not, to the extent permitted by law, accept any liability (whether in
contract, negligence or otherwise) for any virus infection and/or external
compromise of security and/or confidentiality in relation to transmissions
sent by e-mail.
Contracts
========
Please note, that contracts may NOT be concluded on behalf of Cradley Print
Ltd by e-mail, but contracts on behalf of our clients may be concluded by
e-mail.
