开发者

Is MDAC supported in Sql Server 2011 ("Denali")?

I have been told that next version of SQL Server (2011 - "Denali") won't use MDAC but a "vendor dll" as other RDBMS do. Is this true or MDAC will work anyway?

If this is true the zero installation I have for my client application (because MDAC is already installed I don't need to do anything but copy an exe in t开发者_JAVA技巧he client machine) will become a Sql Server dll + My exe deployment.

May you give some advice on this?


MDAC was, pretty well, the name for an installer that installed multiple different data access components, such as the OLEDB provider and the ODBC driver. The last recognisable version of MDAC (2.8) dates from the Windows Server 2003 era.

The more modern installer for such client components is the SQL Server Native Client. This includes updated OLEDB and ODBC components, with support for newer SQL Server features such as MARS. The older components will probably continue to work for some time, but as I say, you won't have access to some newer features.

I can find no specific references in the Denali BOL to any deprecation of data access technologies (as opposed, say, to where it states that Itanium is no longer supported)

The BOL does include a guide on updating applications from MDAC to Native Client

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜