As a perl-dbi beginner I'm extremely interested to access MS-Access db
by means of perl on a linux box.
The 'context' is as follows:
1) Windows NT LAN to which my Win NT desktop (the one I have *.mdb files on) is
connected;
2) A linux portable PC connected to the same NT LAN (SAMBA)
My question is:
Is it possible to access an *.mdb file somewhere in the LAN by means of my linux box
through perl & DBD-ODBC as briefly explained below?
And, if yes, could you please give me the detail of this connection?
Ciao
Vittorio
Richard Chiswell [dbi-users] <17/10/01 15:31 +0100>:
> 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.
