DBD-ADO - README

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

You may distribute under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl README file.