TADOClientDataset?

I'd like to use ADO only, no BDE, IBX, etc. I'd like to populate a
TADODataset at run-time, and all in memory. I'd then like to be able
to use TADOQuery to query this data. Is this possible?

I'm currently using TClientDataset to create an in-memory dataset,
which works fine. However, I like the features which I can do with
TADOQuery, and another library I'm trying to use requires data to come
from a TADOQuery -- not a TClientDataset.

When I right-click on a TADODataset and select "CreateDataset", it
appears to work at design-time. If I connect that dataset to a DBGrid
I'm able to see my fields. However, whenever I run the program I get
"missing connection or connection string". Do I really need to set a
connection string? I guess maybe I do, in order for the components to
know what provider to use, and other params. However, I don't want to
specify a database name, because I'm trying to do this all in memory.
I also don't care what format or provider it uses, at least I don't
think so (with TClientDataset I don't have to worry about this).

.

Relevant Pages

  • Re: Memory Leak using TADODataset
    ... memory problems using TADODataSet and TADOQuery. ... >Using 100 iterations of the code below, ... The 'report' proc just writes ...
    (borland.public.delphi.database.ado)
  • Re: Connection String
    ... The only reason would be to not have to decrypt it every time, ... Besides, even if it was being stored in plain text, ... do you think one string the size of a connection string would take up enough ... memory for it to actually make a difference? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best practices
    ... Some people use a dataset to make a copy of all the data in memory, then they don't succeed and show their failures by saying things like you have heard and go back to the old simulating punch card systems on disk they were used to. ... About the memory, be aware that OOP programming is not anymore using principles of 1980, it is for sure spending more memory. ... Into a form I´ve made my connection string and my SqlConnection variable. ... I read a lof ot tutorials but each of show a differente manner and opinion. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: TxQuery download or similar component?
    ... Does this 'CDS' memory table work intuitively? ... I'll drop a TSQLConnection, a TSQLDataset, a TProvider and a TClientDataSet ... At design time I'll copy the field definitions from the "raw" cds ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: ANN: SuperFastDistinct! -- 5x, 10x, 100x faster than SQLs Select Distinct ...
    ... Will it work with a TClientDataset? ... manually traversing the table to find duplicates using your own code. ... to find the distinct CustName index values in CustTable and put them into the ComboBox1 (or any ... comparable to our benchmarks done with TkbmMemTable which is a memory table. ...
    (borland.public.delphi.thirdpartytools.general)