http://qs321.pair.com?node_id=40519

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

Hi there, I am trying to connect to a MS SQL 6.5 server and when ever the program is run it just hangs, I tried commenting out the SQL commands and then the program worked fine. It doesn't crash the whole system (Win NT) just hangs the program. The first few times that I tried to connect it worked fine but then all of a sudden it stopped, could it be a problem with the server? (I can't find this out because it is over a network and I don't have access to the server.) Here is the connect statement that I am using:
use DBI(); $DSN = 'driver={SQL Server};Server=pc62003302;database=TLRS;uid=sa;pwd +=;'; $dbh = DBI->connect("dbi:ODBC:$DSN",'','') or die "$DBI::errstr\n";
Thanks Sparkie