February 10, 2016 at 12:57 pm
Have a bunch of SQL 2012 instances. Some are at SP2, some are at SP3. The ones that have been recently upgraded to SP3 are not longer able to connect to thru FreeTDS. Getting the message...
Error 20017 (severity 9):
Unexpected EOF from the server
OS error 2, "No such file or directory"
Error 20002 (severity 9):
Adaptive Server connection failed
The FreeTDS configuration for the server is:
[<servername>]
host = <servername>
port = <port number>
tds version = 8.0
This has worked fine until upgrading to SP3. Still connects fine to SP2 instances.
Any thoughts?
Thanks.
John
February 10, 2016 at 8:04 pm
Microsoft only officially supports 2 versions back, so from SQL Server 2012 that would be back to SQL Server 2005. I see you are running with version 8.0 in your FreeTDS config which equates to SQL Server 2000. It's been a long time since I used FreeTDS (with Perl against SQL 2005) so not sure that higher version numbers are supported but you may want to look into it.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 19, 2016 at 8:05 am
FYI...Finally determined we needed to change the TDS Version from 8.0 to TDS Version 7.0 to get it to work with SQL 2012 SP3. TDS Version 8.0 had worked for SQL 2005, 2008 and up to 2012 SP2. TDS Version 7.0 works with all of them.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply