[mapguide-trac] #1477: ODBC dataconnection (MS Access) problem
MapGuide Open Source
trac_mapguide at osgeo.org
Wed Oct 20 08:34:27 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):
Maestro 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">
<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:Fdo="http://fdo.osgeo.org/schemas/feature/Fdo"
elementFormDefault="qualified" attributeFormDefault="unqualified"
xmlns:Default="http://fdo.osgeo.org/schemas/feature/Default">
<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"
hasGeometry="false">
<xs:complexContent>
<xs:extension base="fdo:ClassType">
<xs:sequence>
<xs:element name="Item_ID" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Anom_Type" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="MEC_Typ" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="MPPEH_Typ" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Rc_Itm_Cnt" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Descript" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Nomenclat" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Depth" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Angle" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Itm_Length" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Itm_Width" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Weight" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Weight_Tot" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Date" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:dateTime" />
</xs:simpleType>
</xs:element>
<xs:element name="Fin_Dispos" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Fin_DisDat" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:dateTime" />
</xs:simpleType>
</xs:element>
<xs:element name="Post_X_Res" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Photo_Name" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Comment" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</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" hasGeometry="true"
geometryName="Geometry">
<xs:complexContent>
<xs:extension base="gml:AbstractFeatureType">
<xs:sequence>
<xs:element name="Target_ID" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Northing" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:double" />
</xs:simpleType>
</xs:element>
<xs:element name="Easting" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:double" />
</xs:simpleType>
</xs:element>
<xs:element name="Channel1" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Channel3" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Comment" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Geometry" type="gml:AbstractGeometryType"
hasMeasure="false" hasElevation="false" geometricTypes="point"
geometryTypes="point multipoint" />
</xs:sequence>
</xs:extension>
</xs:complexContent>
</xs:complexType>
<xs:complexType name="All_DataType" abstract="false"
hasGeometry="false">
<xs:complexContent>
<xs:extension base="fdo:ClassType">
<xs:sequence>
<xs:element name="Target_ID" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Northing" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:double" />
</xs:simpleType>
</xs:element>
<xs:element name="Easting" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:double" />
</xs:simpleType>
</xs:element>
<xs:element name="Channel1" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Channel3" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Comment" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Anom_Type" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="MEC_Typ" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="MPPEH_Typ" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Rc_Itm_Cnt" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Descript" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Nomenclat" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Depth" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Angle" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Itm_Length" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Itm_Width" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Weight" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Weight_Tot" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:float" />
</xs:simpleType>
</xs:element>
<xs:element name="Date" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:dateTime" />
</xs:simpleType>
</xs:element>
<xs:element name="Fin_Dispos" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Fin_DisDat" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:dateTime" />
</xs:simpleType>
</xs:element>
<xs:element name="Post_X_Res" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Photo_Name" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="255" />
</xs:restriction>
</xs:simpleType>
</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:schema>
<SchemaMapping xmlns:rdb="http://fdordbms.osgeo.org/schemas"
xmlns="http://fdoodbc.osgeo.org/schemas" provider="OSGeo.ODBC.3.3"
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="Northing">
<Column name="Northing" />
</element>
<element name="Easting">
<Column name="Easting" />
</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="Northing">
<Column name="Northing" />
</element>
<element name="Easting">
<Column name="Easting" />
</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>
</complexType>
</SchemaMapping>
</fdo:DataStore>
--
Ticket URL: <http://trac.osgeo.org/mapguide/ticket/1477#comment:5>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals
More information about the mapguide-trac
mailing list