[mapguide-users] RE: ODBC problem...

[Chris Gountanis]

Why not create an advanced query in Access and use that single "QueryName"
as a table in MG?


--
Chris Gountanis
Programmer/Analyst - Network Administrator
cgountanis at mpower-tech.com
MPOWER TECHNOLOGIES
501 S Nicolet Road Appleton, WI 54914
Office Number: 877.269.6971
www.mpower-tech.com

Making complex information more accessible.


-----Original Message-----
From: Butler, Juan P [mailto:jpbutler at co.pinellas.fl.us] 
Sent: Wednesday, April 19, 2006 11:05 AM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] RE: ODBC problem...

I can create the join, but like Andy says, nothing comes out of it.  I go to
set up the join between the two columns and when I try and pull up the
layer, nothing.   If I choose a fields that are not related, the graphics
appear, but no tooltip from the Access database.   So I can't use any
database data as of now, correct? 

 

Juan Butler - Senior Programmer/Analyst
GIS Applications
Pinellas County Information Systems
jpbutler at pinellascounty.org

 

 

________________________________

From: Andy Morsell [mailto:amorsell at spatialgis.com]
Sent: Tuesday, April 18, 2006 8:22 PM
To: users at mapguide.osgeo.org
Subject: RE: [mapguide-users] RE: ODBC problem...

 

Here are the steps I took to create the join.  Note that I wasn't able to do
with anything with the join in terms of creating a layer from it, however.

*	Once your datasource is setup and you can see the tables listed in
the Refine Data Setup area, click the New Extended Feature Class button.  
*	Choose your other datasource in the repository that you are
connecting to 
*	Choose the Primary Feature class (table)
*	Click on your New Join below the Extension you just created
*	You will most likely only have one option for the Secondary class
(table)
*	Select your Primary Column and Secondary Column fields.  These are
the key fields tying together your primary (tabular) and secondary (spatial)
datasources.

 

If you get this far, please let us know if you can successfully create a
layer where you can view the resultant objects.  I also tried creating a
layer from X and Y points in a table from this database and, again, was not
able to view the resultant geometry.

 

Andy Morsell 

-----Original Message-----
From: Thud732 [mailto:devlin.fung at sapience360.com
<mailto:devlin.fung at sapience360.com> ]
Sent: Tuesday, April 18, 2006 4:30 PM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] RE: ODBC problem... 

 

Hi Andy: 

Can you please outline your 'join connection' steps? I was able to establish
a successful test connection, but failed when joining.

Thank you. 
TC
--
View this message in context:
http://www.nabble.com/Failed-to-test-the-Web-Server-Extensions-after-install
ation-t1432431.html#a3978903
<http://www.nabble.com/Failed-to-test-the-Web-Server-Extensions-after-instal
lation-t1432431.html#a3978903> 

Sent from the OSGeo MapGuide forum at Nabble.com. 

 

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org