Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 7E9239FA4D1 for ; Wed, 17 Oct 2007 15:59:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 27851-02-2 for ; Wed, 17 Oct 2007 15:59:35 -0300 (ADT) X-Greylist: delayed 00:09:54.065254 by SQLgrey-1.7.5 Received: from hq-ipt01.anteon.com (hq-ipt01.anteon.com [198.185.182.20]) by postgresql.org (Postfix) with ESMTP id CBF239F948D for ; Wed, 17 Oct 2007 15:59:35 -0300 (ADT) Received: from hq-exout01.anteon.com ([10.170.1.216]) by hq-ipt01.anteon.com with ESMTP; 17 Oct 2007 14:49:38 -0400 X-SENDER-IP: 10.170.1.216 X-SENDER-REPUTATION: None X-IronPort-AV: i="4.21,290,1188792000"; d="scan'208,217"; a="65377998:sNHT4305039144" Received: from HQ-EXVS02.anteon.com ([10.170.1.143]) by HQ-EXOUT01.anteon.com with Microsoft SMTPSVC(6.0.3790.3959); Wed, 17 Oct 2007 14:49:38 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C810EE.78146376" Subject: Date: Wed, 17 Oct 2007 14:49:37 -0400 Message-ID: <258593F548C79D4AB7CBA2AE72DEBEC803D0D5B6@HQ-EXVS02.anteon.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Index: AcgQ7neODDjzrsm7QMeygIovYlWQWQ== From: "Boergesson, Cheryl" To: X-OriginalArrivalTime: 17 Oct 2007 18:49:38.0315 (UTC) FILETIME=[7817DDB0:01C810EE] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/83 X-Sequence-Number: 29455 This is a multi-part message in MIME format. ------_=_NextPart_001_01C810EE.78146376 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hello. I am trying to upgrade from PostgreSQL 8.0.3 to PostgreSQL 8.1.10. I have a very simple routine that works fine with the 8.0.3 version: =20 int easy_connect() { exec sql connect to my_db as my_cnxtn; printf ("connection results:\n"); printf ("code: %d\n", sqlca.sqlcode); printf ("state: %s\n", sqlca.sqlstate); printf ("warn: %s\n", sqlca.sqlwarn); exec sql begin work; exec sql commit work; return 0; } =20 When I use the 8.1.10 version, the connection works ( sqlca.sqlcode is 0, sqlca.sqlstate is 0000 and sqlca.sqlwarn is blank). But it then crashes on the "exec sql begin work" line. =20 I get the following error in a window: =20 Runtime Error! =20 Program: C:\testSQL.exe =20 This application has requested the Runtime to terminate it in an unusual way. Please contact the application's support team for more information. =20 I removed the 8.0.3 version using "remove program" from the control panel. I then went and removed my C:\Program Files\PostgreSQL\8.0 folder, just to make sure I was not including the wrong header files, linking to the wrong libraries, or calling the wrong version of ecpg.exe. =20 Thanks for any help. -Cheryl =20 ------_=_NextPart_001_01C810EE.78146376 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hello. I am trying to upgrade from PostgreSQL = 8.0.3 to PostgreSQL 8.1.10. I have a very simple routine that works fine = with the 8.0.3 version:

int = easy_connect()

{

exec sql connect to my_db as my_cnxtn;

printf ("connection results:\n");

printf ("code: %d\n", sqlca.sqlcode);

printf ("state: %s\n", sqlca.sqlstate);

printf ("warn: %s\n", sqlca.sqlwarn);

exec sql begin work;

exec sql commit work;

return 0;

}

When I use the 8.1.10 version, the connection works ( sqlca.sqlcode is 0, sqlca.sqlstate is 0000 and sqlca.sqlwarn is = blank). But it then crashes on the “exec sql begin work” = line.

I get the following error in a = window:

Runtime = Error!

Program: = C:\testSQL.exe

This application has = requested the Runtime to terminate it in an unusual way.

Please contact the = application’s support team for more information.

I removed the 8.0.3 version using “remove = program” from the control panel. I then went and removed my C:\Program Files\PostgreSQL\8.0 folder, just to make sure I was not including the = wrong header files, linking to the wrong libraries, or calling the wrong = version of ecpg.exe.

Thanks for any help.

-Cheryl

------_=_NextPart_001_01C810EE.78146376--