Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxx0cm, www.webdp.net, Event 9 IIS log failed to write entry, wwwxxx jeffs, Catastrophic failure Unexpected method call sequence. 0x8000ffff (-2147418113)., ksh lock a file, [unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_DBC failed, sed: -e expression #1, char 1: unterminated address regex, procmail + change subject, w2ksp4.exe download

Links

XODOX
Impressum

#1: Centura 1.5.1: moving from ODBC 8 to 9, some trouble

Posted on 2011-03-16 10:20:15 by Marco Gaiarin

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

Report this message