Results 1 to 1 of 1
Hi, I am having intermittent issues when querying an mssql database using the FreeTDS library. 60 - 70% of the time it works fine but I often get the error: ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
- 12-07-2010 #1
- Join Date
- Dec 2010
I am having intermittent issues when querying an mssql database using the FreeTDS library. 60 - 70% of the time it works fine but I often get the error:
[FreeTDS][SQL Server] Read from SQL server failed (49)
I am having trouble turning on the logging for FreeTDS to see what is going on. I have followed the instruction on the FreeTDS website with no avail.
My freetds.conf file looks like:
# $Id: freetds.conf,v 1.12 2007/12/25 06:02:36 jklowden Exp $ # # This file is installed by FreeTDS if no file by the same # name is found in the installation directory. # # For information about the layout of this file and its settings, # see the freetds.conf manpage "man freetds.conf". # Global settings are overridden by those in a database # server specific section [global] # TDS protocol version tds version = 7.0 # Whether to write a TDSDUMP file for diagnostic purposes # (setting this to /tmp is insecure on a multi-user system) dump file = /tmp/freetds.log dump file append = yes debug flags = 0x4FFF # Command and connection timeouts timeout = 10 connect timeout = 10 # If you get out-of-memory errors, it may mean that your client # is trying to allocate a huge buffer for a TEXT field. # Try setting 'text size' to a more reasonable limit text size = 64512 # A typical Sybase server [egServer50] host = symachine.domain.com port = 5000 tds version = 5.0 # A typical Microsoft server [egServer70] host = ntmachine.domain.com port = 1433 tds version = 7.0
Any ideas? Is there anyway to check that FreeTDS is even reading this conf file?