Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS problems with converting SQL BigInt

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Feroze Daud <khichdo AT yahoo.com>
  • To: Frediano Ziglio <freddy77 AT gmail.com>, FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS problems with converting SQL BigInt
  • Date: Thu, 19 Sep 2013 11:29:33 -0700 (PDT)

we are using TDS protocol version 8. Should we be using something else?


here is our connection string...

--

Initializing processing with connection
string:DRIVER=FreeTDS;Server=<snip>;UID=<snip>;PWD=<snip>;Database=<snip>;TDS_Version=8.0;Port=1433

--

feroze.


________________________________
From: Frediano Ziglio <freddy77 AT gmail.com>
To: Feroze Daud <khichdo AT yahoo.com>; FreeTDS Development Group
<freetds AT lists.ibiblio.org>
Sent: Thursday, September 19, 2013 11:09 AM
Subject: Re: [freetds] FreeTDS problems with converting SQL BigInt


2013/9/19 Feroze Daud <khichdo AT yahoo.com>:
> So, I enabled logging for my application. This is what it shows me for the
> column that is being corrupted.
>
> --
> token.c:526:processing result tokens.  marker is  81(TDS7_RESULT)
> mem.c:519:tds_free_all_results()
> token.c:1472:processing TDS7 result. set current_results to tds->res_info
> read.c:179:tds_get_string: reading 20 from wire to give 10 to client.
> token.c:1414:tds7_get_data_info:
>        colname = MaxQueueID (10 bytes)
>        type = 108 (numeric)
>        server's type = 108 (numeric)
>        column_varint_size = 1
>        column_size = 17 (17 on server)
>
> --
>
> Does this mean that the TDS stream that is being read by freetds is
> advertizing the column as numeric?
>

No, it means the server is returning the number as numeric. Are you
sure you are using proper protocol version?

> Is there any way to have tdslog print out the value of the column that it
> is reading from the socket?
>

If you can read binary yes, just turn network data dump on.

> feroze.
>
>
>

Frediano

>
> ----- Original Message -----
> 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>
> Sent: Wednesday, September 18, 2013 6:32 PM
> Subject: Re: [freetds] FreeTDS problems with converting SQL BigInt
>
> 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 mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>From msabramo AT gmail.com Thu Sep 19 14:42:20 2013
Return-Path: <msabramo AT gmail.com>
X-Original-To: freetds AT lists.ibiblio.org
Delivered-To: freetds AT lists.ibiblio.org
Received: by lists.ibiblio.org (Postfix, from userid 20217)
id DD119E9645; Thu, 19 Sep 2013 14:42:20 -0400 (EDT)
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on
mailman1.ibiblio.org
X-Spam-Level:
X-Spam-Status: No, score=-2.7 required=5.0 tests=AWL,BAYES_00,DKIM_SIGNED,
DKIM_VALID,DKIM_VALID_AU,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,WEIRD_PORT
autolearn=ham version=3.3.1
Received: from mail-we0-f176.google.com (mail-we0-f176.google.com
[74.125.82.176])
by lists.ibiblio.org (Postfix) with ESMTP id 8DC7CE963A
for <freetds AT lists.ibiblio.org>; Thu, 19 Sep 2013 14:42:16 -0400 (EDT)
Received: by mail-we0-f176.google.com with SMTP id u56so8177886wes.7
for <freetds AT lists.ibiblio.org>; Thu, 19 Sep 2013 11:42:15 -0700 (PDT)
MIME-Version: 1.0
X-Received: by 10.194.75.165 with SMTP id d5mr2651186wjw.18.1379616135720;
Thu, 19 Sep 2013 11:42:15 -0700 (PDT)
Received: by 10.194.14.231 with HTTP; Thu, 19 Sep 2013 11:42:15 -0700 (PDT)
In-Reply-To: <1379613350.36855.YahooMailNeo AT web160401.mail.bf1.yahoo.com>
References: <1379610352.55465.YahooMailNeo AT web160403.mail.bf1.yahoo.com>
<CAAgNOZ2fR95ffsKQoDtCzLwot19_OZo9KbOXxNG1-+mL4UgyhA AT mail.gmail.com>
<1379613350.36855.YahooMailNeo AT web160401.mail.bf1.yahoo.com>
Date: Thu, 19 Sep 2013 11:42:15 -0700
Message-ID: <CAAgNOZ1sRCAwJvGQE\Z5q0wZyoWfme3xrmQ=fN2q=4ue1C6A AT mail.gmail.com>
From: Marc Abramowitz <msabramo AT gmail.com>
To: Feroze Daud <khichdo AT yahoo.com>
Content-Type: text/plain; charset=ISO-8859-1
X-Content-Filtered-By: Mailman/MimeDel 2.1.9
Cc: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Unable to build freetds
X-BeenThere: freetds AT lists.ibiblio.org
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
List-Id: FreeTDS Development Group <freetds.lists.ibiblio.org>
List-Unsubscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
<mailto:freetds-request AT lists.ibiblio.org?subject=unsubscribe>
List-Archive: <https://lists.ibiblio.org/sympa/arc/freetds>
List-Post: <mailto:freetds AT lists.ibiblio.org>
List-Help: <mailto:sympa AT lists.ibiblio.org?subject=HELP>
List-Subscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
<mailto:freetds-request AT lists.ibiblio.org?subject=subscribe>
X-List-Received-Date: Thu, 19 Sep 2013 18:42:21 -0000

> Can't exec "libtoolize": No such file or directory at /usr/bin/autoreconf
line 196

Looks like maybe you need to install "libtool"


On Thu, Sep 19, 2013 at 10:55 AM, Feroze Daud <khichdo AT yahoo.com> wrote:

> That didnt work...
>
> --
> ferozed@ferozed-linux2:~/zstash/freetds$ autoreconf -i
> Can't exec "libtoolize": No such file or directory at /usr/bin/autoreconf
> line 196.
> Use of uninitialized value in pattern match (m//) at /usr/bin/autoreconf
> line 196.
> acinclude.m4:1: warning: ill-formed serial number `AM2', expecting a
> version string with only digits and dots
> configure.in:81: warning: macro `AM_PROG_LIBTOOL' not found in library
> configure.in:571: warning: AC_LANG_CONFTEST: no AC_LANG_SOURCE call
> detected in body
> ../../lib/autoconf/lang.m4:194: AC_LANG_CONFTEST is expanded from...
> ../../lib/autoconf/general.m4:2591: _AC_COMPILE_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2607: AC_COMPILE_IFELSE is expanded from...
> ../../lib/m4sugar/m4sh.m4:606: AS_IF is expanded from...
> ../../lib/autoconf/general.m4:2749: AC_RUN_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2765: AC_TRY_RUN is expanded from...
> ../../lib/m4sugar/m4sh.m4:606: AS_IF is expanded from...
> ../../lib/autoconf/general.m4:2591: _AC_COMPILE_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2607: AC_COMPILE_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2615: AC_TRY_COMPILE is expanded from...
> ../../lib/m4sugar/m4sh.m4:606: AS_IF is expanded from...
> ../../lib/autoconf/general.m4:2032: AC_CACHE_VAL is expanded from...
> ../../lib/autoconf/general.m4:2053: AC_CACHE_CHECK is expanded from...
> acinclude.m4:373: AC_tds_FUNC_WHICH_GETPWUID_R is expanded from...
> configure.in:571: the top level
> configure.in:571: warning: AC_LANG_CONFTEST: no AC_LANG_SOURCE call
> detected in body
> ../../lib/autoconf/lang.m4:194: AC_LANG_CONFTEST is expanded from...
> ../../lib/autoconf/general.m4:2591: _AC_COMPILE_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2607: AC_COMPILE_IFELSE is expanded from...
> ../../lib/m4sugar/m4sh.m4:606: AS_IF is expanded from...
> ../../lib/autoconf/general.m4:2749: AC_RUN_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2765: AC_TRY_RUN is expanded from...
> ../../lib/m4sugar/m4sh.m4:606: AS_IF is expanded from...
> ../../lib/autoconf/general.m4:2591: _AC_COMPILE_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2607: AC_COMPILE_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2615: AC_TRY_COMPILE is expanded from...
> ../../lib/m4sugar/m4sh.m4:606: AS_IF is expanded from...
> ../../lib/autoconf/general.m4:2032: AC_CACHE_VAL is expanded from...
> ../../lib/autoconf/general.m4:2053: AC_CACHE_CHECK is expanded from...
> acinclude.m4:373: AC_tds_FUNC_WHICH_GETPWUID_R is expanded from...
> configure.in:571: the top level
> configure.in:571: warning: AC_LANG_CONFTEST: no AC_LANG_SOURCE call
> detected in body
> ../../lib/autoconf/lang.m4:194: AC_LANG_CONFTEST is expanded from...
> ../../lib/autoconf/general.m4:2591: _AC_COMPILE_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2607: AC_COMPILE_IFELSE is expanded from...
> ../../lib/m4sugar/m4sh.m4:606: AS_IF is expanded from...
> ../../lib/autoconf/general.m4:2749: AC_RUN_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2765: AC_TRY_RUN is expanded from...
> ../../lib/m4sugar/m4sh.m4:606: AS_IF is expanded from...
> ../../lib/autoconf/general.m4:2591: _AC_COMPILE_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2607: AC_COMPILE_IFELSE is expanded from...
> ../../lib/autoconf/general.m4:2615: AC_TRY_COMPILE is expanded from...
> ../../lib/m4sugar/m4sh.m4:606: AS_IF is expanded from...
> ../../lib/autoconf/general.m4:2032: AC_CACHE_VAL is expanded from...
> ../../lib/autoconf/general.m4:2053: AC_CACHE_CHECK is expanded from...
> acinclude.m4:373: AC_tds_FUNC_WHICH_GETPWUID_R is expanded from...
> configure.in:571: the top level
> configure.in:80: error: possibly undefined macro: AC_LIBTOOL_WIN32_DLL
> If this token and others are legitimate, please use m4_pattern_allow.
> See the Autoconf documentation.
> configure.in:81: error: possibly undefined macro: AM_PROG_LIBTOOL
> autoreconf: /usr/bin/autoconf failed with exit status: 1
>
> --
>
> ------------------------------
> *From:* Marc Abramowitz <msabramo AT gmail.com>
> *To:* Feroze Daud <khichdo AT yahoo.com>; FreeTDS Development Group <
> freetds AT lists.ibiblio.org>
> *Sent:* Thursday, September 19, 2013 10:35 AM
> *Subject:* Re: [freetds] Unable to build freetds
>
> Did you check it out from git? Maybe run autoreconf -i to regenerate the
> ./configure and associated stuff?
>
>
> On Thu, Sep 19, 2013 at 10:05 AM, Feroze Daud <khichdo AT yahoo.com> wrote:
>
> hi!
>
> I got the freetds source from the git server. I checked out the 0.64
> branch, and am trying to build it.
>
> However, configure is failing.
>
> --
>
> checking for which type of gethostbyaddr_r... eight
> checking for which type of getpwuid_r... five
> checking for which type of localtime_r... struct
> configure: debug enabled
> checking CFLAGS for gcc -Wdeclaration-after-statement...
> -Wdeclaration-after-statement
> done
> configure: creating ./config.status
> config.status: error: cannot find input file: `include/freetds/
> version.h.in'
>
>
> --
>
> What am I doing wrong? I have ubuntu 11.10 with a 3.0 linux kernel.
>
> Thanks
>
> feroze.
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
>
>
>




Archive powered by MHonArc 2.6.24.

Top of Page