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

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 -----
Date: Wed, 23 Mar 2011 09:13:00 +0100
From: Marco Gaiarin
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=3D-4.0 required=3D5.0 tests=3DAWL,BAYES_00,GREYLIS=
T_ISWHITE
autolearn=3Dham version=3D3.2.5


Sorry, i repost this message, still seeking feedback.

Thanks.

----- Forwarded message from Marco Gaiarin -----
Date: Wed, 16 Mar 2011 10:20:15 +0100
From: Marco Gaiarin
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=3D-4.0 required=3D5.0 tests=3DAWL,BAYES_00,GREYLIS=
T_ISWHITE
autolearn=3Dham version=3D3.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,:a=
veren 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=3D# \d tmp_articoli
Tabella "public.tmp_articoli"
Colonna | Tipo | Modificatori=20
------------+----------------+--------------
narticolo | integer |=20
sede_art | integer |=20
conto_art | character(12) |=20
attiv_art | integer |=20
data_art | date |=20
tipo | character(1) |=20
conto | character(8) |=20
descr | character(250) |=20
dare | numeric(15,2) |=20
avere | numeric(15,2) |=20
sede | integer |=20
attiv | integer |=20
cdc | character(6) |=20
tipo_prot | character(2) |=20
protocollo | integer |=20
rw | integer |=20


What changed between odbc driver 8 and 9? Thanks.

--=20
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bont=E0, 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)

--=20
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 -----

--=20
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bont=E0, 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)

--=20
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 -----

--=20
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bont=E0, 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)

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

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

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

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

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

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 -----
> Date: Wed, 23 Mar 2011 09:13:00 +0100
> From: Marco Gaiarin
> 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 -----
> Date: Wed, 16 Mar 2011 10:20:15 +0100
> From: Marco Gaiarin
> 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.

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

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

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.

--=20
dott. Marco Gaiarin GNUPG Key ID: 240A3D66
Associazione ``La Nostra Famiglia'' http://www.sv.lnf.it/
Polo FVG - Via della Bont=E0, 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)

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