NAME
DBD::ADO - A DBI driver for Microsoft ADO (Active Data Objects)
SYNOPSIS
use DBI();
my $dbh = DBI->connect("dbi:ADO:$dsn", $user, $passwd );
DESCRIPTION
The DBD::ADO module supports ADO access on a Win32 machine. DBD::ADO is
written to support the standard DBI interface to data sources.
PREREQUISITES
DBI
Win32::OLE
ADO (http://www.microsoft.com/Data/download.htm)
INSTALLATION
To install this module type the following:
perl Makefile.PL
make
make test
make install
You need to use the correct make command. That may be nmake or dmake,
depending on which development environment you are using.
If using the Win32 ActiveState build then it is recommended that you
use the ppm utility to fetch and install the module instead.
TESTING
The supplied tests will connect to the database using the DBI
environment variables, e.g.:
set DBI_DSN=dbi:ADO:File Name=test.udl
set DBI_DSN=dbi:ADO:Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\tmp\test.mdb
The tests will create tables (or other database objects) with the name
(or prefix) 'PERL_DBD_TEST' in the current schema.
Check for the unlikly case that this will cause unwanted side effects!
To run the tests, type
make test
If all tests pass, you'll see something like:
t\01base.......ok
t\02ads........ok
t\02cxn........ok
t\04os.........ok
25/45 skipped: various reasons
...
t\51qi.........ok
All tests successful, 53 subtests skipped.
Files=29, Tests=737, 122 wallclock secs ...
It is possible to run individual test scripts, e.g.:
perl -w -Mblib t\02cxn.t
AUTHORS
Tim Bunce and Phlip. With many thanks to Jan Dubois and Jochen Wiedmann
for additions, debuggery and general help.
Special thanks to Thomas Lowery, who maintained this module 2001-2003.
Current maintainer is Steffen Goeldner.
SUPPORT
This software is supported via the dbi-users mailing list.
For more information and to keep informed about progress you can join the
mailing list by sending a message to dbi-users-help@perl.org
Please post details of any problems (or changes you needed to make) to
dbi-users@perl.org and CC them to me (sgoeldner@cpan.org).
COPYRIGHT
Copyright (c) 1998, Tim Bunce
Copyright (c) 1999, Tim Bunce, Phlip, Thomas Lowery
Copyright (c) 2000, Tim Bunce, Thomas Lowery
Copyright (c) 2001, Tim Bunce, Thomas Lowery, Steffen Goeldner
Copyright (c) 2002, Thomas Lowery, Steffen Goeldner
Copyright (c) 2003, Thomas Lowery, Steffen Goeldner
Copyright (c) 2004-2011 Steffen Goeldner
All rights reserved.
You may distribute under the terms of either the GNU General Public
License or the Artistic License, as specified in the Perl README file.