Please Problem With ESQL/C
I am trying to use ESQL for firt time we have IDS 2000 in a RS/6000( AIX 4.3.2) dev/pts/4> esql -V INFORMIX-ESQL Version 7.24.UC5 Software Serial Number ACN#J266163 we never use before ESQL/C ( we develop lots apps in 4GL we want use de Art S. Kagel's dbcopy util from the IIUG when we try to compile we get : /dev/pts/4> esql dbcopy.ec -o dbcopy dbcopy.ec:136: warning: `_H_LOCALEDEF' redefined *Initialization*:1: warning: this is the location of the previous definition /dev/pts/4> when we try to use it we get some like: Error fetching row! Code=-403, ISAM=0. Input: 0 records. Copied: 0 records to silex_ds@silac_tcp:tareas. Logged: 0 records to error log. /dev/pts/4> finderr -403 -403 The size of a received row disagrees with the expected size. This internal error indicates a problem in the communication between the database server and the library functions that call it. Check that your program is at the same software level as the database server in use. If the error recurs, please note all circumstances, and contact the Informix Technical Support Department.
Daniel Esquerre Fernandez wrote: > I am trying to use ESQL for firt time > we have IDS 2000 in a RS/6000( AIX 4.3.2) > > dev/pts/4> esql -V > INFORMIX-ESQL Version 7.24.UC5 > Software Serial Number ACN#J266163 > [SNIP] Hi Daniel, I think you have an incompatible version of ESQL/C You should be able to download a compatible version from the Intraware site, at http://www.intraware.com HTH, Avi. -- /\\ \\ /| Avi Abrami, Analyst/Programmer, Terayon Comms /__\\ \\ / | eMail: avia@terayon.com / \\ \\/ | http://www.terayon.com
Daniel Esquerre Fernandez wrote: > I am trying to use ESQL for firt time > we have IDS 2000 in a RS/6000( AIX 4.3.2) > > dev/pts/4> esql -V > INFORMIX-ESQL Version 7.24.UC5 > Software Serial Number ACN#J266163 > > we never use before ESQL/C ( we develop lots apps in 4GL > we want use de Art S. Kagel's dbcopy util from the IIUG > when we try to compile we get : > > /dev/pts/4> esql dbcopy.ec -o dbcopy > dbcopy.ec:136: warning: `_H_LOCALEDEF' redefined > *Initialization*:1: warning: this is the location of the previous definition > /dev/pts/4> > > when we try to use it we get some like: > > Error fetching row! Code=-403, ISAM=0. > Input: 0 records. > Copied: 0 records to silex_ds@silac_tcp:tareas. > Logged: 0 records to error log. > > /dev/pts/4> finderr -403 > -403 The size of a received row disagrees with the expected > size. > > This internal error indicates a problem in the communication between > the database server and the library functions that call it. Check that > your program is at the same software level as the database server in > use. If the error recurs, please note all circumstances, and contact > the Informix Technical Support Department. > Avi Abrami suggested that you have an incompatible version of ESQL/C, and given that you're using ESQL/C 7.24 with IDS.2000, he's probably right. You should be using Client SDK 2.40, I think; certainly, some version of CSDK. It is available free of charge from the Intraware site (http://www.intraware.com/), as Avi said. Most 7.24 ESQL/C application should be able to talk to the IDS.2000 DBMS without major problems. However, dbcopy isn't an ordinary ESQL/C application; it copies the entire database and therefore has, in theory, to deal with all the data types used in those databases, and there is room to think that Art has not yet done that work for the IUS data types -- I know I've not yet done it for my SQLCMD program, mainly because it is rather hard to do it properly. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>
>Subject: Please Problem With ESQL/C >From: Daniel Esquerre Fernandez desquerre@sil.edu.pe >Date: 01.06.00 01:27 W. Europe Daylight Time >Message-id: <8h48a8$fm$1@news.xmission.com> > > >I am trying to use ESQL for firt time >we have IDS 2000 in a RS/6000( AIX 4.3.2) > >dev/pts/4> esql -V >INFORMIX-ESQL Version 7.24.UC5 >Software Serial Number ACN#J266163 > >we never use before ESQL/C ( we develop lots apps in 4GL >we want use de Art S. Kagel's dbcopy util from the IIUG >when we try to compile we get : > >/dev/pts/4> esql dbcopy.ec -o dbcopy >dbcopy.ec:136: warning: `_H_LOCALEDEF' redefined >*Initialization*:1: warning: this is the location of the previous definition >/dev/pts/4> > >when we try to use it we get some like: > >Error fetching row! Code=-403, ISAM=0. >Input: 0 records. >Copied: 0 records to silex_ds@silac_tcp:tareas. >Logged: 0 records to error log. > >/dev/pts/4> finderr -403 >-403 The size of a received row disagrees with the expected >size. > >This internal error indicates a problem in the communication between >the database server and the library functions that call it. Check that >your program is at the same software level as the database server in >use. If the error recurs, please note all circumstances, and contact >the Informix Technical Support Department. > > > > > > > get a client - SDK 2.40 Nona