Sample project to demonstrate connecting via ADO

From: Bob Dalton (bob.dalton_at_removeme_digitallogistics.com)
Date: 07/10/04


Date: Sat, 10 Jul 2004 14:01:00 -0500

I use ADO to connect from my client to the MSSQL 2000 database tables in my
commercial products very successfully and the ADO mechanism appears fairly
robust and easy
to use on networks with few reported problems to date.

Some time ago I authored and released on Borland Code Central the following:

ADO Test Project for Delphi 7.0 Pro
This project demonstrates how to connect to MSSQL 2000 using the ADO
components in Delphi 7.0 Pro.

http://codecentral.borland.com/codecentral/ccweb.exe/listing?id=20677

If the link does not work just copy and paste it into your browser.

This project uses one of the tables in the Northwind database of MSSQL so
you can see how all of this is supposed to work (from the ADO Connection
side).

Hope this helps all you which have questions on this....

Regards;

Bob Dalton



Relevant Pages

  • Re: Could not Update; Currently Locked
    ... > Pro and an Access 2000 database and connecting via ADO. ...
    (borland.public.delphi.database.ado)
  • Re: Conversion from BDE to ADO
    ... I've noticed no performance problems with ADO and MSSQL. ... conversion). ... > I am currently experimenting with converting a quite large app from BDE to ...
    (borland.public.delphi.database.ado)
  • RE: Database connectivity
    ... knew that you should be able to use ADO for MSSQL connections, ... > Subject: Database connectivity ... > I've written a database front-end using ...
    (comp.lang.python)
  • Re: ADO/MYSQL
    ... Mikael Eriksson wrote: ... should really be no difference if you are using ADO. ... ADO is native to MSSQL and therefore the XML file ... happen for MySQL ...
    (borland.public.delphi.database.ado)
  • Re: Speed problem with mssql 2000 and ado
    ... > We are evaluating ado with delphi 7. ... Our application uses the bde to ... Now we are using nvarchar and ntext in our mssql ... > With Oracle we have no speed problems. ...
    (borland.public.delphi.database.ado)