# MsSql2008FeatureLayer in the version 182

**URL:** <https://community.thinkgeo.com/t/mssql2008featurelayer-in-the-version-182/4928>\
**Category:** WebForms\
**Created:** [August 12, 2009, 6:59am UTC](https://community.thinkgeo.com/t/mssql2008featurelayer-in-the-version-182/4928 "2009-08-12T06:59:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ondrej\_kaspar](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/o/258eb7/32.png) [@ondrej\_kaspar](https://community.thinkgeo.com/u/ondrej_kaspar)\
**Post date:** [August 12, 2009, 6:59am UTC](https://community.thinkgeo.com/t/mssql2008featurelayer-in-the-version-182/4928/1 "2009-08-12T06:59:29Z")

</div>

Hi,

In&nbsp;new&nbsp;verson&nbsp;of&nbsp;WebSuite&nbsp;(v&nbsp;182)&nbsp;I&nbsp;have&nbsp;a&nbsp;problem&nbsp;with&nbsp;MsSql2008FeatureLayer.&nbsp;I&nbsp;display&nbsp;the&nbsp;countries&nbsp;to&nbsp;CustomOverlays&nbsp;and&nbsp;in&nbsp;the&nbsp;revious&nbsp;version&nbsp;(v&nbsp;148)&nbsp;it&nbsp;was&nbsp;correct.&nbsp;The&nbsp;overlay&nbsp;isn't&nbsp;display.&nbsp;Where&nbsp;is&nbsp;the&nbsp;problem?

[![](https://community.thinkgeo.com/uploads/default/original/1X/db79438fd6f3a101838b68b956019e8d0491843a.jpg)](http://gis.thinkgeo.com/DesktopModules/ActiveForums/viewer.aspx?portalid=1&moduleid=623&attachid=1036)

[![](https://community.thinkgeo.com/uploads/default/original/1X/1719cc59314ff406c2d4839017f188d055d6438f.jpg)](http://gis.thinkgeo.com/DesktopModules/ActiveForums/viewer.aspx?portalid=1&moduleid=623&attachid=1037)

Thanks

Ondrej

LayerOverlay&nbsp;staticLayers&nbsp;=&nbsp;new&nbsp;LayerOverlay("StaticLayer");  
  
staticLayers.WebImageFormat&nbsp;=&nbsp;WebImageFormat.Png;

countriesLayer&nbsp;=&nbsp;new&nbsp;MsSql2008FeatureLayer(System.Configuration.ConfigurationManager.ConnectionStrings["Location"].ConnectionString,&nbsp;"countryLayer",&nbsp;"oid");

countriesLayer.ZoomLevelSet.ZoomLevel01.DefaultAreaStyle&nbsp;=&nbsp;AreaStyles.CreateSimpleAreaStyle(GeoColor.FromArgb(255,&nbsp;242,&nbsp;239,&nbsp;233),&nbsp;GeoColor.FromArgb(255,&nbsp;128,&nbsp;128,&nbsp;128),&nbsp;1);

countriesLayer.ZoomLevelSet.ZoomLevel01.ApplyUntilZoomLevel&nbsp;=&nbsp;ApplyUntilZoomLevel.Level20;

countriesLayer.FeatureSource.Projection&nbsp;=&nbsp;Projection.CloneDeep();

staticLayers.Layers.Add(countriesLayer);

---

<div class="post-metadata">

**Author:** ![ThinkGeo](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/thinkgeo/32/25029_2.png) [@ThinkGeo](https://community.thinkgeo.com/u/ThinkGeo)\
**Post date:** [August 14, 2009, 3:26am UTC](https://community.thinkgeo.com/t/mssql2008featurelayer-in-the-version-182/4928/2 "2009-08-14T03:26:43Z")

</div>

Ondrej,

Probably&nbsp;the&nbsp;reason&nbsp;is&nbsp;that&nbsp;we&nbsp;change&nbsp;the&nbsp;default&nbsp;value&nbsp;of&nbsp;Srid&nbsp;from&nbsp;0&nbsp;to&nbsp;4326,while&nbsp;when&nbsp;you&nbsp;imported&nbsp;data&nbsp;to&nbsp;database,&nbsp;your&nbsp;did&nbsp;not&nbsp;set&nbsp;the&nbsp;srid&nbsp;correctly,&nbsp;so&nbsp;its&nbsp;value&nbsp;is&nbsp;still&nbsp;0.

Can&nbsp;you&nbsp;try&nbsp;to&nbsp;set&nbsp;the&nbsp;srid&nbsp;for&nbsp;the&nbsp;layer&nbsp;as&nbsp;following&nbsp;to&nbsp;see&nbsp;it&nbsp;works:

`staticLayers.Srid = 0;`

Let&nbsp;me&nbsp;know&nbsp;if&nbsp;any&nbsp;more&nbsp;questions.

Thanks.

Yale  
  
&nbsp;

---

<div class="post-metadata">

**Author:** ![ondrej\_kaspar](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/o/258eb7/32.png) [@ondrej\_kaspar](https://community.thinkgeo.com/u/ondrej_kaspar)\
**Post date:** [August 17, 2009, 4:05am UTC](https://community.thinkgeo.com/t/mssql2008featurelayer-in-the-version-182/4928/3 "2009-08-17T04:05:03Z")

</div>

Thanks,&nbsp;there&nbsp;was&nbsp;a&nbsp;problem.&nbsp;It&nbsp;works&nbsp;fine.

Ondrej

---

<div class="post-metadata">

**Author:** ![ThinkGeo](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/thinkgeo/32/25029_2.png) [@ThinkGeo](https://community.thinkgeo.com/u/ThinkGeo)\
**Post date:** [August 17, 2009, 4:14am UTC](https://community.thinkgeo.com/t/mssql2008featurelayer-in-the-version-182/4928/4 "2009-08-17T04:14:22Z")

</div>

Ondrej,&nbsp;  
&nbsp;&nbsp;  
&nbsp;No&nbsp;problem,&nbsp;any&nbsp;more&nbsp;questions&nbsp;let&nbsp;us&nbsp;know.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Thanks.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Yale&nbsp;