A View Inside My Head

Jason's Random Thoughts of Interest
posts - 68, comments - 168, trackbacks - 10

Knowledge++ [4]

I recently developed a spatially-aware .NET application that did not use SQL Server 2008 as the backend (this enterprise was still on SS2005, but we needed the spatial support in the application today).  While the application worked properly on my laptop, it was a huge failboat when deployed to the server environment.

I had previously posted that you can get the Microsoft.SqlServer.Types library from MS Downloads, but it turns out that this alone is not sufficient to allow your application to run.  You also need to ensure that the SQL Server 2008 Native Client is also installed (regardless of whether you're accessing a SS2008 instance or not). Update! You actually don't... read below.

Both the Types library and the Native Client can be downloaded from the following:

http://www.microsoft.com/downloads/details.aspx?FamilyID=228de03f-3b5a-428a-923f-58a033d316e1&DisplayLang=en

My discovery source: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=355402&wa=wsignin1.0

UPDATE: Per Isaac Kunen (in this blog post's comments as well as offline discussion), the missing component from the Types library is simply an updated version of the C Runtime.  The fix of using the Native Client is a hack in this case because its MSI actually installs the updated CRT (which the MSI for the Types library should have done also - it's a goof that MS Downloads hasn't been updated with an updated version of the Types API after the above Connect feedback was answered...

The Microsoft Visual C++ 2008 redistributable by itself can be downloaded from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=A5C84275-3B97-4AB7-A40D-3802B2AF5FC2&displaylang=en

 

Print | posted on Saturday, February 21, 2009 9:45 PM | Filed Under [ SQL Spatial Knowledge++ ]

Feedback

Gravatar

# re: Knowledge++ [4]

Hi Jason,

Are you sure you're using the most recent release of the library (the one you've linked to)? We know this was an issue in the first pre-release version, but it should be resolved.

(Feel free to contact me off the blog---we want to make sure this is fixed.)

Cheers.
-Isaac
2/22/2009 5:17 PM | Isaac Kunen
Gravatar

# The Spatial Library without the Server: Bug and Workaround

Hi Folks, Jason Follas recently ran across a lingering issue when using our spatial library without the
2/23/2009 8:40 PM | Isaac @ MSDN
Comments have been closed on this topic.

Powered by: