(RADIATOR) SQL Server Connection Handling

Patrick Muldoon(NOC) noc at inoc.net
Thu Sep 5 10:39:32 CDT 2002


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
doon at inoc.net

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: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au]
On
> Behalf Of Dan Melomedman
> Sent: Thursday, September 05, 2002 10:57 AM
> To: radiator at open.com.au
> Cc: mkem at open.com.au
> 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 radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.

===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.


More information about the radiator mailing list