Question

在vs2010中添加数据源时，报“未能加载文件或程序集：Microsoft.SqlServer.Types, Version=11.0.0.0”

环境：vs2010、sql2008r2、win8
问题：winform开发时想往窗体中添加datagridview，绑定sql中的一张表作数据源，最后点完成的时候报错：“未能加载文件或程序集“Microsoft.SqlServer.Types, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91”或它的某一个依赖项。系统找不到指定的文件。” 我之前装过sql2012，卸载后装了sql2008，出错，卸载换了r2还出错，重装vs2010，依旧
请大神帮忙看看是怎么回事
这个程序在同事的sql2008.vs2010和sql2008r2.vs2010上都没问题，我纳闷它提示的sql版本11.0貌似是sql2012 可是都删干净啦，新重新安装的那两个数据库也都安装成功了没有问题，是不是什么地方漏了没删，还是其他地方有配置呢？

Answer 1

看提示缺少程序集引用，下载http://download.microsoft.com/download/5/f/a/5fad1d35-e69e-448b-84dc-497061772141/SQLEXPR_x86_CHS.exe
安装即可

Answer 2

这个问题有人解决了没有啊，我都把数据库客户端安装到web服务器上了还是报这个错啊

Could not load file or assembly 'Microsoft.SqlServer.Types,
Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of
its dependencies. 系统找不到指定的文件。

Answer 3

Trying to use the SqlGeography class in C# against a geography value returned by a SQL Server query in an ADO.NET data reader. There seems to be a DLL mismatch issue, because this is simple code that alway ran without a problem in SQL 2008 (& R2). Now running on a clean VM with only Denali CTP3 and VS2010 installed, and an exception is occurring on the cast out of the data reader. The details of the exception (shown in Actual Results below) indicate an inability to resolve versions 10 and 11 of this class. Again, I have no previous versions of SQL on this VM.

The immediate window confirms that the value in the reader being returned by SQL Server is indeed a SqlGeography, because it reflects its values as shown at the bottom of the screenshot attached. And VS shows these properties for the reference:

Path = C:\Program Files (x86)\Microsoft SQL Server\110\SDK\Assemblies\Microsoft.SqlServer.Types.dll
Runtime Version = v2.0.50727
Version = 11.0.0.0