Mdac Version 2.8

 admin

Microsoft Data Access Components (MDAC) 2.8 contains core Data Access components such as the Microsoft SQL Server OLE DB provider and ODBC driver. Download Freeware MDAC SP1. Microsoft Data Access Components (MDAC) 2.8 SP1 contains core Data Access components such as the Microsoft SQL Server™ OLE DB provider and ODBC driver. This redistributable installer for the MDAC 2.

-->

This topic lists the new features introduced by each release of ADO, ADO MD, and ADOX.

Download Dec 07, 2015  TORRENT – FREE DOWNLOAD – CRACKED. Peggle Deluxe – Take your best shot with energizing arcade fun! Aim, shoot, clear the orange pegs, then sit back and cheer as 10 whimsical teachers guide you to Peggle greatness.

Mdac 2.8 Sp1

ADO 6.0

ADO 6.0 is included in Windows Vista, as a part of the Windows Data Access Components (Windows DAC) 6.0. ADO 6.0 is functionally equivalent to ADO 2.8.

ADO 2.8

ADO 2.8 was included in Windows XP and Windows Server 2003, as part of the Microsoft Data Access Components (MDAC) 2.8. A redistributable version of MDAC 2.8 is also available; note that this redistributable version should only be installed on Windows 2000. 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, andStream.LoadFromFileoperate on physical files only.These methods now verify that file handles point to physical files only.

Recordset.ActiveCommandreturns an error when invoked from an HTML/ASP page.This prevents the Command object from being misused.

The number ofRecordsetsreturned by a nestedShapecommand 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.7

64-bit platform supportADO 2.7 introduces support for 64-bit processors.

ADO 2.6

CubDef.GetSchemaObjectMethodStarting with ADO 2.6, ADO MD objects can be retrieved using unique names, as specified by the UniqueName property (ADO MD). The names of parent objects do not need to be known, and parent collections do not need to be populated to retrieve a schema object. See GetSchemaObject method (ADO MD).

Command streamsThe Command object supports commands in stream format as an alternative to using the CommandText property. The CommandStream property (ADO) can be used to specify XML Templates or updategrams as the Command input with the Microsoft OLE DB Provider for SQL Server.

DialectpropertyDialect is a new property that defines the syntax and general rules that the provider uses to parse the string or stream.

Command.ExecutemethodThe Execute method of the ADO Command object has been enhanced to use streams for input and output. Free verilog compiler.

Field statusvaluesIf the user encounters a DB_E_ERRORSOCCURRED error when modifying a Field of a Recordset, ADO will now fill the Field.Status property with the appropriate status information so that the user will have more information about what went wrong. See Status Property (ADO Field).

NamedParameterspropertyNamedParameters is a new property of the Command object that indicates that the provider should use named parameters.

Resultsets in streamsADO can return resultsets from a data source in a Stream, rather than a Recordset object. Using the latest version of the Microsoft OLE DB Provider for SQL Server, you can get XML results from the provider by executing a 'For XML' query. A Stream that receives the resultset can be opened with a 'For XML' command as the source. See Retrieving Resultsets into Streams.

Single row resultsetThe ADO Record object can now be opened on a command string or Command object that returns one row of data from the provider. This results in improved performance with MDAC 2.6 providers. See Open Method (ADO Record).

ADO 2.5

RecordobjectADO 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.

StreamobjectADO 2.5 also introduces the Stream object to represent a stream of binary or text data.

URL bindingADO 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 bindingADO 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.

Active5 years, 8 months ago

How can I find out which version of MDAC is installed on a computer?

Magnus Lindhe
Magnus LindheMagnus Lindhe
4,5364 gold badges42 silver badges58 bronze badges

closed as off topic by cwallenpoole, marc_s, WillJul 22 '11 at 12:37

Mdac 2.8 Sp2

Questions on Stack Overflow are expected to relate to programming within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here. If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer

Derek SwingleyDerek Swingley
8,0575 gold badges27 silver badges31 bronze badges

Mdac Version 2.8

Not the answer you're looking for? Browse other questions tagged mdac or ask your own question.