We use DBD::Sybase with FreeTDS to connect to MSSQL Server 2000 from
FreeBSD, and it works great, have never had any trouble. 

What version of FreeTDS are you using?

You can also do some debugging with FreeTDS to see if it is the one
hanging. 
http://www.freetds.org/userguide/x1873.htm#AEN1877

Hope this helps,

-Patrick

--
Patrick Muldoon, Network/Software Engineer
INOC, LLC
[EMAIL PROTECTED]

If the automobile had followed the same development cycle as the
computer, a Rolls-Royce would today cost $100, get a million miles per
gallon, and explode once a year, killing everyone inside. - Robert X.
Cringely
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
On
> Behalf Of Dan Melomedman
> Sent: Thursday, September 05, 2002 10:57 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: (RADIATOR) SQL Server Connection Handling
> 
> Mike McCauley wrote:
> > Hi Dan,
> >
> > OK,
> >
> > here is a new version of SqlDb.pm that implements a new
> DisconnectAfterQuery
> > flag. This will cause AuthBy SQL and other SQL users to disconnect
after
> > every SQL 'do' and after every 'getOneRow'.
> >
> > Let me know how you go.
> >
> > Cheers.
> >
> 
> Thanks for all your effort, Mike. The problem didn't go away, however.
> I am suspecting a FreeTDS problem now. Server just hangs. 'top' shows
> it's in 'sbwait' state. 'netstat' shows an open connection to the MS
SQL
> machine.
> 
> Paulo Souso's Radiator also hangs, by the way. They use MS SQL too.
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on [EMAIL PROTECTED]
> To unsubscribe, email '[EMAIL PROTECTED]' with
> 'unsubscribe radiator' in the body of the message.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.

Reply via email to