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.
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?
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
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.
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.
Cheers
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
