Board index » delphi » Disadvantages?: Delphi ADO and MS SQL Server 7.0/2000

Chad Noles

Delphi Developer
Sat, 18 Oct 2003 23:04:32 GMT

Disadvantages?: Delphi ADO and MS SQL Server 7.0/2000

   Are there any major problems with using Delphi's ADO objects
and MS SQL Server 7.0 or 2000?  So far, I haven't seen any.
I was even able to update a multi-database table join through a
data bound control without using cached updates or a client dataset.
Anybody notice any problems with this configuration?

Thanks,
Chad Noles

 
Justin Pitt

Delphi Developer
Sat, 18 Oct 2003 23:46:21 GMT

Re:Disadvantages?: Delphi ADO and MS SQL Server 7.0/2000


it screams for me, both with remote client type apps and local, batch style
server apps.
Michael Rodrigue

Delphi Developer
Sun, 19 Oct 2003 00:26:42 GMT

Re:Disadvantages?: Delphi ADO and MS SQL Server 7.0/2000


Works great for me.

--
Michael Rodriguez
Compeat Restaurant Accounting Systems
http://www.compeat.com
m...@compeat.com

Quote
"Chad Noles" <cno...@btg.com> wrote in message news:3aeed068_2@dnews...
>    Are there any major problems with using Delphi's ADO objects
> and MS SQL Server 7.0 or 2000?  So far, I haven't seen any.
> I was even able to update a multi-database table join through a
> data bound control without using cached updates or a client dataset.
> Anybody notice any problems with this configuration?

> Thanks,
> Chad Noles

Sunil Furtad

Delphi Developer
Mon, 20 Oct 2003 12:41:32 GMT

Re:Disadvantages?: Delphi ADO and MS SQL Server 7.0/2000


    If I remember correctly, Borland ADOExpress and BatchUpdates in a M/D
relationships has some bugs. I myself use ClientDatasets for my M/D's. Other
than that ADO does work pretty well against MS Databases.
--
Sunil Furtado
New Mangalore Port Trust
Quote
Chad Noles <cno...@btg.com> wrote in message news:3aeed068_2@dnews...
>    Are there any major problems with using Delphi's ADO objects
> and MS SQL Server 7.0 or 2000?  So far, I haven't seen any.
> I was even able to update a multi-database table join through a
> data bound control without using cached updates or a client dataset.
> Anybody notice any problems with this configuration?

> Thanks,
> Chad Noles

Other Threads

1. Delphi 5 - ADO - MS SQL Server 2000

2. Delphi 5.0, ADO and MS SQL Server 7.0

3. Sql Server 2000 & Sql Server 7.0

4. ADO and MS SQL-Server 2000 and Multithread

5. ADO Refresh with Ado Table and ADO Query on a network application with SQL Server 2000

6. DELPHI ADO & MS SQL 2000 Requery question

7. Delphi 6, MS-SQL 2000, ADO and international support

8. Multiple Transactions with ADO using MS SQL Server 7.0

9. ADO on MS SQL 7.0 Clusert Server

10. ADO + MS SQL Server 7.0 Identity Fields!!!