Skip site navigation (1) Skip section navigation (2)

Re: URGENT Numeric values disappear

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Sean Murphy <Sean(dot)Murphy(at)equipoint(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: URGENT Numeric values disappear
Date: 2007-04-25 14:14:20
Message-ID: 462F623C.3050301@tpf.co.jp (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-odbc by date

Next:From: Tom LaneDate: 2007-04-25 15:16:22
Subject: Re: psqlODBC 08.02.0300 doesn't compile
Previous:From: Hiroshi InoueDate: 2007-04-25 13:53:03
Subject: Re: URGENT Numeric values disappear

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group