Hi Jim, On Fri, 28 Jan 2011, Jim wrote: <snipp/> > Thanks that's was very useful. I have done some more debugging and its > apparent that whenever the process dies the last thing it was doing was a SQL > update to a MS-SQL server. Doing some digging and it looks like we are > connecting to MS-SQL via Freetds. > > Radiator connection: > Identifier MSSQL-SessionDB > DBSource dbi:Sybase:MSDBServerX > DBUsername dbuser > DBAuth dbpassword > Timeout 5 > > /usr/local/freetds/etc/freetds.conf: > [MSDBServerX] > host = x.x.x.x > port = 1433 > tds version = 7.0 > > I think the FreeTDS version we have maybe to recent as its newer than the FAQ > recommends - although the FAQ says "As of September 2003..". What is the > best way, if there is one, to connect to a Windows MS-SQL 2008 server?
I have no Idea how well maintained FreeTDS is these days. Last time I saw it 10 years ago it had lots of issues. I also do not know if they have kept up with MS-SQL and it's development. As an alternative you might want to try DBD::proxy together with DBD::OBDC on your Windows Server. Greetings Christian -- Christian Kratzer CK Software GmbH Email: c...@cksoft.de Wildberger Weg 24/2 Phone: +49 7032 893 997 - 0 D-71126 Gaeufelden Fax: +49 7032 893 997 - 9 HRB 245288, Amtsgericht Stuttgart Web: http://www.cksoft.de/ Geschaeftsfuehrer: Christian Kratzer _______________________________________________ radiator mailing list radiator@open.com.au http://www.open.com.au/mailman/listinfo/radiator