Heads Up on SQL92 Mode

#11

Tony Toews <ttoews (AT) telusplanet (DOT) net> wrote in
news:shl0f6hq3h5ei99efmclbpqd7oi6acdjvb (AT) 4ax (DOT) com:

Quote:

On Thu, 25 Nov 2010 16:41:55 -0800 (PST), TechVsLife
techvslife (AT) gmail (DOT) com> wrote:

No, they're not using disconnected recordsets. * I think it was
that you could call a stored procedure and get a recordset
returned. *

But DAO also fully supports returning recordsets from stored
procedures.

Ah, I stand corrected. I doubt that was why then.

Is it perhaps that with ADO, you can get an editable recordset? And
bind it to a form?

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#12

On 27 Nov 2010 03:47:52 GMT, "David-W-Fenton" <dfassoc (AT) dfenton (DOT) com>
wrote:

Quote:

No, they're not using disconnected recordsets. * I think it was
that you could call a stored procedure and get a recordset
returned. *

But DAO also fully supports returning recordsets from stored
procedures.

Ah, I stand corrected. I doubt that was why then.

Is it perhaps that with ADO, you can get an editable recordset? And
bind it to a form?

Yes, he is using ADO in that fashion. Which really surprised me when
I was viewing the code.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

#13

Quote:

Is it perhaps that with ADO, you can get an editable recordset? And
bind it to a form?
Yes, he is using ADO in that fashion.

Not sure what the advantage of ADO over DAO is, which can also bind
editable recordsets. Is is that ADO can get editable recordsets from
certain types of stored procedures and table functions, and DAO
cannot, or something else. (since DAO can bind editable sql server
tables via linking, and local queries on them, and call stored
procedures or pass through sql for write & other operations) Too bad
DAO won't get further enhancements to support sql server; but ADO is
also dead. (The windows development world is in a more confused
terrain than usual after winforms (wpf? silverlight? asp? javscript/
html5?).)

#14

TechVsLife <techvslife (AT) gmail (DOT) com> wrote in
news:5894c7bd-05b9-4b68-81dc-a38558f7133b (AT) 39g2000yqa (DOT) googlegroups.com
:

Quote:

Is it perhaps that with ADO, you can get an editable recordset?
And bind it to a form?
Yes, he is using ADO in that fashion.

Not sure what the advantage of ADO over DAO is, which can also
bind editable recordsets.

But not from a stored procedure, right?

Quote:

Is is that ADO can get editable recordsets from
certain types of stored procedures and table functions, and DAO
cannot, or something else. (since DAO can bind editable sql
server tables via linking, and local queries on them, and call
stored procedures or pass through sql for write & other
operations) Too bad DAO won't get further enhancements to support
sql server;

DAO never supported SQL Server directly. It always did it through
Jet/ACE via ODBC. But the new native ODBC driver for SQL Server is
quite fast in comparison to the old (in my experience) and so it's
clear that MS is investing effort in ODBC, which is actually quite
an old technology.

Quote:

but ADO is
also dead. (The windows development world is in a more confused
terrain than usual after winforms (wpf? silverlight? asp?
javscript/ html5?).)

I wouldn't know. I'm confused enough on my own.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#15

wow dude.. it sounds to me like you're stuck in the past.. I mean.. 92.. I mean wow.. that's like 18 years ago!!

I'm just surprised that you're still using an obsolete database engine that hasn't received any improvements in the past 15 years!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Heads Up on SQL92 Mode

comp.databases.ms-access comp.databases.ms-access

Re: Heads Up on SQL92 Mode - 11-26-2010 , 09:47 PM

Re: Heads Up on SQL92 Mode - 11-27-2010 , 05:53 PM

Re: Heads Up on SQL92 Mode - 11-27-2010 , 09:50 PM

Re: Heads Up on SQL92 Mode - 11-29-2010 , 06:10 PM

Re: Heads Up on SQL92 Mode - 01-03-2011 , 06:18 AM