TDataset -> _RecordSet

From: Massilia (massilia_at_jehaielespam.com)
Date: 08/28/04


Date: Sat, 28 Aug 2004 22:09:52 +0200

Hi all,

I have a little question, I hope someone will be able to help me.
First, I must point out that I am not really an expert in databse, as you
will see further :)

We have a delphi 4 app, using a commercial set of components (S.DAC) to
access a SQL Server database.
For example, one of the components is a TSPQuery derived from TDataSet.
The app is working like a charm since months.

Now we are trying to build an activex dll to use our app features from ASP
and a browser..
1. We managed to build a dll that have a function that returns a
_recordSet -> but, on the other hand, we have a TdataSet type as a result of
our query. We can't figure out how to "convert" from dataset to recordset
(if such a thing is possible)
2. We tried to have the function returning a TDataSet -> no luck

Before rewriting a significant part of the code, using ADO instead of our
commercial component, we would like to be sure that we don't miss a simple
way to do what we want.
Maybe my question is stupid, as I don't know anything (for the moment), to
ADO, OLEDB, and so on.
If so, I humbly apologize ;)

Cheers,

Massilia



Relevant Pages

  • Re: Passing an ADO recordset using remoting
    ... recordset not being part of the framework. ... and pass it from the server to client using remoting. ... ADTG is not as efficient for ADO data retrieval as the time to transmit the ... DL embedded in the one app. ...
    (microsoft.public.dotnet.framework.remoting)
  • Re: DAO to ADO conversion of seek
    ... I believe that the SQL is the best way to go too. ... > recordset and use some methods of the recordset to search. ... >> My task is to migrate to ADO. ... The current version of the app uses an MDB, ...
    (microsoft.public.vb.database.ado)
  • Re: Run ADO/OLE DB from a CD-R
    ... > I need to get my VB6 app. ... > installing any files onto the host machine, or making any registry entries of ... > also have had Visual Studio installed, however on all other machines, the ADO ... Do you mean the bound-control 'ADODC' when you say 'ADO control'? ...
    (microsoft.public.data.ado)
  • Re: Run ADO/OLE DB from a CD-R
    ... using ADO/OLE Db from a CD. ... I need to get my VB6 app. ... also have had Visual Studio installed, however on all other machines, the ADO ... I've tried to include all possible files on the CD (MDAC, ADO, Jet, etc etc) ...
    (microsoft.public.data.ado)
  • Re: DataGrid, DataBinding, ... help!
    ... I'm not using ADO. ... ADO is not the backend database engine, it is a data access layer that ... interprets between your app and that backend. ...
    (microsoft.public.vb.general.discussion)