On 1/13/2018 6:25 AM, Akshat Kapoor wrote: > On 13/01/2018 18:38, Ronnie MacGregor wrote: >> In article <6HRfZUFjTHA.1828@ip-AC1E04A7>, firstname.lastname@example.org >> says... >>> Modified the user access and now the connection was successful. >> Good stuff !! >> >> > > Another small query > > Question 1. > If I use the executesql method of ADOdatabase what will be the > limitations of sql command, > 1. Subset of SQL provided by BDE > 2. Limitations of SQL Server if any. All commands taught by w3schools > are allowed
executeSQL() bypasses the BDE and sends information to the server.
ADODatabase is meant to bypass the BDE as well, so that should take it
out of the equation.
> Question 2 > Difference between Query class and ADOquery Class > > As far as my limited knowledge goes Query class uses BDE for its > operations whereas in case of ADOquery the query is passed on to the SQL > server directly for processing.