[mapguide-trac] #1477: ODBC dataconnection (MS Access) problem

MapGuide Open Source trac_mapguide at osgeo.org
Wed Oct 20 08:34:05 EDT 2010 

#1477: ODBC dataconnection (MS Access) problem
-----------------------+----------------------------------------------------
   Reporter:  andrewd  |       Owner:  jng
       Type:  defect   |      Status:  new
   Priority:  high     |   Milestone:     
  Component:  Maestro  |     Version:     
   Severity:  major    |    Keywords:     
External_id:           |  
-----------------------+----------------------------------------------------

Comment(by andrewd):

 MG Studio config doc:

 <?xml version="1.0" encoding="UTF-8" ?><fdo:DataStore
 xmlns:xs="http://www.w3.org/2001/XMLSchema"
 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:xlink="http://www.w3.org/1999/xlink"
 xmlns:gml="http://www.opengis.net/gml"
 xmlns:fdo="http://fdo.osgeo.org/schemas"
 xmlns:fds="http://fdo.osgeo.org/schemas/fds"><gml:DerivedCRS gml:id="CSRS
 .UTM-20N"><gml:remarks>CSRS.UTM-20N</gml:remarks><gml:srsName>CSRS.UTM-
 20N</gml:srsName><gml:validArea><gml:boundingBox><gml:pos>339513.882000
 5259221.588000</gml:pos><gml:pos>340530.943000
 5260446.284000</gml:pos></gml:boundingBox></gml:validArea><gml:baseCRS><fdo:WKTCRS
 gml:id="CSRS.UTM-20N"><gml:srsName>CSRS.UTM-
 20N</gml:srsName><fdo:WKT>PROJCS[&quot;CSRS.UTM-20N&quot;,GEOGCS[&quot;LL-
 CSRS&quot;,DATUM[&quot;CSRS&quot;,SPHEROID[&quot;GRS1980&quot;,6378137.000,298.25722210]],PRIMEM[&quot;Greenwich&quot;,0],UNIT[&quot;Degree&quot;,0.017453292519943295]],PROJECTION[&quot;Transverse_Mercator&quot;],PARAMETER[&quot;false_easting&quot;,500000.000],PARAMETER[&quot;false_northing&quot;,0.000],PARAMETER[&quot;central_meridian&quot;,-63.00000000000000],PARAMETER[&quot;scale_factor&quot;,0.9996],PARAMETER[&quot;latitude_of_origin&quot;,0.000],UNIT[&quot;Meter&quot;,1.00000000000000]]</fdo:WKT></fdo:WKTCRS></gml:baseCRS><gml:definedByConversion
 xlink:href="http://fdo.osgeo.org/coord_conversions#identity"/><gml:derivedCRSType
 codeSpace="http://fdo.osgeo.org/crs_types">geographic</gml:derivedCRSType><gml:usesCS
 xlink:href="http://fdo.osgeo.org/cs#default_cartesian"/></gml:DerivedCRS><xs:schema
 xmlns:xs="http://www.w3.org/2001/XMLSchema"
 targetNamespace="http://fdo.osgeo.org/schemas/feature/Default"
 xmlns:fdo="http://fdo.osgeo.org/schemas"
 xmlns:gml="http://www.opengis.net/gml"
 xmlns:Default="http://fdo.osgeo.org/schemas/feature/Default"
 elementFormDefault="qualified"
 attributeFormDefault="unqualified"><xs:element name="Dig_Sheet"
 type="Default:Dig_SheetType" abstract="false"
 substitutionGroup="gml:_Feature"><xs:key name="Dig_SheetKey"><xs:selector
 xpath=".//Dig_Sheet"/><xs:field
 xpath="Item_ID"/></xs:key></xs:element><xs:complexType
 name="Dig_SheetType" abstract="false"
 fdo:hasGeometry="false"><xs:complexContent><xs:extension
 base="gml:AbstractFeatureType"><xs:sequence><xs:element
 name="Item_ID"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Anom_Type"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="MEC_Typ"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="MPPEH_Typ"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Rc_Itm_Cnt" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Descript"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Nomenclat" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Depth" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Angle" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Itm_Length" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Itm_Width" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Weight" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Weight_Tot" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Date" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:dateTime"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Fin_Dispos"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Fin_DisDat" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:dateTime"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Post_X_Res"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Photo_Name"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Comment"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element></xs:sequence></xs:extension></xs:complexContent></xs:complexType><xs:element
 name="Targets" type="Default:TargetsType" abstract="false"
 substitutionGroup="gml:_Feature"><xs:key name="TargetsKey"><xs:selector
 xpath=".//Targets"/><xs:field
 xpath="Target_ID"/></xs:key></xs:element><xs:complexType
 name="TargetsType" abstract="false"
 fdo:geometryName="Geometry"><xs:complexContent><xs:extension
 base="gml:AbstractFeatureType"><xs:sequence><xs:element
 name="Target_ID"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Channel1" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Channel3" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Comment"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Geometry" type="gml:AbstractGeometryType" fdo:hasMeasure="false"
 fdo:hasElevation="false" fdo:srsName="CSRS.UTM-20N"
 fdo:geometricTypes="point " fdo:geometryTypes="point multipoint
 "><xs:annotation><xs:documentation/></xs:annotation></xs:element></xs:sequence></xs:extension></xs:complexContent></xs:complexType><xs:element
 name="All_Data" type="Default:All_DataType" abstract="false"
 substitutionGroup="gml:_Feature"><xs:key name="All_DataKey"><xs:selector
 xpath=".//All_Data"/><xs:field
 xpath="Target_ID"/></xs:key></xs:element><xs:complexType
 name="All_DataType" abstract="false"
 fdo:hasGeometry="false"><xs:complexContent><xs:extension
 base="gml:AbstractFeatureType"><xs:sequence><xs:element
 name="Target_ID"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Channel1" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Channel3" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Comment"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Anom_Type"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="MEC_Typ"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="MPPEH_Typ"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Rc_Itm_Cnt" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Descript"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Nomenclat" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Depth" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Angle" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Itm_Length" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Itm_Width" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Weight" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Weight_Tot" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:float"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Date" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:dateTime"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Fin_Dispos"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Fin_DisDat" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:dateTime"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Post_X_Res"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Photo_Name"
 minOccurs="0"><xs:annotation><xs:documentation/></xs:annotation><xs:simpleType><xs:restriction
 base="xs:string"><xs:maxLength
 value=""/></xs:restriction></xs:simpleType></xs:element><xs:element
 name="Easting" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:double"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element><xs:element
 name="Northing" minOccurs="0"><xs:simpleType><xs:restriction
 base="xs:double"/></xs:simpleType><xs:annotation><xs:documentation/></xs:annotation></xs:element></xs:sequence></xs:extension></xs:complexContent></xs:complexType></xs:schema><SchemaMapping
 xmlns:rdb="http://fdordbms.osgeo.org/schemas"
 xmlns="http://fdoodbc.osgeo.org/schemas" provider="OSGeo.ODBC.3.2"
 name="Default"><complexType name="Dig_SheetType"><Table
 name="Dig_Sheet"/><element name="Item_ID"><Column
 name="Item_ID"/></element><element name="Anom_Type"><Column
 name="Anom_Type"/></element><element name="MEC_Typ"><Column
 name="MEC_Typ"/></element><element name="MPPEH_Typ"><Column
 name="MPPEH_Typ"/></element><element name="Rc_Itm_Cnt"><Column
 name="Rc_Itm_Cnt"/></element><element name="Descript"><Column
 name="Descript"/></element><element name="Nomenclat"><Column
 name="Nomenclat"/></element><element name="Depth"><Column
 name="Depth"/></element><element name="Angle"><Column
 name="Angle"/></element><element name="Itm_Length"><Column
 name="Itm_Length"/></element><element name="Itm_Width"><Column
 name="Itm_Width"/></element><element name="Weight"><Column
 name="Weight"/></element><element name="Weight_Tot"><Column
 name="Weight_Tot"/></element><element name="Date"><Column
 name="Date"/></element><element name="Fin_Dispos"><Column
 name="Fin_Dispos"/></element><element name="Fin_DisDat"><Column
 name="Fin_DisDat"/></element><element name="Post_X_Res"><Column
 name="Post_X_Res"/></element><element name="Photo_Name"><Column
 name="Photo_Name"/></element><element name="Comment"><Column
 name="Comment"/></element></complexType><complexType
 name="TargetsType"><Table name="Targets"/><element
 name="Target_ID"><Column name="Target_ID"/></element><element
 name="Channel1"><Column name="Channel1"/></element><element
 name="Channel3"><Column name="Channel3"/></element><element
 name="Comment"><Column name="Comment"/></element><element name="Geometry"
 xColumnName="Easting" yColumnName="Northing"/></complexType><complexType
 name="All_DataType"><Table name="All_Data"/><element
 name="Target_ID"><Column name="Target_ID"/></element><element
 name="Channel1"><Column name="Channel1"/></element><element
 name="Channel3"><Column name="Channel3"/></element><element
 name="Comment"><Column name="Comment"/></element><element
 name="Anom_Type"><Column name="Anom_Type"/></element><element
 name="MEC_Typ"><Column name="MEC_Typ"/></element><element
 name="MPPEH_Typ"><Column name="MPPEH_Typ"/></element><element
 name="Rc_Itm_Cnt"><Column name="Rc_Itm_Cnt"/></element><element
 name="Descript"><Column name="Descript"/></element><element
 name="Nomenclat"><Column name="Nomenclat"/></element><element
 name="Depth"><Column name="Depth"/></element><element name="Angle"><Column
 name="Angle"/></element><element name="Itm_Length"><Column
 name="Itm_Length"/></element><element name="Itm_Width"><Column
 name="Itm_Width"/></element><element name="Weight"><Column
 name="Weight"/></element><element name="Weight_Tot"><Column
 name="Weight_Tot"/></element><element name="Date"><Column
 name="Date"/></element><element name="Fin_Dispos"><Column
 name="Fin_Dispos"/></element><element name="Fin_DisDat"><Column
 name="Fin_DisDat"/></element><element name="Post_X_Res"><Column
 name="Post_X_Res"/></element><element name="Photo_Name"><Column
 name="Photo_Name"/></element><element name="Easting"><Column
 name="Easting"/></element><element name="Northing"><Column
 name="Northing"/></element></complexType></SchemaMapping></fdo:DataStore>

-- 
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/1477#comment:4>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals

More information about the mapguide-trac mailing list