Microsoft.SqlServer.Types 64bits

  • Hello,

    I have a web server with the application and then I have a sql server 2008 both machines are w2k8 64 bit.

    In the web application I'm using Microsoft.SqlServer.Types. When the application uses the Microsoft.SqlServer.Types I get the error exception from hresult: 0x8007000b.

    I installed Microsoft SQL Server System CLR Types 64 bits in the web server but it doesn't fix the problem.

    Somebody can help me?

    Thanks and best regards,

  • It would be worth having a look at Windows Error Reporting

    http://msdn.microsoft.com/en-us/windows/hardware/gg487440

    Kevin's blog post albeit short has helped me identify an issue with the Reporting Services service which i am waiting to apply a CU for.

    http://sql-kevin.blogspot.com/2011/02/windbg-mdmp-files.html

    Hope this sheds some light.

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • Thanks for you quick response.

    The problem is in .NET applicacion not in SQL server. I think it's a problem with 32 / 64 bits library version.

    Thanks again and best regards,

  • Windows Error Reporting is not just used by SQL Server if you are getting an exception chances are it will be recorded in c:\program data\.....

    Thanks

    Chris

    ------------------------
    I am the master of my fate:
    I am the captain of my soul.
    ------------------------
    Blog: http://sqlserver365.blogspot.co.uk/
    Twitter: @ckwmcgowan
    ------------------------
  • This is all the trace:

    [BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)]

    Microsoft.SqlServer.Types.GLNativeMethods.GeodeticIsValid(GeoMarshalData g, Boolean& result) +0

    Microsoft.SqlServer.Types.GLNativeMethods.GeodeticIsValid(GeoData g) +239

    Microsoft.SqlServer.Types.SqlGeography.IsValidExpensive() +827

    Microsoft.SqlServer.Types.SqlGeography.ConstructGeographyFromUserInput(GeoData g, Int32 srid) +134

    Microsoft.SqlServer.Types.SqlGeographyBuilder.get_ConstructedGeography() +173

    The error appears when I execute the line code: geoGraphyObject.ConstructedGeography.STAsText().ToSqlString().ToString()

  • I fixed it. The problem is with the library SqlServerSpatial.dll. Download this file SQL Server System CLR Types from http://www.microsoft.com/download/en/details.aspx?id=8824. Extract the files. Copy SqlServerSpatial.dll to system32.

    http://alastaira.wordpress.com/2011/08/19/spatial-applications-in-windows-azure-redux-including-denali/

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply