[Resolved] : Unable to load DLL 'SqlServerSpatial110.dll': The specified module could not be found.

I was trying to use the SqlServer Spatial CLR types in a C# .Net project. I wanted to use SqlGeometry to query spatial records out of my db.

I then publish a WCF Rest service to my local IIS instance that has a service that hits the same class library as the unit test to do some spatial querying and it fails.

Following exception was logged.

 Inner Exception :

 Message: Unable to load DLL 'SqlServerSpatial110.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) HResult: -2146233052 Source: Microsoft.SqlServer.Types StackTrace: at Microsoft.SqlServer.Types.GLNativeMethods.SetClrFeatureSwitchMap(Int32 clrFeatureSwitchMap) at Microsoft.SqlServer.Types.SqlGeometry.IsValidExpensive() at Microsoft.SqlServer.Types.SqlGeometry.Construct(GeoData g, Int32 srid) at Microsoft.SqlServer.Types.SqlGeometry.GeometryFromText(OpenGisType type, SqlChars text, Int32 srid) at Microsoft.SqlServer.Types.SqlGeometry.STGeomFromText(SqlChars geometryTaggedText, Int32 srid) at Microsoft.SqlServer.Types.SqlGeometry.Parse(SqlString s) TargetSite: Void SetClrFeatureSwitchMap(Int32)

Resolution : 

Add the reference of Microsoft.SqlServer.Types in Web.config of application resolved the issue.


<runtime>
   <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.SqlServer.Types" publicKeyToken="89845dcd8080cc91" />
        <bindingRedirect oldVersion="1.0.0.0-11.0.0.0" newVersion="10.0.0.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>


Regards,
Farhan Jamil
Senior Software Engineer
Systems Limited,Pakistan


Comments

Post a Comment

Popular posts from this blog

Issues After upgrading BizTalk 2013 to BizTalk 2013 R2 - Could not load file or assembly 'Microsoft.BizTalk.Interop.SSOClient

I just upgraded 2013 to 2013 R2. These are the steps. I installed VS 2013 first which is required. Backup All the DB's ·          BizTalkDTADb ·          BizTalkMgmtDb ·          BizTalkMsgBoxDb ·          BizTalkRuleEngineDb This is the issues that I found. After Smooth Installation of Biztalk 2013 R2.I tested the already deployed orchestration which was up and running before R2 installation to check the impact of upgrade on the code. After restarting the Host Instances when I trigger the orchestration by placing the message at receive location,message got suspended and following Exception was logged in Event Viewer. Exception : Inner exception: Could not load file or assembly 'Microsoft.BizTalk.Interop.SSOClient, Version=7.0.2300.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified. I searched different forum which say's  Install SSOClient from [BizTalkSer
Read more

Creating Custom Pipeline Component and Pipeline for Reading Excel File in BizTalk

Image
In this blog I will explain how can we read an Excel file using pipeline in BizTalk . A custom pipeline components need to be develop to parse the excel file  to generate an xml file matching an existing defined schema .   A custom pipeline component is just simple .NET DLL that implements a class with some predefined interfaces. This interface represents the layer between a .NET program and the BizTalk Server. When we create custom pipeline class we need to Implement   IBaseMessage ,  IComponent ,  IComponentUI , and  IPersistPropBag   interfaces.You can use the below code as is.  The logic for reading an Excel file will be implemented inside the  Execute  method under  IComponent I nterface . ExcelDecoder.cs (Custom Component File) using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.ComponentModel; using Microsoft.BizTalk.Component.Interop; using Microsoft.BizTalk.Message.Interop; using System.IO; using System.Xml;
Read more