Skip to Content.
Sympa Menu

freetds - Re: [freetds] sqsh and msrepl_tran_version

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT schemamania.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] sqsh and msrepl_tran_version
  • Date: Mon, 7 Jul 2003 08:24:46 -0400

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




Archive powered by MHonArc 2.6.24.

Top of Page