Thread: [gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]
[gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]
From
Marco Gaiarin
Date:
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@sv.lnf.it> -----
Date: Wed, 23 Mar 2011 09:13:00 +0100
From: Marco Gaiarin <gaio@sv.lnf.it>
To: pgsql-odbc@postgresql.org
Subject: [gaio@sv.lnf.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@sv.lnf.it> -----
Date: Wed, 16 Mar 2011 10:20:15 +0100
From: Marco Gaiarin <gaio@sv.lnf.it>
To: pgsql-odbc@postgresql.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@postgresql.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@postgresql.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)
Re: [gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]
From
Adrian Klaver
Date:
On 04/01/2011 09:04 AM, Marco Gaiarin wrote: > > 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. > Well the releases notes are here: http://psqlodbc.projects.postgresql.org/release.html Maybe something will stand out. What version of 8.x are you moving from? What is the set up to the 'Call SqlPrepareAndExecute ' statement? Where are the error messages coming from, it does not look like a Postgres message? -- Adrian Klaver adrian.klaver@gmail.com
Re: [gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]
From
Hiroshi Inoue
Date:
Hi Marco, (2011/04/02 1:04), Marco Gaiarin wrote: > > 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. Could you take the Mylog output and send it to me directly? regards, Hiroshi Inoue > > ----- Forwarded message from Marco Gaiarin<gaio@sv.lnf.it> ----- > Date: Wed, 23 Mar 2011 09:13:00 +0100 > From: Marco Gaiarin<gaio@sv.lnf.it> > To: pgsql-odbc@postgresql.org > Subject: [gaio@sv.lnf.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@sv.lnf.it> ----- > Date: Wed, 16 Mar 2011 10:20:15 +0100 > From: Marco Gaiarin<gaio@sv.lnf.it> > To: pgsql-odbc@postgresql.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.
Re: [gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]
From
Marco Gaiarin
Date:
Mandi! Adrian Klaver In chel di` si favelave... > Well the releases notes are here: > http://psqlodbc.projects.postgresql.org/release.html > Maybe something will stand out. Changelog was the first place i've looked ok, but i've found nothing relevant... > What version of 8.x are you moving from? Latest one, 8.4.2.0 > What is the set up to the 'Call SqlPrepareAndExecute ' statement? Bah, a normal ''prepare ad execute'' (or execute immediate) statement... > Where are the error messages coming from, it does not look like a > Postgres message? Centura interpret backend error and present in a uniform way, so really i don't know if these are ODBC or driver error... Now i send in private mylogs to Hiroshi. Thanks to all. -- 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)