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-2009 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.