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

[gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]

From: Marco Gaiarin <gaio(at)sv(dot)lnf(dot)it>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: [gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]
Date: 2011-04-01 16:04:16
Message-ID: 20110401160416.GK2354@sv.lnf.it (view raw or flat)
Thread:
Lists: pgsql-odbc
Sorry, i repost for the third time this request, still desperately
seeking feedback.

There's somethin i can do, eg saving logs of operation with a driver
and the other and post the logs to this list?
Something other?

Please, halp me at least tracking this problem... Thanks.


----- Forwarded message from Marco Gaiarin <gaio(at)sv(dot)lnf(dot)it> -----
Date: Wed, 23 Mar 2011 09:13:00 +0100
From: Marco Gaiarin <gaio(at)sv(dot)lnf(dot)it>
To: pgsql-odbc(at)postgresql(dot)org
Subject: [gaio(at)sv(dot)lnf(dot)it: [ODBC] Centura 1.5.1: moving from ODBC 8 to 9,
	some trouble]
Organization: La Nostra Famiglia - Polo FVG
X-Mailing-List: pgsql-odbc
X-Spam-Status: No, score=-4.0 required=5.0 tests=AWL,BAYES_00,GREYLIST_ISWHITE
	autolearn=ham version=3.2.5


Sorry, i repost this message, still seeking feedback.

Thanks.

----- Forwarded message from Marco Gaiarin <gaio(at)sv(dot)lnf(dot)it> -----
Date: Wed, 16 Mar 2011 10:20:15 +0100
From: Marco Gaiarin <gaio(at)sv(dot)lnf(dot)it>
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] Centura 1.5.1: moving from ODBC 8 to 9, some trouble
Organization: La Nostra Famiglia - Polo FVG
X-Mailing-List: pgsql-odbc
X-Spam-Status: No, score=-4.0 required=5.0 tests=AWL,BAYES_00,GREYLIST_ISWHITE
	autolearn=ham version=3.2.5


In our organization we have some old apps written in Gupta Centura (AKA
Team Developer 1.5.1):
	http://en.wikipedia.org/wiki/Gupta_Technologies

We use extensively this RAD with Postgers database, using the odbc
driver as a glue.

I've deployed an upgrade of the ODBC driver from 8.XX to 9.XX, and
suddenly these apps stop working, doing strange things.

I'm currently using driver version 09.00.0200, and a simple query like:

	Call SqlPrepareAndExecute(hsql,'select sum(dare),sum(avere) into :daren,:averen from tmp_articoli')

return errors like:

	select sum(dare),sum(avere) into :daren,:averen from tmp_articoli
	Attempt to fetch non-numeric data into numeric column
	Reason: One of the application's sqlssb function calls set up a fetch
		buffer that is defined as numeric but the data that was fetched
		cannot be converted to a numeric value.

postgres (DB) version are 8.3.14 (debian lenny); table schema:

 registra27=# \d tmp_articoli
        Tabella "public.tmp_articoli"
   Colonna   |      Tipo      | Modificatori 
 ------------+----------------+--------------
  narticolo  | integer        | 
  sede_art   | integer        | 
  conto_art  | character(12)  | 
  attiv_art  | integer        | 
  data_art   | date           | 
  tipo       | character(1)   | 
  conto      | character(8)   | 
  descr      | character(250) | 
  dare       | numeric(15,2)  | 
  avere      | numeric(15,2)  | 
  sede       | integer        | 
  attiv      | integer        | 
  cdc        | character(6)   | 
  tipo_prot  | character(2)   | 
  protocollo | integer        | 
  rw         | integer        | 


What changed between odbc driver 8 and 9? Thanks.

-- 
dott. Marco Gaiarin				    GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  marco.gaiarin(at)sv.lnf.it	  tel +39-0434-842711  fax +39-0434-842797

		Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA!
	   http://www.lanostrafamiglia.it/chi_siamo/5xmille.php
	(cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

----- End forwarded message -----

-- 
dott. Marco Gaiarin				    GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  marco.gaiarin(at)sv.lnf.it	  tel +39-0434-842711  fax +39-0434-842797

		Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA!
	   http://www.lanostrafamiglia.it/chi_siamo/5xmille.php
	(cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

----- End forwarded message -----

-- 
dott. Marco Gaiarin				    GNUPG Key ID: 240A3D66
  Associazione ``La Nostra Famiglia''                http://www.sv.lnf.it/
  Polo FVG  -  Via della Bontà, 7 - 33078  -  San Vito al Tagliamento (PN)
  marco.gaiarin(at)sv.lnf.it	  tel +39-0434-842711  fax +39-0434-842797

		Dona il 5 PER MILLE a LA NOSTRA FAMIGLIA!
	   http://www.lanostrafamiglia.it/chi_siamo/5xmille.php
	(cf 00307430132, categoria ONLUS oppure RICERCA SANITARIA)

Responses

pgsql-odbc by date

Next:From: Adrian KlaverDate: 2011-04-01 16:55:33
Subject: Re: [gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]
Previous:From: Marc FrommDate: 2011-03-30 16:33:57
Subject: Re: first time odbc

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