[mapguide-users] RE: Accessing views/queries in MS Access

[Warren Medernach]

Hi Jackie,

The XML in the post below is the xml you would 'push' into the MapGuide
through the SETRESOURCEDATA function.  But before that can be pushed in,
you need to setup the resource through the SETRESOURCE call.

Here is a sample of the XML to push in through the SETRESOURCE:

<?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>%MG_LOGIN_USERNAME%</Value>
  </Parameter>
  <Parameter>
    <Name>Password</Name>
    <Value>%MG_LOGIN_PASSWORD%</Value>
  </Parameter>
  <Parameter>
    <Name>DataSourceName</Name>
    <Value><ODBC Data Source Name></Value>
  </Parameter>
  <Parameter>
    <Name>GenerateDefaultGeometryProperty</Name>
    <Value>FALSE</Value>
  </Parameter>
  <ConfigurationDocument>config</ConfigurationDocument>
</FeatureSource>


Hope this helps

   Warren Medernach


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jackie Ng
Sent: Tuesday, March 06, 2007 12:07 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] RE: Accessing views/queries in MS Access


What is that XML (in the linked post) describing? I've never seen it
before.

I'm wondering if I do create such an XML document, where am I supposed
to put it? (SetResource ?)

Regards,

- Jackie


Should we not clarify this a bit though...
 
It is possible to get at a view...  just not through the Studio UI...
 
A view can be created by overriding the schema and pushing the XML
through the MapAgent..
 
See the following post:
http://www.nabble.com/I-can%27t-see-views-when-I-use-the-FDO-ODBC.-tf189
7275s16610.html#a5202964
 

   Warren Medernach
--
View this message in context:
http://www.nabble.com/Accessing-views-queries-in-MS-Access-tf3232574s166
10.html#a9326588
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users