Listing Valid DSNs : 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 




Listing Valid DSNs
   


#!/usr/bin/perl

use strict;
use DBI;

my @drivers;
@drivers = DBI->available_drivers;

foreach my $driver (@drivers) {
  print "$driver driver is available\n";
  my @dsns = DBI->data_sources($driver);
  foreach my $dsn (@dsns) {
    print "\tDSN: $dsn\n";
  }
}

   
    
    
  














Related examples in the same category
1.Listing Currently Installed Drivers
2.Talking with the Database
3.The connect() Method
4.Use DBI to connect to a database
5.Connect to Oracle
6.Connect to mysql
7.Binding Columns
8.Available DBI Drivers and Data Sources
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.