Re: D5 with ADO



> I was looking at that... I downloaded Adonis and I'm having trouble.
> I'm just not ADO savvy ... yet and there is no help.
>
> Is DeerSoft intuitive or will I be stuck in the same spot?

I found it to be pretty simple. But it does help to be somewhat familiar
with ADO and the parameters it needs because the help file is very sparse.
However, there is a demo application that comes with the library.

Basically, you get 4 components: DMaster, DTable, DQuery, and DUpdateQuery.
DMaster is the "connection" component. So all you do is set
DMaster.Connection := MyConnStr; and DMaster.Connected := True; and you're
connected to the database via ADO (assuming you have the right parameters
set in MyConnStr, of course). If you need to build the connection string
using the standard multi-page ADO Connection builder, just call the
DConnectionEditor.Execute function.

Then you set DTable.Master := DMaster and you have your ADO Table component
ready. Likewise with DQuery and DUpdateQuery.

There are some nice utililty functions in one of the units, DUtils.pas--most
of which have nothing to do with ADO (like converting a number to Roman
Numeral string). It's worth downloading just for this free code (although
some of it is now obsolete with newer versions of Delphi).

It comes with packages for Delphi versions 4 through 7.

--
David Cornelius
http://CorneliusConcepts.com


.



Relevant Pages

  • Re: C++ support for ADO
    ... TESTHR(pConn.CreateInstance(__uuidof(Connection))); ... In answer to your question I'm interested in ADO not the ADO.net. ... data classes for working with ADO/OLE DB. ... You can also use the OLE SDK. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.oledb)
  • Re: How to make the app run?????
    ... throwing an error if the connection never was opened, ... How can i tell if i'm using ADO as in VB or .Net ADO ?? ... First of all, it was not shown to my customer, I took it to a very nice ... How do you get in "installed" on client computer? ...
    (microsoft.public.dotnet.general)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.ado)