Available DBI Drivers and Data Sources : DBI « Database « Perl

Home
Perl
1.Array
2.CGI
3.Class
4.Data Type
5.Database
6.File
7.GUI
8.Hash
9.Language Basics
10.Network
11.Regular Expression
12.Report
13.Statement
14.String
15.Subroutine
16.System Functions
17.Win32
18.XML
Perl » Database » DBI 




Available DBI Drivers and Data Sources
   

#!/usr/bin/perl
use warnings;
use strict;
use DBI;

my @drivers=DBI->available_drivers('quiet');
my @sources;
foreach my $driver (@drivers) {
    print "$driver\n";
    @sources=eval 
        DBI->data_sources($driver
    };
    if ($@) {
        print "\tError: ",substr($@,0,60),"\n";
    elsif (@sources) {
        foreach (@sources) {
            print "\t$_\n";
        }
    else {
        print "\tNo known data sources\n";
    }
}

   
    
    
  














Related examples in the same category
1.Listing Currently Installed Drivers
2.Listing Valid DSNs
3.Talking with the Database
4.The connect() Method
5.Use DBI to connect to a database
6.Connect to Oracle
7.Connect to mysql
8.Binding Columns
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.