(RADIATOR) SQL Server Connection Handling

[Leon Oosterwijk]

Forgive my ignorance, 

I was under the impression that FreeTDS would only work with SQL server
7.0 because as of 2000 microsoft changed the protocol so drastically
that is will no longer work with freetds (which was written for sybase,
essentially). 

Sincerely, 

Leon Oosterwijk
ISDN-NET Inc. 
(615) 221-4200
http://www.isdn.net
 

> -----Original Message-----
> From: Patrick Muldoon(NOC) [mailto:noc at inoc.net] 
> Sent: Thursday, September 05, 2002 10:40 AM
> To: 'Dan Melomedman'
> Cc: radiator at open.com.au
> Subject: RE: (RADIATOR) SQL Server Connection Handling
> 
> 
> 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.
> 
===
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.