[Omaha.pm] Pulling data from a crappy MS-SQL server somewhere in Mexico...

[Jay Hannah]

It's nice to know that with enough retries and error handling, you can, 
eventually pull data from a bad server over a terrible network 
connection...  :)

Perl in Omaha <-> DBI <-> DBD::Sybase <-> freetds <-> MS-SQL in Mexico

:)

j



   my $sth = $dbh_pms->prepare($strsql);
   for (1..50) {
      if ($sth->execute) {
         last;
      } else {
         $logger->warn("Database error detected (attempt # $_). Waiting 
3 seconds, then retrying: $DBI::errstr");
         $sth->finish;
         $sth = $dbh_pms->prepare($strsql);
         sleep 3;
      }
   }