Article View: borland.public.cppbuilder.database.ado
Article #3753Re: EOleException with ODBC-Provider
From: Vassiliev V.V.
Date: Wed, 03 Jul 2002 07:49
Date: Wed, 03 Jul 2002 07:49
42 lines
2084 bytes
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!dnewsReferences:
<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