In .adp project, Where is SQL Statement executed ?

  • Thread starter Thread starter suntisuk
  • Start date Start date
S

suntisuk

Yesterday, I asked for Where is Query executed
(under .adp project). 2 MVPs replied, On SQL Server.
Thanks to Albert D. Kallal and Tom Ellison.

Today I just think "And what about SQL statement in my
program ? " If I also want it to be executed on SQL
Server side, What I have to do ? Does it depend on
database accesing method (ADO, DAO, DAO thru ODBC) ? Do I
have to write any specific keyword in SQL statement ?

TIA
 
Sir:

In an ADP, Jet *is not loaded;* therefore, only SQL Server
can service SQL statements.

Have you noticed how you write T-SQL vs. "Jet SQL"?

If you use an .MDB, you can have a hybrid solution that
can run either locally (file/server mode) or on SQL Server.

David Atkins, MCP
 
Execuse me, Could you explain more. I not really
understand what you explain. I never programming in other
models than DAO before. So, I have only picture in my
mind that I have to write code like this :

Dim RS as Recordsets
Set RS = CurrentDB().OpenRecordset("SELECT * FROM TABLE;")

That's why I question What acessing model (ADO, DAO,...)
should I use. Is it still use the same statement as above
to access to T-SQL ?

Regards,
Suntisuk
 
I apologize for my confusing response.

Use ADO for ADPs. But yes, all processing is done SQL
Server-side in ADPs (all queries requested via code are
sent to and then serviced wholly by SQL Server).

DAO is optimized for the Jet engine, and like yourself, I
mostly program (even today) in DAO. Quite frankly, I
enjoy using a hybrid approach to development (i.e., some
local user-only tables mixed with SQL Server views and
stored procedures [accessible through pass-through
queries]), which leverages the strengths of both
architectures with few limitations.

David
 
Oh! You needn't to apologize me, my question is not
clear. You are so polite. Unusually for me to found.

Thank you so much, David.
 
Back
Top