Unable to load SqlServerSpatial.dll

by

I had the same problem on a Windows Server 2012 machine. It had an SqlServerSpatial110.dll file in \Windows\System32, but no SqlServerSpatial.dll. The solution was installing the Microsoft System CLR Types for SQL Server 2008 R2 on the machine.

  1. http://www.microsoft.com/en-us/download/details.aspx?id=26728
  2. Click Download

  3. Check off one of these depending on your processor architecture:

    • 1033\x64\SQLSysClrTypes.msi
    • 1033\x86\SQLSysClrTypes.msi
    • 1033\IA64\SQLSysClrTypes.msi

  4. Click Next

More Related Contents:

  1. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  2. How do ValueTypes derive from Object (ReferenceType) and still be ValueTypes?
  3. C# Equivalent of SQL Server DataTypes
  4. Why cannot C# generics derive from one of the generic type parameters like they can in C++ templates? [duplicate]
  5. How to deploy application with sql server database on clients
  6. Static Generic Class as Dictionary
  7. SqlConnection SqlCommand SqlDataReader IDisposable
  8. Why C# is not allowing non-member functions like C++
  9. How to catch SQLServer timeout exceptions
  10. Why check this != null?
  11. explicitly cast generic type parameters to any interface
  12. Code to validate SQL Scripts
  13. MultipleActiveResultSets=True or multiple connections?
  14. SqlConnection.Close() inside using statement
  15. Asynchronous iterator Task
  16. Why does struct alignment depend on whether a field type is primitive or user-defined?
  17. Why only literal strings saved in the intern pool by default?
  18. Horrible performance using SqlCommand Async methods with large data
  19. Is it better to execute many sql commands with one connection, or reconnect every time?
  20. Is there a .NET equivalent to SQL Server’s newsequentialid()
  21. How to Specify Primary Key Name in EF-Code-First
  22. Upload CSV file to SQL server
  23. Boxing / Unboxing Nullable Types – Why this implementation?
  24. What is the equivalent of bigint in C#?
  25. Use SQL Server time datatype in C#.NET application?
  26. Can you have multiple enum values for the same integer? [duplicate]
  27. Retrieve JIT output
  28. Generating sql code programmatically
  29. Is SqlConnection.Close() need inside a Using statement?
  30. Where is the .NET JIT-compiled code cached?

Leave a Comment