Re: Microsoft ActiveX Data Objects library, 2.5 vs 2.8

From: Qwert (nospam_at_nospam.com)
Date: 01/24/05


Date: Mon, 24 Jan 2005 09:28:04 +0100

Thank you very much.

"Mona" <Mona@discussions.microsoft.com> schreef in bericht news:OKLMQceAFHA.2156@TK2MSFTNGP10.phx.gbl...
Hi Qwert,

The differences between ADO 2.5 and ADO 2.8 are as follows
ADO 2.8
ADO 2.8 addresses several security-related concerns:

Hard drive access is not allowed outside a trusted zone.
In cross-domain scripting involving nontrusted sites,
the following operations are disabled: Stream.SaveToFile,
Stream.LoadFromFile, Recordset.Save, and Recordset.Open,
used in conjunction with the adCmdFile flag or with the Microsoft
OLE DB Persistence Provider (MSPersist).
Recordset.Open, Recordset.Save, Stream.SaveToFile, and Stream.LoadFromFile
operate on physical files only.These methods now verify that file handles point to physical files only.
 
Recordset.ActiveCommand returns an error when invoked from an HTML/ASP page.
This prevents the Command object from being misused.
The number of Recordsets returned by a nested Shape command has an upper bound.
A nested shape command now returns a maximum of 512 Recordsets.
This means that a Shape command can no longer be nested at any depth.
Instead, the maximum level depth is 512, if each command results in a single (child) Recordset.
If, at any level, a Shape command returns multiple Recordsets, the maximum level of depth will be less than 512.
ADO 2.5
Record object
ADO 2.5 introduces the Record object to represent and manage a row from a Recordset or a data provider,
or an object encapsulating a semi-structured data, such as a file or directory.
Stream object
ADO 2.5 also introduces the Stream object to represent a stream of binary or text data.
URL binding
ADO 2.5 introduces the use of a URL, as an alternative to a connection string and command text,
to name data store objects. A URL can be used with the existing Connection and Recordset objects,
as well as with the new Record and Stream objects.
Data providers supporting URL binding
ADO 2.5 supports OLE DB providers that recognize the URL schemes. This includes OLE DB Provider
for Internet Publishing, which accesses the Windows 2000 file system and recognizes the existing HTTP scheme.
Also you can read up more details on the topic on the follwing link:

[ADO 2.8 Security Design Issues and Changes]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/ado28_dcrs.asp

HTH

Mona

"Qwert" <nospam@nospam.com> wrote in message news:HKedne9LCqDyK27cRVnyhA@casema.nl...
> Hello,
>
> I need to know what the differences are between MS ADO 2.5 and 2.8.
> Currently using 2.5 and would like to know the arguments to go to 2.8.
> Having trouble finding comparison between the 2 on internet.
>
> If anyone knows, or knows a site,
>
> thank you.
>
>



Relevant Pages

  • Re: Microsoft ActiveX Data Objects library, 2.5 vs 2.8
    ... The differences between ADO 2.5 and ADO 2.8 are as follows ... OLE DB Persistence Provider. ... The number of Recordsets returned by a nested Shape command has an upper bound. ...
    (microsoft.public.data.ado)
  • Re: Microsoft ActiveX Data Objects library, 2.5 vs 2.8
    ... The differences between ADO 2.5 and ADO 2.8 are as follows ... OLE DB Persistence Provider. ... The number of Recordsets returned by a nested Shape command has an upper bound. ...
    (microsoft.public.vb.database.ado)
  • Re: Microsoft ActiveX Data Objects library, 2.5 vs 2.8
    ... The differences between ADO 2.5 and ADO 2.8 are as follows ... OLE DB Persistence Provider. ... The number of Recordsets returned by a nested Shape command has an upper bound. ...
    (microsoft.public.vb.database.ado)
  • Re: Timeouts (80040E31) on AddNew
    ... > Good practices in vb do not necessarily translate to good practices in asp. ... > I can say is that ADO was written to be used by many technologies. ... > situations, such as desktop applications, the use of recordsets ... server for an Apache server with Perl, ...
    (microsoft.public.inetserver.asp.db)
  • Re: Using Access to view and edit SQL Server table with Bigint primary key
    ... Your problem has been an ongoing problem between Access and sql server ... ADO to edit your data. ... recordsets will not work with sub-forms and the link master/child settings, ... I can't imagine anyone suggesting temp tables on the sql server side, ...
    (comp.databases.ms-access)