Article View: borland.public.cppbuilder.database.ado
Article #4784ADO and InterBase
From: Roman Bouchner
Date: Tue, 25 Sep 2001 14:34
Date: Tue, 25 Sep 2001 14:34
29 lines
1780 bytes
1780 bytes
Hi
I have some problem with using ADO and InterBase database. I am using ODBC
(Gemini EasySoft) and in both cases there is this problem:
/* part A*/
query->SQL->Text = "SELECT * FROM SysLevels";
q->Open();
int c = q->Fields->FieldByName("id")->AsInteger;
q->Close();
/* part B*/
query->SQL->Text = "INSERT INTO DocFTP (Title, BaseDir) VALUES
('test','test')";
query->ExecSQL(); /* There is Access Violation error */
If I execute these parts separately, it does work, but when I execute part B
after part A, there is "Access Violation Error"
Could anyone help me? I really don't know how to solve this situation. I
suppose it
could be because of bad implementation of ADO component.
I have been trying others ODBC drivers and OLE DB drivers, but I found only
other problems (typically with Access Violation Error).
I am using:
Borland C++ EnterPrise 5.0 with updatepack1 and ADOupdate.
Interbase 6.0 and InterBase 6.1
patch MDA 2.6
Thanks
Roman
Technical Details
Message-ID:
<3bb09649_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,364a8b0faf6980f9,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-09-25 07:43:31 PST From: "Roman Bouchner" <bouchner@aipsafe.cz> Newsgroups: borland.public.cppbuilder.database.ado Subject: ADO and InterBase Date: Tue, 25 Sep 2001 16:34:23 +0200 Lines: 36 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 62.24.72.15 Message-ID: <3bb09649_1@dnews> X-Trace: dnews 1001428553 62.24.72.15 (25 Sep 2001 07:35:53 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews