From mboxrd@z Thu Jan 1 00:00:00 1970 X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me X-Spam-Level: X-Spam-Status: No, score=-2.9 required=5.0 tests=BAYES_00,MAILING_LIST_MULTI autolearn=unavailable autolearn_force=no version=3.4.4 X-Google-Language: ENGLISH,ASCII X-Google-Thread: 103376,7179b046d1b6799f X-Google-Attributes: gid103376,public X-Google-ArrivalTime: 2003-12-19 17:57:45 PST Path: archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!priapus.visi.com!orange.octanews.net!news.octanews.net!news-out.visi.com!petbe.visi.com!proxad.net!usenet-fr.net!enst.fr!melchior!cuivre.fr.eu.org!melchior.frmug.org!not-for-mail From: Stephen Leake Newsgroups: comp.lang.ada Subject: Re: GNADE insert problem Date: 19 Dec 2003 20:55:32 -0500 Organization: Cuivre, Argent, Or Message-ID: References: NNTP-Posting-Host: lovelace.ada-france.org Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: melchior.cuivre.fr.eu.org 1071885384 45063 80.67.180.195 (20 Dec 2003 01:56:24 GMT) X-Complaints-To: usenet@melchior.cuivre.fr.eu.org NNTP-Posting-Date: Sat, 20 Dec 2003 01:56:24 +0000 (UTC) To: comp.lang.ada@ada-france.org Return-Path: In-Reply-To: User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 X-Virus-Scanned: by amavisd-new-20030616-p5 (Debian) at ada-france.org X-BeenThere: comp.lang.ada@ada-france.org X-Mailman-Version: 2.1.3 Precedence: list List-Id: Gateway to the comp.lang.ada Usenet newsgroup List-Unsubscribe: , List-Post: List-Help: List-Subscribe: , Xref: archiver1.google.com comp.lang.ada:3600 Date: 2003-12-19T20:55:32-05:00 Jano writes: > Hello, I'm using GNADE and esql to insert some records in a database.=20 You should also try the gnade mailing list gnade-develop@lists.sourceforge.net. > Line 79 in package Aenea.Db : *** Exception in query **** >=20 > SQL State : 42000 SQL Code :-1 > --------------- > [17:32:38.42] [E] Database insertion failed: Exception name:=20 > GNU.DB.SQLCLI.INVALID_CURSOR_STATE > Message: [Proc=3DSQLCloseCursor][Server=3Dhyperion][State=3D24000][Micros= oft] > [Controlador ODBC Microsoft Access]Estado del cursor no v=E1lido > Call stack traceback locations: > 0x438ee3 0x439bf6 0x439ef1 0x43b7cd 0x48c8ef 0x6ba969 0x6d5962 >=20 > As you can see, it seems as if some cursor were left open and tried to=20 > be reused. I've found just an example of insertion and I can see=20 > anything special there. >=20 > I don't know if I'm doing something wrong or it is the fault of MSAccess= =20 > or esql.=20 This is definitely an esql problem. I suggest you abandon esql, and use the gnu-db-sqli package directly instead. It's more robust, and really not that hard. I've used gnu-db-sql to access MySQL via ODBC quite successfully. The code generated by esql I've looked at has definite problems. --=20 -- Stephe