> I am keen to change an application that uses MS SQL server from the BDE to
> ADO with Delphi 5's ADO express and wanted to see what everyone thought
> about it.
Works for me - any my flatmate has done exactly that, tho going to
access from paradox. Had a few SQL-incompatabilities (ie, keywords
differet), but I think that was jet, not ado.
>
> The application needs to work with both 6.5 and 7 and from initial tests it
> looks like it would have to use a different provider for each one which
> would be a pain. Talking to 7 could be direct but 6.5 would have to go
> though an ODBC connection (Is there a any cost going though an ODBC
> provider?). Am I wrong? Any suggestions for a general purpose connection
> string?
7.0 ADO driver should work with 6.5, afaik. Going thru ODBC to 6.5 is
not too slow, anyway.... (and its just a string! store it in the
registry!)
>
> The application currently uses a lot of TQuery's and one Database component.
> I guess changing the Database to an AdoConnection and the TQuery's to Ado
> Query's. Or will I require more connections when using ADO? The other
Nope, should be exactly that.
> question on this is why couldn't Borland have kept it consistent so it would
> find try to find a default ADOConnection rather than having to specify it? I
> guess creating a descendent of each and introducing it wouldn't be to
> difficult.
huh?
> Are they any other tricks and traps others have found as this is a very
> large application and I don't would to get to far into it and find it is
> hopeless.
said flatmate had a large app (exe is about 5 meg, I think, and about
25-30,000 lines of code, loads of forms etc), and it took him about 2
days to port it, + another little while to workout an SQL bug in what
access liked vrs what paradox liked. It aint hard, tho it depends on how
you have written your app.
Nic
--
Nic Wise - Human (just) - at home
[EMAIL PROTECTED] - 021.676.418
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
