<div>Jay,</div>
<div> </div>
<div>I am trying to do something very similar. Would you be interesdted in helping me. I could possibly pay you for your time (i.e beer, gift cert. donation to fav charity, cash). I have a sql2000 database I would like to access via perl DBD::ODBC (or DBD::Sybase I suppose). I installed Freetds and am able to access the database with the tsql command line client But I am having trouble with my perl app accessing it. I am sure it is all the wierd freetds.conf, odbc.ini stuff. Let me know if you can help. I could provide you with ssh/vnc access to my box.</div>
<div> </div>
<div>Todd 660-2787<br><br></div>
<div class="gmail_quote">On Thu, Mar 6, 2008 at 4:16 PM, Jay Hannah <<a href="mailto:jay@jays.net">jay@jays.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">It's nice to know that with enough retries and error handling, you can,<br>eventually pull data from a bad server over a terrible network<br>
connection... :)<br><br>Perl in Omaha <-> DBI <-> DBD::Sybase <-> freetds <-> MS-SQL in Mexico<br><br>:)<br><br>j<br><br><br><br> my $sth = $dbh_pms->prepare($strsql);<br> for (1..50) {<br> if ($sth->execute) {<br>
last;<br> } else {<br> $logger->warn("Database error detected (attempt # $_). Waiting<br>3 seconds, then retrying: $DBI::errstr");<br> $sth->finish;<br> $sth = $dbh_pms->prepare($strsql);<br>
sleep 3;<br> }<br> }<br><br><br><br>_______________________________________________<br>Omaha-pm mailing list<br><a href="mailto:Omaha-pm@pm.org">Omaha-pm@pm.org</a><br><a href="http://mail.pm.org/mailman/listinfo/omaha-pm" target="_blank">http://mail.pm.org/mailman/listinfo/omaha-pm</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Todd Christopher Hamilton<br>(402) 660-2787