ADOMD.NET Release Differences

  • Article

New: 5 December 2005

ADOMD.NET was originally released as the ADOMD.NET 8.0 SDK. This SDK provided communication with Microsoft SQL Server 2000 Analysis Services.

Included with this release of Microsoft SQL Server 2005 Analysis Services (SSAS) is a new version of ADOMD.NET—ADOMD.NET 9.0. This new version of ADOMD.NET provides communication with both SQL Server 2000 Analysis Services and SQL Server 2005 Analysis Services (SSAS).

It is the ability of ADOMD.NET 9.0 to communicate with SQL Server 2005 Analysis Services (SSAS) that is the most important difference between ADOMD.NET 9.0 and ADOMD.NET 8.0. ADOMD.NET 9.0 is able to support all of the capabilities found in SQL Server 2005 Analysis Services (SSAS), while ADOMD.NET 8.0 is not able to support any of these new features.

Another important difference between the two versions is in the Microsoft .NET Framework Class Library used by each version. ADOMD.NET 9.0 requires that the .NET Framework Class Library version 2.0 be installed on the client. However, ADOMD.NET 8.0 requires that the .NET Framework Class Library version 1.0 Service Pack 2 (SP2) or later be installed.

The following table summarizes the differences between ADOMD.NET 9.0 and ADOMD.NET 8.0.

Feature ADOMD.NET 8.0 ADOMD.NET 9.0

.NET Framework Runtime Requirements

Requires installation of the .NET Framework Class Library 1.0 SP2 (or later) on the client.

Requires installation of the .NET Framework Class Library 2.0 (or later) on the client.

Metadata Objects

CubeDef, OlapInfo

CubeDef, OlapInfo, Kpi, MiningModels, MiningServices, MiningStructures

Server Connectivity
  • Can connect to SQL Server 2000 Analysis Services.
  • Can connect to SQL Server 2005 Analysis Services (SSAS), but the object model used by ADOMD.NET 8.0 cannot use any of the new Analysis Services features.
  • Can connect to SQL Server 2000 Analysis Services.
  • Can connect to SQL Server 2005 Analysis Services (SSAS), and the object model used by ADOMD.NET 9.0 can use all new Analysis Services features.
  • Can have the following, additional connection string properties set: LocaleIdentifier, Location, Restricted Client, Persist Security Info, SessionID, Transport Compression, Compression Level, SspropInitAppName, and ClientProcessID. For more information, see ConnectionString.

Performance

Optimized to perform faster than ADOMD.NET 8.0 in many scenarios.

See Also

Reference

ConnectionString

Help and Information

Getting SQL Server 2005 Assistance