Re: BDE vs ADO

From: Jeremy Collins (jd.collins_at_ntlworld-not.com)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 08:44:16 +0000

Christian Charest wrote:

> I'm working with an access database with a lot of stored procedurs.

Then it's probably a good idea to switch to ADO. The ADO
datasets have very similar methods to the BDE equivalent,
and they still connect to the same data-aware components
via TDataSource, so the transition shouldn't be too hard.

I recommend you you TADODataSet, rather than TADOTable,
since this will make your life much easier if your app
gets upgraded to SQL Server or similar. The TADODataSet
can also return a recordset from a stored procedure,
and if you have SPs that INSERT, UPDATE or similar then
you can use TADOCommand or TADOStoredProc.

I assume you're using a TDataModule already; if not this
is a good time to start. Drop a TADOConnection on your data
module, and build the connection string; it will be something
like
   Provider=Microsoft.Jet.OLEDB.4.0;
   Data Source=c:\YourDB.mdb;
   Persist Security Info=False

You then set your TADODataSet's Connection propery to this
connection object.

You might also want to start reading the
borland.public.delphi.database.ado newsgroup.

HTH 

-- 
jc
Remove the -not from email

Relevant Pages

  • Re: (Bill are you there ?) question to Bill Todd and community / ADODB Unit in D7 Enterprise
    ... - 100% Delphi (WebBroker CGI/ISAPI) ... ADO (TADODataSet, TADOCommand) ...
    (borland.public.delphi.database.ado)
  • 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)