freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] Fw: numeri/decimal problems using freetds and sybase 12.5

From: "James K. Lowden" <jklowden AT schemamania.org>
To: TDS Development Group <freetds AT lists.ibiblio.org>
Cc: flungu AT firstderivatives.com
Subject: [freetds] Fw: numeri/decimal problems using freetds and sybase 12.5
Date: Wed, 30 Mar 2005 08:49:42 -0500

Felix,

Thanks for the problem report. What version of FreeTDS are you using? It
would also be helpful to have a TDSDUMP log of the same work.

As for reporting bugs, best is to join the mailing list and post them
there. You can subscribe at
http://lists.ibiblio.org/mailman/listinfo/freetds/.

I have forwarded your message to the list, where people more familiar than
I am with the ODBC driver can take a look at it.

Regards,

--jkl

Begin forwarded message:

Date: Wed, 30 Mar 2005 10:58:53 +0100
From: felix <flungu AT firstderivatives.com>
To: jklowden AT freetds.org
Subject: numeri/decimal problems using freetds and sybase 12.5

hi,

sorry for this email but i have been looking over the freetds site to find
where i can send a bug report and didn't find anything.

some of our customers are using freetds to import the data from sybase
into another systems and i have observed that if i have a numeric or
decimal column in a sybase table, freetds odbc driver fails to report
them as
such and the return from SQLDescribeCol for these types is BIG_INT (-5).

i have attached a debug output to where it can been this behaviour (Col1
is numeric and Col2 is decimal).

regards,
felix

[ODBC][16174][SQLExecDirect.c][200]
Entry:
Statement = 0x81844c8
SQL = [select * from DaveTest][length = 22]
[ODBC][16174][SQLExecDirect.c][425]
Exit:[SQL_SUCCESS]
[ODBC][16174][SQLNumResultCols.c][137]
Entry:
Statement = 0x81844c8
Column Count = 0xffffa0ae
[ODBC][16174][SQLNumResultCols.c][228]
Exit:[SQL_SUCCESS]
Count = 0xffffa0ae -> 4
[ODBC][16174][SQLDescribeCol.c][182]
Entry:
Statement = 0x81844c8
Column Number = 1
Column Name = 0xffffa010
Buffer Length = 128
Name Length = 0xffffa0b2
Data Type = 0xffffa0b0
Column Size = 0xffffa0b8
Decimal Digits = 0xffffa0ac
Nullable = 0xffffa0aa
[ODBC][16174][SQLDescribeCol.c][429]
Exit:[SQL_SUCCESS]
Column Name = [Col1]
Data Type = 0xffffa0b0 -> -5
Column Size = 0xffffa0b8 -> 18
Decimal Digits = 0xffffa0ac -> 0
Nullable = 0xffffa0aa -> 0
[ODBC][16174][SQLDescribeCol.c][182]
Entry:
Statement = 0x81844c8
Column Number = 2
Column Name = 0xffffa010
Buffer Length = 128
Name Length = 0xffffa0b2
Data Type = 0xffffa0b0
Column Size = 0xffffa0b8
Decimal Digits = 0xffffa0ac
Nullable = 0xffffa0aa
[ODBC][16174][SQLDescribeCol.c][429]
Exit:[SQL_SUCCESS]
Column Name = [Col2]
Data Type = 0xffffa0b0 -> -5
Column Size = 0xffffa0b8 -> 23
Decimal Digits = 0xffffa0ac -> 8
Nullable = 0xffffa0aa -> 0
[ODBC][16174][SQLDescribeCol.c][182]
Entry:
Statement = 0x81844c8
Column Number = 3
Column Name = 0xffffa010
Buffer Length = 128
Name Length = 0xffffa0b2
Data Type = 0xffffa0b0
Column Size = 0xffffa0b8
Decimal Digits = 0xffffa0ac
Nullable = 0xffffa0aa
[ODBC][16174][SQLDescribeCol.c][429]
Exit:[SQL_SUCCESS]
Column Name = [ListSeqNo]
Data Type = 0xffffa0b0 -> 4
Column Size = 0xffffa0b8 -> 4
Decimal Digits = 0xffffa0ac -> 0
Nullable = 0xffffa0aa -> 1
[ODBC][16174][SQLDescribeCol.c][182]
Entry:
Statement = 0x81844c8
Column Number = 4
Column Name = 0xffffa010
Buffer Length = 128
Name Length = 0xffffa0b2
Data Type = 0xffffa0b0
Column Size = 0xffffa0b8
Decimal Digits = 0xffffa0ac
Nullable = 0xffffa0aa
[ODBC][16174][SQLDescribeCol.c][429]
Exit:[SQL_SUCCESS]
Column Name = [ListSeqNo1]
Data Type = 0xffffa0b0 -> -5
Column Size = 0xffffa0b8 -> 18
Decimal Digits = 0xffffa0ac -> 0
Nullable = 0xffffa0aa -> 0
[ODBC][16174][SQLBindCol.c][154]
Entry:
Statement = 0x81844c8
Column Number = 1
Target Type = -25 SQL_C_SBIGINT
Target Value = 0x8183808
Buffer Length = 8
StrLen Or Ind = 0x81837d8
[ODBC][16174][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][16174][SQLBindCol.c][154]
Entry:
Statement = 0x81844c8
Column Number = 2
Target Type = -25 SQL_C_SBIGINT
Target Value = 0x8182e98
Buffer Length = 8
StrLen Or Ind = 0x81837dc
[ODBC][16174][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][16174][SQLBindCol.c][154]
Entry:
Statement = 0x81844c8
Column Number = 3
Target Type = 4 SQL_INTEGER
Target Value = 0x8182ec8
Buffer Length = 4
StrLen Or Ind = 0x81837e0
[ODBC][16174][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][16174][SQLBindCol.c][154]
Entry:
Statement = 0x81844c8
Column Number = 4
Target Type = -25 SQL_C_SBIGINT
Target Value = 0x8182ef8
Buffer Length = 8
StrLen Or Ind = 0x81837e4
[ODBC][16174][SQLBindCol.c][244]
Exit:[SQL_SUCCESS]
[ODBC][16174][SQLFetch.c][146]
Entry:
Statement = 0x81844c8
[ODBC][16174][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][16174][SQLFetch.c][146]
Entry:
Statement = 0x81844c8
[ODBC][16174][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][16174][SQLFetch.c][146]
Entry:
Statement = 0x81844c8
[ODBC][16174][SQLFetch.c][338]
Exit:[SQL_SUCCESS]
[ODBC][16174][SQLFetch.c][146]
Entry:
Statement = 0x81844c8
[ODBC][16174][SQLFetch.c][338]
Exit:[SQL_NO_DATA]
[ODBC][16174][SQLMoreResults.c][131]
Entry:
Statement = 0x81844c8
[ODBC][16174][SQLMoreResults.c][281]
Exit:[SQL_NO_DATA]
[ODBC][16174][SQLFreeStmt.c][128]
Entry:
Statement = 0x81844c8
Option = 1
[ODBC][16174][SQLFreeHandle.c][349]
Entry:
Handle Type = 3
Input Handle = 0x81844c8
[ODBC][16174][SQLFreeHandle.c][450]
Exit:[SQL_SUCCESS]
[ODBC][16366][__handles.c][372]
Exit:[SQL_SUCCESS]
Environment = 0x817fca8
[ODBC][16366][SQLAllocHandle.c][315]
Entry:
Handle Type = 2
Input Handle = 0x817fca8
[ODBC][16366][SQLAllocHandle.c][429]
Exit:[SQL_SUCCESS]
Output Handle = 0x81803a0
[ODBC][16366][SQLConnect.c][2414]
Entry:
Connection = 0x81803a0
Server Name = [DAVE][length = 4 (SQL_NTS)]
User Name = [NULL]
Authentication = [NULL]
[ODBC][16366][SQLConnect.c][2995]
Exit:[SQL_SUCCESS]
[ODBC][16366][SQLAllocHandle.c][315]
Entry:
Handle Type = 2
Input Handle = 0x817fca8
[ODBC][16366][SQLAllocHandle.c][429]
Exit:[SQL_SUCCESS]
Output Handle = 0x8183eb0
[ODBC][16366][SQLConnect.c][2414]
Entry:
Connection = 0x8183eb0
Server Name = [DAVE][length = 4 (SQL_NTS)]
User Name = [NULL]
Authentication = [NULL]
[ODBC][16366][SQLConnect.c][2995]
Exit:[SQL_SUCCESS]
[ODBC][16366][SQLAllocHandle.c][476]
Entry:
Handle Type = 3
Input Handle = 0x8183eb0
[ODBC][16366][SQLAllocHandle.c][840]
Exit:[SQL_SUCCESS]
Output Handle = 0x8186028
[ODBC][16366][SQLExecDirect.c][200]

[freetds] Fw: numeri/decimal problems using freetds and sybase 12.5, James K. Lowden, 03/30/2005
- Message not available
  - [freetds] Re: Fw: numeri/decimal problems using freetds and sybase 12.5, James K. Lowden, 03/30/2005