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

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

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Marco Gaiarin <gaio(at)sv(dot)lnf(dot)it>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [gaio@sv.lnf.it: [gaio@sv.lnf.it: Centura 1.5.1: moving from ODBC 8 to 9, some trouble]]
Date: 2011-04-05 03:45:22
Message-ID: 4D9A9052.9000102@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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(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.

In response to

pgsql-odbc by date

Next:From: Josef SpringerDate: 2011-04-05 08:27:26
Subject: Re: 08.02.04.00 Updating column with Unicode
Previous:From: Hiroshi InoueDate: 2011-04-05 03:38:35
Subject: Re: 08.02.04.00 Updating column with Unicode

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