[freetds] Data-conversion resulted in overflow using FreeTDS and SQLServer

James K. Lowden jklowden at freetds.org
Sat Nov 29 21:00:56 EST 2008


dmarrer at bci.cl wrote:
> 
> We are using freetds 0.82 to connect to a MSQL database 2005.
> 
> When reading certain tables, using fisql, we have no errors but other 
> tables give
> the error:
> 
> error_handler: Data-conversion resulted in overflow.
> for each line of results.
...
> 
> The problem was with the conversion of the date format


$ fisql -S $S -U $U -P $P
1>> select getdate() as today
2>> go
today                     
--------------------------
Nov 30 2008 12:51PM       

(1 rows affected)
1>> 

Is your default datetime conversion string format different from mine?  A
quick scan of the code shows only one call to dbconvert(), and the target
buffer size is 512 bytes, a mighty big date.  

I'd expect a TDSDUMP log to be informative.  

--jkl



More information about the FreeTDS mailing list