在vs2010中添加数据源时,报“未能加载文件或程序集:Microsoft.SqlServer...

发布网友 发布时间：2023-11-22 01:40

我来回答

共3个回答

热心网友 时间：2024-03-15 08:07

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

热心网友 时间：2024-03-15 08:06

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

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

热心网友 时间：2024-03-15 08:05

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