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-24 02:40:59
Message-ID: 462D6E3B.8070000@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
Sean Murphy さんは書きました:
> 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
?

regards,
Hiroshi Inoue


In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi SaitoDate: 2007-04-24 04:36:35
Subject: Re: ODBC issue
Previous:From: Hiroshi SaitoDate: 2007-04-24 00:26:58
Subject: Re: Is psqlodbc-08.02.0300.tar.gz official yet?

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