Re: URGENT Numeric values disappear

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