Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Is there a way to find what ODBC names are available on a windows server?

Replies are listed 'Best First'.
Re: Find an ODBC
by Trix606 (Monk) on Nov 03, 2005 at 18:13 UTC
    You can get a hash of the DSN name entries on a Windows system with Win32::ODBC 
    use strict;
use Win32::ODBC;
use Data::Dumper;

my %DSN = Win32::ODBC::DataSources();
print Dumper(%DSN);

    [download]
    Updated Fixed grammar. Now back to my pizza pie. :)
[reply]
[d/l]
      "DSN names"? Do you also say "PIN number", "SIN number" and "ASCII standard"?
[reply]
Re: Find an ODBC
by marto (Cardinal) on Nov 03, 2005 at 17:14 UTC
    Do you mean available ODBC Drivers or configured Data Source Names?

    Martin
[reply]

Back to Seekers of Perl Wisdom