[mapguide-users] Spatial Context for ODBC data connection

[Kenneth Skovhede, GEOGRAF A/S]

The ODBC provider is a bit different from the other providers.
The <SupplementalSpatialContextInfo> seems to be ignored completely,
and the SpatialContext is always empty, even when the provider works.

For backwards compatibility, Maestro will try to read the 
SupplementalSpatialContextInfo,
and set the coordinate system "the ODBC provider way" instead.
This is what fails in your case.

Try removing the SupplementalSpatialContextInfo tag in the xml, and then 
set the coordinate system using the GUI,
and it should work correctly.

Regards, Kenneth Skovhede, GEOGRAF A/S



sekko970 skrev:
> Dear Kenneth,
> using the last preview version of Maestro, when we set the coordinate system
> override for ODBC data connection, the following error appears:
>
> System.Net.WebException: Errore del server remoto: (559)
> MgCoordinateSystemConversionFailedException.
>    in System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest&
> request)
>    in System.Net.WebClient.DownloadData(Uri address)
>    in System.Net.WebClient.DownloadData(String address)
>    in
> OSGeo.MapGuide.MaestroAPI.HttpCoordinateSystem.ConvertWktToCoordinateSystemCode(String
> wkt)
>    in
> OSGeo.MapGuide.Maestro.ResourceEditors.FeatureSourceEditorODBC.Save(String
> savename)
>    in
> OSGeo.MapGuide.Maestro.ResourceEditors.FeatureSourceEditorODBC.ValidateResource(Boolean
> recurse)
>    in
> OSGeo.MapGuide.Maestro.ResourceEditors.FeatureSourceEditorBase.ValidateResource(Boolean
> recurse)
>    in OSGeo.MapGuide.Maestro.EditorInterface.Save(String resid)
>    in OSGeo.MapGuide.Maestro.FormMain.SaveResource()
>    in OSGeo.MapGuide.Maestro.FormMain.SaveResourceButton_Click(Object
> sender, EventArgs e)
>    in System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
>    in System.Windows.Forms.ToolStripButton.OnClick(EventArgs e)
>    in System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
>    in System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
>    in System.Windows.Forms.ToolStripItem.FireEventInteractive(EventArgs e,
> ToolStripItemEventType met)
>    in System.Windows.Forms.ToolStripItem.FireEvent(EventArgs e,
> ToolStripItemEventType met)
>    in System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
>    in System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons
> button, Int32 clicks)
>    in System.Windows.Forms.Control.WndProc(Message& m)
>    in System.Windows.Forms.ScrollableControl.WndProc(Message& m)
>    in System.Windows.Forms.ToolStrip.WndProc(Message& m)
>    in System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
>    in System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
>    in System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg,
> IntPtr wparam, IntPtr lparam)
>
>
>
> As you can see in following xml editor substring, with our current Maestro
> version (1.0.9.15910), we save the coordinate system override for ODBC data
> connection without any problem:
>
>   <SupplementalSpatialContextInfo>
>     <Name>Default</Name>
>     <CoordinateSystem>PROJCS["Monte Mario / Italy zone 1",GEOGCS["Monte
> Mario",DATUM["Monte_Mario",SPHEROID["International
> 1924",6378388,297,AUTHORITY["EPSG","7022"]],AUTHORITY["EPSG","6265"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4265"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",9],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",1500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AUTHORITY["EPSG","3003"]]</CoordinateSystem>
>   </SupplementalSpatialContextInfo>
>
>
> but the spatial context info is still empty:
>
> <?xml version="1.0"?>
> <FdoSpatialContextList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xsi:noNamespaceSchemaLocation="FdoSpatialContextList-1.0.0.xsd">
>   <ProviderName />
> </FdoSpatialContextList>
>
>
> Can you help me?
> Fabio
>
> -------------------------------------------------------------------------------------------
>
>
> nasp wrote:
>   
>> Thank you very much.
>> I'm going to download last preview version of Maestro. 
>> I will post results after testing my application.
>>
>> Regards, 
>> Naspi
>>
>>
>> Kenneth Skovhede, GEOGRAF A/S wrote:
>>     
>>> I you are using Maestro, you must use the latest preview version.
>>> ODBC handles projection a little different than the
>>> other providers, and this has been adressed recently.
>>>
>>> Regards, Kenneth Skovhede, GEOGRAF A/S
>>>
>>>
>>>
>>> nasp skrev:
>>>       
>>>> Hi,
>>>> I don't know how to set spatial context in my ODBC data connection to
>>>> SQL
>>>> server.
>>>>
>>>> For this reason I can't set coordinate system overrides. 
>>>> As a conseguences I can't make a buffer for a point resource belonging
>>>> to
>>>> ODBC data connection.
>>>>
>>>> Please, could someone help me?
>>>>
>>>> Regards, Naspi
>>>>   
>>>>         
>>> _______________________________________________
>>> mapguide-users mailing list
>>> mapguide-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>
>>>
>>>       
>>     
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20090706/dbe37cfa/attachment.html