[freetds] sqsh and msrepl_tran_version

James K. Lowden jklowden at schemamania.org
Mon Jul 7 09:24:46 EDT 2003


On Mon, 7 Jul 2003 03:59:15 +0000 (GMT), Andrew Stevenson
<andrews at ntt.net.au> wrote:
> I have a database hosted under MS-SQL that I connect to via freetds
> (0.60). The DB is replicated to another server and so the magical field
> msrepl_tran_version appears in all the tables. I am unable to run a
> query that returns this field.
> 
> Using sqsh I get no results, just the colomn headings. Using perl/DBI I
> get:
> 
> error_handler: Data-conversion resulted in overflow.

The error message means FreeTDS couldn't convert the data sent by the
server into the form requested by sqsh because the target datatype was too
small.  That would be the case if for example your "magical field" were
datatype numeric(18) whose value was larger than 2^31, and sqsh tried to
create an integer from it.  

If you need more help, please provide the datatype and value.  You can
find the value in the TDSDUMP log file.  

--jkl


More information about the FreeTDS mailing list