Re: Problem with ADODataSet

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

Article #2981

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

#2981

From: Mark Guerrieri
Date: Tue, 14 Jan 2003 02:40

31 lines
2087 bytes

Try setting the Connection property AFTER you set the CommandText.  I don't
know why,  but I've run into similar problems when manipulating the SQL of a
TADODataSet ot TADOQuery when the Connection was set...

Mark

"Matrix" <flavio.bariLsonLe@elLsag.Lit> wrote in message
news:3e22d4c2@newsgroups.borland.com...
> I've a problem with TADODataSet component: in my form there are a
> TADOConnection (which name is "conn") and TADODataSet (which name is
"rs").
> The ConnectionString property of TADOConnection value is :
> Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=D:\SCMV\DBConf\SMCV_Config.mdb;Mode=ReadWrite|Share Deny
None;Persist
> Security Info=False
>
> This is my code:
>
> rs->Connection = conn;
> rs->CommandType = cmdText;
> rs->CommandText = "SELECT * FROM MODULE";
> rs->Open();
>
> The program gives me an EOleException (unspecified error) in the last
> statement.
> Any suggest???
> How can I open a result set and retrieve values with these component???
> TIA.
>
>

Technical Details

Message-ID: <3e2378aa@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed2.earthlink.net!newsfeed.earthlink.net!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <3e22d4c2@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,d8356b91db362088
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-01-13 19:06:23 PST
From: "Mark Guerrieri" <markg11@comcast.net>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3e22d4c2@newsgroups.borland.com>
Subject: Re: Problem with ADODataSet
Date: Mon, 13 Jan 2003 21:40:49 -0500
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 68.44.67.205
Message-ID: <3e2378aa@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1042512042 68.44.67.205 (13 Jan 2003 18:40:42 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!64.152.100.70.MISMATCH!sjc70.webusenet.com!news.webusenet.com!newsfeed2.earthlink.net!newsfeed.earthlink.net!newsfeed.news2me.com!border1.nntp.aus1.giganews.com!nntp.giganews.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message