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:[EMAIL PROTECTED]] > Sent: Thursday, September 05, 2002 10:40 AM > To: 'Dan Melomedman' > Cc: [EMAIL PROTECTED] > 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 > [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. > === 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.
