Opened 14 years ago

Closed 12 years ago

#1477 closed defect (fixed)

ODBC dataconnection (MS Access) problem

Reported by: andrewd Owned by: jng
Priority: high Milestone: Maestro-3.5
Component: Maestro Version:
Severity: major Keywords:
Cc: trevorwekel External ID:

Description

If I create an ODBC dataconnection (to an Access MDB) using DSN, in any version of Maestro (tried as far back as 1.0.9), it fails. This is the case for any mdb I've tested (more than 1).

If I preview the dataconnection, I can view the data in tabular format, but trying to view the features from there always throws me an "argument is null" message in the preview window.

Something is being saved incorrectly in the config doc, I suspect. If I do the exact same thing in Mapguide Studio, it works flawlessly.

In my cases, it's a point layer that I'm ultimately after - so I'm selecting my columns and then expect a point class to be created. One possible clue as to what the problem may be is that in MG Studio, my dataconnection is Property Type "point". In Maestro, the same thing is listed as "point curve surface".

It's completely reproducible (by me, anyway), so any additional information needed....I'll attach the configuration documents and xml for both - though MG Studio's config doc is pretty mangled.

Change History (25)

comment:1 by andrewd, 14 years ago

MG Studio dataconnection XML:

<?xml version="1.0" encoding="utf-8"?> <FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">

<Provider>OSGeo.ODBC</Provider> <Parameter>

<Name>DataSourceName</Name> <Value>438253</Value>

</Parameter> <Parameter>

<Name>GenerateDefaultGeometryProperty</Name> <Value>FALSE</Value>

</Parameter> <ConfigurationDocument>config</ConfigurationDocument>

</FeatureSource>

comment:2 by andrewd, 14 years ago

Version: 2.2.0

comment:3 by andrewd, 14 years ago

Maestro dataconnection XML:

<?xml version="1.0" encoding="utf-8"?> <FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">

<Provider>OSGeo.ODBC</Provider> <Parameter>

<Name>UserId</Name> <Value />

</Parameter> <Parameter>

<Name>Password</Name> <Value />

</Parameter> <Parameter>

<Name>DataSourceName</Name> <Value>438253</Value>

</Parameter> <Parameter>

<Name>ConnectionString</Name> <Value />

</Parameter> <Parameter>

<Name>GenerateDefaultGeometryProperty</Name> <Value>false</Value>

</Parameter> <ConfigurationDocument>config</ConfigurationDocument>

</FeatureSource>

comment:4 by andrewd, 14 years ago

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>

comment:5 by andrewd, 14 years ago

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>

comment:6 by jng, 14 years ago

Milestone: → Maestro-3.0

comment:7 by jng, 13 years ago

Confirming:

This is only when connecting via DSN and not a direct MS Access connection string? (like: Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\Path\To\My.mdb)

comment:8 by andrewd, 13 years ago

I just tried with a connection string - same problem.

comment:9 by jng, 13 years ago

Related to #1640 and/or #1478?

comment:10 by andrewd, 13 years ago

Still broken, unfortunately...Only now, it won't even let me save my feature source (and a preview of the unsaved one doesn't work). When I try to save it, it tells me that Validation detected errors - connection test failed - which is odd, since the "test connection" button works fine.

Still can't test out the other bugs, since this one prevents me from actually saving anything to test.

comment:11 by jng, 13 years ago

Milestone: Maestro-3.0 → Maestro-3.1

comment:12 by jng, 13 years ago

Did the release of Maestro 3.1 resolve this issue for you?

comment:13 by andrewd, 13 years ago

Unfortunately not - though the error's a bit more explicit now. It would seem that the problem is with how it's handling (or failing to handle) a specific field type ("single"). Here's the error I get when I test the connection (this is the same error for multiple DNS's:

FDO Connection Status:

The remote server returned an error: (559) MgFdoException.:

An exception occurred in FDO component. Error reading Feature Schemas from XML; class 'www-dot-w3-dot-org/2001/XMLSchema:single' for object property '​Fdo:Section_Data.Station' not found.

The remote server returned an error: (559) MgFdoException.

comment:14 by jng, 13 years ago

Milestone: Maestro-3.1 → Maestro-3.5

comment:15 by trevorwekel, 12 years ago

Hi Jackie,

I have another example using an mdb using with an int16 column. When I edit the schema to select X and Y columns, I get the following error message

(559) MgFdoException.: An exception occurred in FDO component. Error reading Feature Schemas from XML; class 'www-dot-w3-dot-org/2001/XMLSchema:int16' for object property '​Fdo:Label.TextHorzAlign' not found.

Do you have any suggestions? Maestro 4.0b1 also exhibits the same issue.

comment:16 by trevorwekel, 12 years ago

Cc: trevorwekel added

comment:17 by jng, 12 years ago

Hi Trevor,

Is it possible to attach a copy this mdb or a sanitized/reduced version?

Lack of sample data to reproduce is source of inaction on these ODBC-related tickets.

comment:18 by jng, 12 years ago

Ok I think I know the cause of this issue. When serializing a logical Class Definition to a configuration document, some xsd data types are being rejected by FDO

eg. xs:int16 should be xs:short

xs:single should be xs:float

I'm currently unsure as to whether int64 properties are being properly serialized (It's currently xs:int64). I cannot seem to figure out what kind of column to create in MS access that would make FDO interpret it as a int64 property to verify this.

Anyway, if you can build from source, give r6255 a spin

comment:19 by jng, 12 years ago

Can you try this release?

​http://download.osgeo.org/mapguide/maestro/MapGuideMaestro-4.0.0.6282-PreFinal-Release.zip

This fixes Class Definition serialization issues, which is part of the configuration document that is saved back to the feature source.

Also we're using the same unique value generation technique as MapGuide Studio which may fix #1478 as well.

I want to make a final release of 4.0 soon, and I'd like to know if these two issues have been resolved.

comment:20 by andrewd, 12 years ago

I can't seem to run that version...If I extract the zip and run maestro.exe, I get an error and crash.

System.NullReferenceException: Object reference not set to an instance of an object.

at Maestro.Base.Services.ServiceRegistry.GetService[T]() in D:\Workspace\maestro-trunk\Maestro.Base\Services\ServiceRegistry.cs:line 43 at Maestro.Base.ZonedContainer.OnLoad(EventArgs e) in D:\Workspace\maestro-trunk\Maestro.Base\ZonedContainer.cs:line 68 at System.Windows.Forms.UserControl.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.OnVisibleChanged(EventArgs e) at System.Windows.Forms.ScrollableControl.OnVisibleChanged(EventArgs e) at System.Windows.Forms.Control.OnParentVisibleChanged(EventArgs e) at System.Windows.Forms.Control.OnVisibleChanged(EventArgs e) at System.Windows.Forms.ScrollableControl.OnVisibleChanged(EventArgs e) at System.Windows.Forms.Form.OnVisibleChanged(EventArgs e) at System.Windows.Forms.Control.SetVisibleCore(Boolean value) at System.Windows.Forms.Form.SetVisibleCore(Boolean value) at System.Windows.Forms.Control.set_Visible(Boolean value) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(Form mainForm) at Maestro.Program.Main() in D:\Workspace\maestro-trunk\Maestro\Program.cs:line 141

comment:21 by jng, 12 years ago

I do not understand how that error can possibly happen. I extracted the exact zip file and ran the executable with no problems

comment:22 by andrewd, 12 years ago

Beats me - but it's certainly unusable on my machine...Does it have to be extracted to a specific folder?

comment:23 by jng, 12 years ago

Are you running the executable from that folder?

comment:24 by andrewd, 12 years ago

Yes - I just extracted it and ran from the new folder that was created.

comment:25 by jng, 12 years ago

Resolution: → fixed
Status: new → closed

Fixed with revisions r6255 and r6282

Note: See TracTickets for help on using tickets.