On 25/01/2000 20:26:35, Terry Johnson blurted out...
>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 Enterprise (for ADOExpress or via the BDE or ODBC) or Delphi Professional
+ the ADO 'upsell' disk (basically, ADOExpress as a seperate product) (for
ADOExpress only)
Or "whatever version of Delphi" + a 3rd party ADO library (Adonis etc)
>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?
You need some form of connectivity - BDE (ie, SQL Links) or ADOExpress are 2
ways to do it - a 3rd party ADO wrapper library would also do the job, and it would
be usable with Pro (tho not Standard - no DB stuff in standard)
>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?
OK:
Enterprise:
- Has the BDE with MSSQL driver
- Has ADO Express - will connect to MSSQL via the MSSQL OLE-DB driver (part of
the client, MS's prefered way to connect)
- Has InterbaseExpress, tho you dont want it for this :)
Cost: About $4500, new, I _think_ (no, thats not a quote)
Professional:
- Has the BDE, no SQL drivers, tho.
- No ADOExpress, BUT: you can get them as an add-on for about $380+gst or so.
- Has InterbaseExpress.
Cost: About $1500 I think, from memory.
>
>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?
Sorry, thats a microsoft job....
But did it work?
If you want definitive pricing, call Olivia or Annie (Claire left last week - off to
the
UK for her big OE / to hook up with her man (delete which ever you dont beleive))
:)
N
--
Nic Wise - Human (just)
ph: 09.277.5309 / cell: 021.676.418 / em: [EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
