August 12, 2011 at 2:22 am
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,
August 12, 2011 at 2:41 am
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
August 12, 2011 at 2:47 am
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,
August 12, 2011 at 3:00 am
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
September 19, 2011 at 5:52 am
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()
September 20, 2011 at 11:00 am
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.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy