Topic
5 replies Latest Post - ‏2012-11-30T00:53:11Z by SystemAdmin
SystemAdmin
SystemAdmin
9 Posts
ACCEPTED ANSWER

Pinned topic Getting message: Unable to load DLL "SqlServerSpatial.dll":

‏2012-11-14T17:29:00Z |
Hi,
I'm working with LNP 7.2.24.5. We are getting a message: 'Unable to load DLL "SqlServerSpatial.dll": The specified module could not be found.'

This occurs when trying to open the map view. We tried this on several different machines and are still getting the same error.

See attached screenshots for more details.

It seems like the the DLL for the map is not being installed.

Thanks,
Mike
Updated on 2012-11-30T00:53:11Z at 2012-11-30T00:53:11Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    9 Posts
    ACCEPTED ANSWER

    Re: Getting message: Unable to load DLL "SqlServerSpatial.dll":

    ‏2012-11-14T17:40:30Z  in response to SystemAdmin
    Hi Mike,

    Can you please clarify your OS version and if it is 32-bit or 64-bit?

    Thanks,
    Justin
  • SystemAdmin
    SystemAdmin
    9 Posts
    ACCEPTED ANSWER

    Re: Getting message: Unable to load DLL "SqlServerSpatial.dll":

    ‏2012-11-14T19:54:56Z  in response to SystemAdmin
    Hi Justin,

    It is Windows 7, 64-bit.

    Regards,
    Mike
    • SystemAdmin
      SystemAdmin
      9 Posts
      ACCEPTED ANSWER

      Re: Getting message: Unable to load DLL "SqlServerSpatial.dll":

      ‏2012-11-14T20:06:42Z  in response to SystemAdmin
      Thanks Mike. There does appear to be a known and open issue at Microsoft related to SQL Server 2008 SP2 (which comes through Windows update) conflicting with the Spatial binaries:
      http://connect.microsoft.com/SQLServer/feedback/details/633996/after-installing-2008-sp2-i-receive-unable-to-load-dll-sqlserverspatial-dll-exception-from-hresult-0xe06d7363

      Please try downloading and running the 32-bit version of "Microsoft® System CLR Types for SQL Server® 2008 R2" and see if that patches the issue. Direct download link is here:
      http://go.microsoft.com/fwlink/?LinkID=188391&clcid=0x409

      Let me know how it goes.

      Thanks!
      Justin
      • MichelLeofIBM
        MichelLeofIBM
        18 Posts
        ACCEPTED ANSWER

        Re: Getting message: Unable to load DLL "SqlServerSpatial.dll":

        ‏2012-11-29T14:45:33Z  in response to SystemAdmin
        Hi,

        Good to know. One of our pospect in Europe has encountered the same problem.
      • SystemAdmin
        SystemAdmin
        9 Posts
        ACCEPTED ANSWER

        Re: Getting message: Unable to load DLL "SqlServerSpatial.dll":

        ‏2012-11-30T00:53:11Z  in response to SystemAdmin
        Hi Justin, Here is the update: the fix from Microsoft worked Everything is fine. Thanks for help. Mike