freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] FreeTDS problems with converting SQL BigInt

From: "James K. Lowden" <jklowden AT freetds.org>
To: freetds AT lists.ibiblio.org
Cc: Feroze Daud <khichdo AT yahoo.com>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] FreeTDS problems with converting SQL BigInt
Date: Wed, 18 Sep 2013 21:32:33 -0400

On Wed, 18 Sep 2013 13:03:50 -0700 (PDT)
Feroze Daud <khichdo AT yahoo.com> wrote:

> Thanks. Unfortunately, I need to get the output parameter first, so I
> changed the sproc to return the value as a resultset, instead of an
> output parameter.

As Frediano mentioned, the server sends the output parameter after any
ROW packets. FreeTDS makes the data available to the application as
they arrive from the server.

> This brings me to the original problem. I am getting garbage values
> out of call to getBigInteger.

What does src/odbc/unittests/genparams show on your machine regarding
the BIGINT type?

> Is there any way to enable Freetds logging for applications that dont
> go through the odbc driver manager?

Cf. TDSDUMP in the user guide.

HTH.

--jkl

P.S. Top-posting reduces the value of the email archive by making it
harder to follow the thread.

[freetds] FreeTDS problems with converting SQL BigInt, Feroze Daud, 09/15/2013
- Re: [freetds] FreeTDS problems with converting SQL BigInt, Frediano Ziglio, 09/16/2013
  - Re: [freetds] FreeTDS problems with converting SQL BigInt, Feroze Daud, 09/16/2013
    - Re: [freetds] FreeTDS problems with converting SQL BigInt, James K. Lowden, 09/16/2013
      - Re: [freetds] FreeTDS problems with converting SQL BigInt, Frediano Ziglio, 09/17/2013
      - Re: [freetds] FreeTDS problems with converting SQL BigInt, Feroze Daud, 09/17/2013
        
        Re: [freetds] FreeTDS problems with converting SQL BigInt, Frediano Ziglio, 09/18/2013
        
        Re: [freetds] FreeTDS problems with converting SQL BigInt, Feroze Daud, 09/18/2013
        
        Re: [freetds] FreeTDS problems with converting SQL BigInt, James K. Lowden, 09/18/2013
        Re: [freetds] FreeTDS problems with converting SQL BigInt, Feroze Daud, 09/19/2013
        
        Re: [freetds] FreeTDS problems with converting SQL BigInt, Feroze Daud, 09/19/2013
        Message not available
        Re: [freetds] FreeTDS problems with converting SQL BigInt, Feroze Daud, 09/19/2013
        Re: [freetds] FreeTDS problems with converting SQL BigInt, Igor Korot, 09/19/2013
        Re: [freetds] FreeTDS problems with converting SQL BigInt, Feroze Daud, 09/19/2013
        
        Re: [freetds] FreeTDS problems with converting SQL BigInt, Feroze Daud, 09/20/2013
        Re: [freetds] FreeTDS problems with converting SQL BigInt, James K. Lowden, 09/22/2013