> What are the complications of changing from using BDE to using ADO?
>
> 1. Are there Deployment issues? Can we expect to find ADO is just "There" or
> do we need to go off at a tangent regarding deployment issues, and become
> devoted upgrade trackers?.
OK, ADO is NOT standard on all machines, tho it is pretty much standard
on anything with IE5. NT4 SP4 included it also.
There is an install (on the D5 Ent. CD, should be on the upsell CD too)
called MDAC_TYP.exe that installs it. HOWEVER, its a cow to install,
'cos unlike other installshield installs (which you can chain together),
it forces a reboot and never tells the calling install that its doing
that. My flatmate is doing a project with it, and to install on a bare
Win95 machine, it takes about 5 reboots to install. Ouch.
> 2. Does it offer better performance and greater exposure to database
> featrures?
Depends: MSSQL7, yes. Oracle 8i, dunno. Access - YES!, anything else:
ODBC :(
> 3. Would I need to do a serious application design about face, or is it
> simply a matter of changing from a TDataset connection to a TADOConnection,
> and TQuery to a TADOQuery?
Pretty much a case of search and replace, EXCEPT you need to watch your
keywords, 'cos ADO uses slightly different reserved words (eg, like in
interbase you can't call a field PASSWORD)
> 4. Do the Crystal ball gazers see this as a lasting connection scenario
Should be. MS have had it around for more than a week - thats a good
sign. Note that MS throw things out a LOT anyway....
> 5. Initially we are only talking SQL Server 7, however, can we expect to see
> ADO development for the other main stream database vendors.
IB6 is rumered to contain an OLE-DB driver, Informix has one I think,
others are writing them.....
> 6. Is there any particular good/bad things with ADO in a 3 tier application
> using Midas that we need to consider?
Not that I'm aware of - I've used it in that config, and it worked nice.
I have it (almost) transparently swappable between ADOExpress and
IBExpress. :) Its was just a trivial exercise tho....
N
--
Nic Wise - Inprise New Zealand / Brocker Technologies Web Monkey.
mob:+64.21.676.418 - wk:+64.9.481.9999 x9753 - wk-em:[EMAIL PROTECTED]
hm: +64.9.277.5309 - hm-em:[EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
