EOleException with ODBC-Provider

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

Article #3748

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

#3748

From: Thomas Wagener
Date: Tue, 02 Jul 2002 13:27

29 lines
1607 bytes

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: <3d21aa5d_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!logbridge.uoregon.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3d4eab4134d353e5,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-07-02 06:31:16 PST
From: "Thomas Wagener" <Thomas.Wagener@web.de>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: EOleException with ODBC-Provider
Date: Tue, 2 Jul 2002 15:27:56 +0200
Lines: 31
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: 217.0.58.207
Message-ID: <3d21aa5d_1@dnews>
X-Trace: dnews 1025616477 217.0.58.207 (2 Jul 2002 06:27:57 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!supernews.com!logbridge.uoregon.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews