Microsoft. SqlServer. Management. Sdk. Sfc

Source: Internet
Author: User
Tags connect to microsoft sql server

Reproduced http://hi.baidu.com/%CE%B5%C0%B6%B5%C4sky%CC%EC%BF%D5/blog/item/39a4b61b050143f8e0fe0be0.html

Problem: failed to Load file or assembly "Microsoft. SqlServer. Management. Sdk. Sfc, Version = 10.0.0.0, Culture =
Neutral, PublicKeyToken = 89845dcd8080cc91 "or one of its dependencies. The system cannot find the specified file.

Search answer: in Visual Studio, use "server resource manager-add connection" to add a connection to the SQLEXPRESS instance. Click "test connection" to connect to the instance correctly. Click "OK, the following prompt appears:
Unable to add Database
Failed to Load file or assembly "Microsoft. SqlServer. Management. Sdk. Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 89845dcd80cc91" or one of its dependencies. The system cannot find the specified file.
Directly Using Management Studio Express can manage databases, but it won't work in Visual Studio. Why?

Answer: You need to download the following feature package.

Http://www.microsoft.com/downloads/details.aspx? Displaylang = zh-cn & FamilyID = c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c

Q: Can this friend introduce which package is needed? Or are all required?
In addition, the address you gave me is SQL Server 2008, and I use SQL Server 2005 Express Edition.
Thank you!

A: You can install Microsoft SQL Server 2008 to manage objects. It is used in VS2008 and has nothing to do with SQL 2005.
(The following is my practice based on the above Q & :)
Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Native Client (SQL Native Client) is a dynamic link library (DLL) that includes both the SQL ole db access interface and the SQL ODBC driver ). It provides runtime support for applications that use local code APIs (ODBC, ole db, and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should be used to create new applications or to enhance existing applications that need to take advantage of new features of SQL Server 2008. The SQL Native Client's reusable installer is used to install the Client components required for running, to take advantage of new features of SQL Server 2008, it can also install and develop header files required for applications using SQL Native Client APIs.

Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Native Client (SQL Native Client) is a dynamic link library (DLL) that includes both the SQL ole db access interface and the SQL ODBC driver ). It provides runtime support for applications that use local code APIs (ODBC, ole db, and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should be used to create new applications or to enhance existing applications that need to take advantage of new features of SQL Server 2008. The SQL Native Client's reusable installer is used to install the Client components required for running, to take advantage of new features of SQL Server 2008, it can also install and develop header files required for applications using SQL Native Client APIs.

Microsoft Core XML Services (MSXML) 6.0
Microsoft Core XML Services (MSXML) 6.0 is the latest version of the XML Processing Stack on the local machine. MSXML 6.0 provides standards-compliant implementation of XML 1.0, XML Schema (XSD) 1.0, XPath 1.0, and XSLT 1.0. In addition, it provides 64-bit support, enhances the security when using untrusted XML data, and improves the reliability compared with the previous MSXML version.

Microsoft SQL Server CLR type
The SQL Server CLR package contains components used to implement the new geometry, geography, and hierarchyid types in SQL Server 2008. This component can be installed separately from the server to allow client applications to use these types outside the server.

Note: Windows Installer 4.5 is required for this component.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.