ADOQuery causing EOleException when assigning a query in the SQL property

Article View: borland.public.cppbuilder.database.ado

Article #4019

Back to borland.public.cppbuilder.database.ado Previous Next

#4019

From: Andre Schutte
Date: Fri, 19 Apr 2002 17:41

31 lines
1747 bytes

Hi

I'm using a TADOQuery, and I can't seam to get it working... My code for
example is as follows..

01:    TADOQuery *ADOQuery = new TADOQuery(NULL);
02:
03:    ADOQuery->Connection=<my connection here>;
04:    ADOQuery->SQL->Clear();
05:    ADOQuery->SQL->Add("SELECT * FROM MYTABLE");
06:    ADOQuery->Prepared=true;
07:    ADOQuery->Open();
08:
09:    // do something here...
10:
11:    delete ADOQuery;

if i step through this code, as soon as line 05 executes, i get the message
saying...
Exception EOleException in module mymodule.dll at 000695b5.

If I attempt the exact same thing using TQuery it works just fine.

I have also attempted using the ADOConnection and ADOQuery components on
a blank project, and I get the same error

any ideas? please

thanx in advance

Andre

Technical Details

Message-ID: <3cc056de_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,1608fe99098d5a18,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-04-19 11:04:38 PST
Reply-To: "Andre Schutte" <sirbrane@webmail.co.za>
From: "Andre Schutte" <sirbrane@webmail.co.za>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADOQuery causing EOleException when assigning a query in the SQL property
Date: Fri, 19 Apr 2002 19:41:24 +0200
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 163.203.147.23
Message-ID: <3cc056de_1@dnews>
X-Trace: dnews 1019238110 163.203.147.23 (19 Apr 2002 10:41:50 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!supernews.com!newsfeed.online.be!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews