Article View: borland.public.cppbuilder.database.ado
Article #101Re: How to Convert TDataSet to TADO Recordset
From: Vassiliev V. V.
Date: Thu, 23 Aug 2007 19:21
Date: Thu, 23 Aug 2007 19:21
66 lines
3962 bytes
3962 bytes
Intent was really to persuade you to not continue in this direction. Did Crystal Reports stopped support BDE? If not, you could connect to BDE tables directly, without datasets. Or connect to DBF/Paradox files with Jet OLEDB provider (there may be problems with update Paradox tables, but in read-only mode this may work). If you still want to continue with creating recordset wrapper for TDataSet (in this case through special OLEDB provider), look at: http://www.dataweb.de/en/support/articles/ospdelphi/ospdelphi.html http://msdn2.microsoft.com/en-us/library/aa160399(office.11).aspx However it could take much more time and efforts than you expect. //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "Sinead Bunyan" <nospamSBUNYAN@DAIRYMASTER.COM> ???????/???????? ? ???????? ?????????: news:46cdbe15@newsgroups.borland.com... > Hi Clayton, > > I am basically incorporating Crystal Reports 11 into an existing c++ > project. Previously we had used a component from a company called > Suprasoft, which allowed us to pass a TDataSet to report templates and > using TTX files we could display our reports accordingly. In this way we > did not have to specify the data location when designing the reports. > > However (!), we now are faced with using Crystal Reports 11, which > requires that data be passed to the reports as an ADO recordset. Because > it is an existing project, all datasets are created and ideally we would > like a way to work from the existing datasets - we do not want to change > all TDataSet components to TADODataSets and also we do not want to have to > generate these datasets twice (once to populate our TDataSet, and once to > populate a TADODataSet). Hopefully this is making sense? > > Any suggestions would be greatly appreciated - I have a very limited > knowledge of ADO objects, sorry for my ignorance on this subject! > > Thanks in advance, > Sinead > > > "Clayton Arends" <nospam_claytonarends@hotmail.com> wrote in message > news:46cdb750$1@newsgroups.borland.com... >>> Thank you for your help on this, at least now I know that it is possible >>> and can work from there. >> >> I believe the intent was to persuade you to not continue in this >> direction. >> >> Perhaps you can explain a little about the types of 'Rpt' and 'Database' >> and what functionality you are after. There might be other alternatives >> that you can pursue once a little more is known about your problem. >> >> - Clayton >> >> >
Technical Details
Message-ID:
<46cdde35@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<46cd6ffd@newsgroups.borland.com> <46cd9901@newsgroups.borland.com> <46cdb544$1@newsgroups.borland.com> <46cdb750$1@newsgroups.borland.com> <46cdbe15@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,629b3b97691ea625 X-Google-Attributes: gid10698b,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Vassiliev V. V." <support@oledbdirect.com> Newsgroups: borland.public.cppbuilder.database.ado References: <46cd6ffd@newsgroups.borland.com> <46cd9901@newsgroups.borland.com> <46cdb544$1@newsgroups.borland.com> <46cdb750$1@newsgroups.borland.com> <46cdbe15@newsgroups.borland.com> Subject: Re: How to Convert TDataSet to TADO Recordset Date: Thu, 23 Aug 2007 23:21:04 +0400 Lines: 68 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-RFC2646: Format=Flowed; Response X-Antivirus: avast! (VPS 000768-0, 23.08.2007), Outbound message X-Antivirus-Status: Clean NNTP-Posting-Host: 85.93.138.132 Message-ID: <46cdde35@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1187896885 85.93.138.132 (23 Aug 2007 12:21:25 -0700) Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail