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

URGENT Numeric values disappear

From: Sean Murphy <Sean(dot)Murphy(at)equipoint(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: URGENT Numeric values disappear
Date: 2007-04-23 21:47:43
Message-ID: 462D297F.5030207@equipoint.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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?

8.2.3 built from source on Ubuntu 6.06 server with openSSL 0.98e.
Clients connect via psqlodbc35w.dll, 8.02.0300, SSL on
Client application VB6 with ADO 2.8

Datasource:
Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\notgonnasay]
"AB"="0"
"BI"="0"
"BoolsAsChar"="1"
"ByteaAsLongVarBinary"="0"
"CancelAsFreeStmt"="0"
"CommLog"="0"
"ConnSettings"=""
"Database"="notgonnatell"
"Debug"="0"
"Description"=""
"DisallowPremature"="0"
"Driver"="psqlodbc35w.dll"
"ExtraSysTablePrefixes"="dd_;"
"FakeOidIndex"="0"
"Fetch"="500"
"Ksqo"="1"
"LFConversion"="1"
"LowerCaseIdentifier"="0"
"MaxLongVarcharSize"="8190"
"MaxVarcharSize"="254"
"Optimizer"="1"
"Parse"="0"
"Port"="5432"
"Password"=""
"Protocol"="7.4--1"
"ReadOnly"="0"
"SSLmode"="require"
"TextAsLongVarchar"="1"
"TrueIsMinus1"="0"
"UniqueIndex"="1"
"UnknownsAsLongVarchar"="0"
"UnknownSizes"="0"
"UpdatableCursors"="1"
"UseDeclareFetch"="0"
"Username"="radius_corp"
"UseServerSidePrepare"="0"
"XaOpt"="1"
"RowVersioning"="0"
"Servername"="neveryoumind.net"
"ShowOidColumn"="0"
"ShowSystemTables"="0"

Responses

pgsql-odbc by date

Next:From: Tom LaneDate: 2007-04-23 22:05:00
Subject: Is psqlodbc-08.02.0300.tar.gz official yet?
Previous:From: noreplyDate: 2007-04-23 01:30:28
Subject: [ psqlodbc-Bugs-1003103 ] copy_and_convert_field(...) destroys bind info for wide char varchar columns

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