Stories
Slash Boxes
Comments
NOTE: use Perl; is on undef hiatus. You can read content, but you can't post it. More info will be forthcoming forthcomingly.

All the Perl that's Practical to Extract and Report

The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.
 Full
 Abbreviated
 Hidden
More | Login | Reply
Loading... please wait.
  • It took me awhile to figure out, but whenever I need to connect to several different databases of the same type through DBD::ODBC, I create a file dsn for the first one, then copy and paste the contents of the file (from c:\Program Files\Common Files\ODBC) into the program to use as a template. E.g., for SQL server (on my local machine) it was:

    my $dsn=<<EOT;
    DRIVER=SQL Server
    DATABASE=$dbname
    APP=Microsoft Open Database Connectivity
    SERVER=(local)
    Description=paxl
    EOT

    $dsn =~ tr/\n/;/;
    my $dbh = DBI->con