Hi, There are some Msft Connect issues posted for this but... Are you writing code that is trying to make use of CLR in SQL Server? Salute, Mark
SqlServer Spatial CLR types required Hi, I need to use the new Sql Server 2008 spatial CLR types (Geography and Geometry) for my app. I'm reading and writing location data to the database, but I'm also getting the "Unable to load DLL 'SqlServerSpatial.dll'" error message. I can't simply register the DLL with my other assemblies. The blog here: http://blogs.msdn.com/oliviermeyer/...e-new-sql-server-spatial-types-libraries.aspx Suggests that VC++ 2008 runtime libraries need to be installed on the servers. Has anyone got a work around for this, or can they be installed? This is a show stopper for me.
Take a look at this thread: "Just needed to copy the Microsoft.SqlServer.Types.dll to the bin folder and upload it."
No, I've already done this. It still gives me the error that "Unable to load DLL 'SqlServerSpatial.dll'"
Wow - sorry about the massive delay, I've had to work on something else. The specific page where I get the error is at http://datilo.net/loka/website/AdvertView.aspx, but it is on a form post back. This website is just a prototype so feel free to login (OpenID etc) and add an advert. When you've created an advert (after first creating a new campaign), you'll see the error. SqlServerSpatial.dll and Microsoft.SqlServer.Types.dll are in the folder /Loka/Website/Bin.
You cannot use .NET CLR spatial datatypes because CLR is disabled on our production SQL Servers for the security reason. You will need to use T-SQL code to perform spatial operations on our SQL Server.
OK - thanks. I can't use them on Azure either. I'd hoped that I would on discountasp.net. Never mind, I'll do it T-SQL & my own code on Azure. Thanks.
