Re: URGENT Numeric values disappear - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: URGENT Numeric values disappear
Date
Msg-id 462F623C.3050301@tpf.co.jp
Whole thread Raw
In response to Re: URGENT Numeric values disappear  (Hiroshi Inoue <inoue@tpf.co.jp>)
List pgsql-odbc
Hiroshi Inoue wrote:
> Sean Murphy wrote:
>> Over the last several weeks I've moved from an 8.2.0 server on Win32 to
>> an 8.2.3 server on Ubuntu 6.06 LTS. In the course of doing so I started
>> distributing psqlodbc 8.02.0300 with a couple of VB6 desktop user
>> applications, connecting using SSL and ADO.
>>
>> Everything was going fine, or so I thought until a user pointed out
>> (apparently) missing data - a bunch of zeroes where various numeric(x,y)
>> values belonged. Lo and behold, every numeric value selected over ODBC
>> is returning zero.
>>
>> If I cast numeric as double or varchar it returns the correct data. I
>> tried reverting to earlier versions of psqlodbc - the data returns
>> correctly but the app crashes hard on inserts with a corresponding
>> server log saying "SSL SYSCALL error - unexpected EOF on client connection"
>>
>> I have WAY too many numeric fields to cast them all, and they all worked
>> previously.
>>
>> What's going on?
>
> Please try the snapshot driver at
>   http://www.geocities.jp/inocchichichi/index.html

Oops the right URL is
  http://www.geocities.jp/inocchichichi/psqlodbc/index.html .

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: URGENT Numeric values disappear
Next
From: Tom Lane
Date:
Subject: Re: psqlODBC 08.02.0300 doesn't compile