Terry
I am happily using ADOExpress (purchased as an add on to D5 Pro)
with MSSQL 7 (and MSDE)
A few pointers
- Base your DB Access on Queries not Tables
- Dont try to simply use the Query, Table and Stored Proc as replacements
for the BDE components - they are diffent enough to trip you up i.e. If you
are using Stored Proc that doesn't return a result set use a TADOCommand
- Subscripe to the News Server Forums at borland.public.delphi.database.ado
on forums.imprise.com
- Read up on SQL Cursors because ADO is very much based round this model
Hope this helps
Regards Neven
N.K. MacEwan B.E. E&E
----- Original Message -----
From: Terry Johnson <[EMAIL PROTECTED]>
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
Sent: Tuesday, 25 January 2000 20:26
Subject: [DUG]: ADO access
I've heard conflicting things from various people about ADO and Delphi, and
if I could get a definitive answer, it would be just peachy, and may help
save my remaining hair.
I would like to connect to SQL Server 7. What do I need?
Delphi Enterpri$e edition contains SQL Links and ADO Express. I've never
used either, but do I need one or both of these to connect to SQL Server?
Does Delphi support ADO otherwise? Or, in other words, can I connect to SQL
Server from the 'professional' edition without doing heaps of work first?
I've seen the hype-packed feature lists, but what I want to see is a
'you-can't-get-there-from-here' list. And if anyone from marketing is
reading, making up new words, turning nouns into verbs, and arbitrary
creation of acronyms does not make anyone's job easier. So just stop it,
ok?
Cheers,
Terry
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
