Here is a simple example using an mdb file and DSN-Less connection:
#!perl
# vim:ts=4:sw=4:ai:aw:
use strict;
use DBI;
# Simple connect and select script using DSN-Less ADO connection.
my $dsn =
q{dbi:ADO:Provider=Microsoft.Jet.OLEDB.4.0; Data Source=.\mytest.mdb};
# User and Password not needed.
my $user = undef;
my $pass = undef;
# Connect to the database.
my $dbh = DBI->connect( $dsn, $user, $pass,
{PrintError=>1,RaiseError=>1} ) or die $DBI::errstr;
my $sql = q{select * from tst};
my $sth = $dbh->prepare( $sql );
$sth->execute;
print "DBD::ADO::VERSION $DBD::ADO::VERSION\n";
# Fetch each row as an array reference. Dereference later.
while( my $row = $sth->fetchrow_arrayref ) {
print join( ", ", map { $_ ? $_ : 'undef' } @$row, "\n");
}
$dbh->disconnect if $dbh;
exit;
__END__
On Mon, Oct 29, 2001 at 07:04:24PM +0530, Veeraraju_Mareddi wrote:
> Any Docs with Examples..Please.......
>
> Thanks
>
> With Warm Regards
> Raju
>
> ----------
> From: Curtis, Graeme A [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, October 29, 2001 5:43 PM
> To: 'Veeraraju_Mareddi'
> Subject: RE: Can we Access MDB database file in PERL ,Any Modules
> On that? ?
>
> use Win32::ODBC
>
> -----Original Message-----
> From: Veeraraju_Mareddi [mailto:[EMAIL PROTECTED]]
> Sent: 29 October 2001 12:04
> To: '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: Can we Access MDB database file in PERL ,Any Modules On
> that??
>
>
> Dear All
>
> Is there any way that I can work with *.mdb files, Like opening
> ,Querying
> ,Modifying Fields..
>
> Please Help if you have any Idea
>
> Thanks
>
> With Warm Regards
> Raju
>
>
>
> _______________________________________________
> Perl-Win32-Admin mailing list
> [EMAIL PROTECTED]
> http://listserv.ActiveState.com/mailman/listinfo/perl-win32-admin
>
>
>
> ****************************************************************************
> ******
> The information in this e-mail is confidential and may be legally
> privileged. It is intended solely for the addressee and access to this
> e-mail by anyone else is unauthorised.
>
> If you are not the intended recipient, any disclosure, copying,
> distribution or any action taken or omitted to be taken in reliance on it is
> prohibited and may be unlawful.
>
> At present the integrity of e-mail across the Internet cannot be
> guaranteed and messages sent via this medium are potentially at risk.
> Therefore we will not accept liability for any claims arising as a result of
> the use of this medium to transmit messages by or to Scottish Life.
>
> All incoming and outgoing e-mail communications are scanned
> automatically by software designed to quarantine e-mails containing material
> which is in contravention of our Company e-mail usage policy.
>
> The Royal London Mutual Insurance Society Limited for life and
> pension products
> Registered in England No. 99064. Regulated by the Financial
> Services Authority
> Registered Office: Royal London House, Middleborough, Colchester,
> Essex, C01 1PP
>
> Royal London Asset Management Limited for investment management
> services
> Registered in England No. 2244297. Regulated by the Financial
> Services Authority
> Registered Office: 55 Gracechurch Street, London, EC3V 0UF
>
> Royal London Savings Limited for Individual Savings Accounts
> Registered in England No. 3642633. Regulated by the Financial
> Services Authority
> Registered Office: Royal London House, Middleborough, Colchester,
> Essex, C01 1PP
>
> The Royal London Unit Trust Managers Limited for unit trusts
> Registered in England No. 1539295. Regulated by the Financial
> Services Authority
> Registered Office: Royal London House, Middleborough, Colchester,
> Essex, C01 1PP
>
> The Scottish Life Pensions Annuity Company Limited for pension fund
> management services.
> Registered in Scotland no: 48729. Regulated by the Financial
> Services Authority
> Registered Office: 19 St Andrew Square, Edinburgh, EH2 1YE
>
> The Scottish Life Investment Management Company Limited for unit
> trusts.
> Registered in Scotland no: 86116. Regulated by the Financial
> Services Authority
> Registered Office: 19 St Andrew Square, Edinburgh, EH2 1YE
>
> ******************************************************
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
