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

[Orest Halustchak]

Yes, this is something that we're looking at for the FDO ODBC provider -
mapping a class to an existing query in MS Access (as well as view
support for other providers).
 
Orest.

  _____  

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jason Birch
Sent: Monday, February 19, 2007 10:53 AM
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Accessing views/queries in MS Access


 
There is a limited case where you can access views, but only if you are
using MapGuide Open Source with the King.Oracle provider and an Oracle
database.
 
If you're not using this combination there is no current solution, but
it looks like future releases of FDO may support these.  Last week a
code revision was posted entitled "Change 2519: Reverse engineer views
by default", with the description "This submission modifies the Generic
Schema Manager to generate classes for views, by default, when connected
to a non-FDO datastore."
 
Jason

  _____  

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Campbell,
Keith A
Sent: Monday, February 19, 2007 06:48
To: MapGuide Users Mail List
Subject: RE: [mapguide-users] Accessing views/queries in MS Access


You cannot access views in any database with MapGuide Open Source or
Enterprise as you could in the old MapGuide 6.x, etc. This is a big
shortcoming in my opinion, but I believe there may be support for them
in future.
 
As a workaround, we have data in SQL Server linked to SDF files in an
MGOS implementation - we use stored procedures in SQL Server to
create/update tables instead of using views. This approach may be
difficult in other situations depending on how your overall application
is structured.
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070219/8916b652/attachment.html