🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: EOleException with ODBC-Provider

#3753
From: Vassiliev V.V.
Date: Wed, 03 Jul 2002 07:49
42 lines
2084 bytes
What is an error (EOleException.ErrorCode)? You may have, for example,
read-only dataset or have no bookmarks support.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com


"Thomas Wagener" <Thomas.Wagener@web.de> �������/�������� � ��������
���������: news:3d21aa5d_1@dnews...
> Hi everybody,
>
> I have a problem with changing a TADODataset row using a TADOConnection
with
> the Odbc OLEDB provider. The program works fine when I use the Jet Oledb
> provider.
> The essential setup is a follows:
>
> TADOConnection* pDbConnection = new TADOConnection();
> pDbConnection->CusorLocation = clUseServer;
> pDbConnection->Open();
> pDbConnection->BeginTrans();
> // set up ADO connection with MSDASQL
> TADODataset* pDataset = new TADODataset();
> pDataset->Connection = pDbConnection;
> // set up QueryString etc.
> pDataset->Open();
> pDataset->Edit();
> // doing changes here
> pDataset->Post();
> // ^^^^^^^^^^ throws EOleException
> pDataset->Close();
> pDbConnection->CommitTrans();
> pDbConnection->Close();
>
> Is there a work-around for this or am I doing something wrong?
>
> Thank you,
>
> Thomas
>
>
Technical Details
Message-ID: <3d22aea2_1@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-08!supernews.com!newspump.sol.net!news-out.visi.com!hermes.visi.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews
References: <3d21aa5d_1@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,3d4eab4134d353e5
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-07-03 01:03:57 PST
From: "Vassiliev V.V." <news@vassilievvv.mtu-net.ru>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3d21aa5d_1@dnews>
Subject: Re: EOleException with ODBC-Provider
Date: Wed, 3 Jul 2002 11:49:14 +0400
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 62.118.134.114
Message-ID: <3d22aea2_1@dnews>
X-Trace: dnews 1025683106 62.118.134.114 (3 Jul 2002 00:58:26 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-08!supernews.com!newspump.sol.net!news-out.visi.com!hermes.visi.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews