<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>RE: [mapguide-users] RE: ODBC problem...</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place" downloadurl="http://www.5iantlavalamp.com/"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceType" downloadurl="http://www.5iantlavalamp.com/"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PlaceName" downloadurl="http://www.5iantlavalamp.com/"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle19
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:2092579137;
mso-list-template-ids:1977498876;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Andy:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>What’s the property_joined table you
have? I have a table that contains the parcel data with a column that matches the
SDF_ID. I’m assuming your property_joined table is similar, correct?
You didn’t do anything special to this table, did you?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Juan Butler - Senior Programmer/Analyst<br>
<st1:PersonName w:st="on">GIS</st1:PersonName> Applications<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Pinellas</st1:PlaceName> <st1:PlaceType
w:st="on">County</st1:PlaceType></st1:place> Information Systems<br>
<a href="mailto:jpbutler@pinellascounty.org">jpbutler@pinellascounty.org</a><font
color=navy><span style='color:navy'><o:p></o:p></span></font></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Andy Morsell
[mailto:amorsell@spatialgis.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
3:01 PM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Here are some screenshots. I think
that will help clarify things.</span></font><o:p></o:p></p>
<p><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'><!-- Converted from text/rtf format -->Andy
</span></font><o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Butler,
Juan P [mailto:jpbutler@co.pinellas.fl.us] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
11:40 AM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I’m using the Access database as the
secondary and still not able to pull up the graphics connecting to the
secondary. In the Feature Data Setup for the layer, I go and choose
the Access database in the Feature Class dropdown. Is this not
correct? If I don’t do this, the Access fields won’t show
up. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Juan Butler - Senior Programmer/Analyst<br>
<st1:PersonName w:st="on">GIS</st1:PersonName> Applications<br>
<st1:place w:st="on"><st1:PlaceName w:st="on">Pinellas</st1:PlaceName> <st1:PlaceType
w:st="on">County</st1:PlaceType></st1:place> Information Systems<br>
<a href="mailto:jpbutler@pinellascounty.org">jpbutler@pinellascounty.org</a><font
color=navy><span style='color:navy'><o:p></o:p></span></font></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Andy Morsell
[mailto:amorsell@spatialgis.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
2:06 PM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Thanks for the clarification Dave. I
hadn't even looked at my spatial datasource to notice that there is now a Join
portion of the dialog at that level. I was thinking the join was only
defined from the tabular datasource. Now that I have set it up there
(pretty much using the same steps I previously outlined) it is working
fine. I can display my parcel polygons with tooltips and properties
derived from the secondary Access database.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>It is a little confusing that it can be
done the other way around and that a layer can be seemingly created from that
while choosing the geometry feature from the secondary datasource. That
process should probably be changed in Studio to prevent that from happening.</span></font><o:p></o:p></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>I'm still having problems with point data
from an ODBC resource, but will do some more experimenting later.</span></font><o:p></o:p></p>
</div>
<p><font size=1 face=Tahoma><span style='font-size:7.5pt;font-family:Tahoma'><!-- Converted from text/rtf format -->Andy
</span></font><o:p></o:p></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Dave
Wilson [mailto:dave.wilson@autodesk.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Wednesday, April 19, 2006
7:26 AM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Am I correct in understanding you are
using the spatial resource as the Secondary resource? The Spatial resource
needs to be the primary resource if this is what the layer is to be based on.
The join is generally for attaching attribute data to spatial data such as
adding properties from an Access table to an SDF.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Point data from an ODBC resource should
also work as a primary resource.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'>Dave Wilson</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabIndex=-1>
</span></font></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><font size=2 face=Tahoma><span
style='font-size:10.0pt;font-family:Tahoma;font-weight:bold'>From:</span></font></b><font
size=2 face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Andy
Morsell [mailto:amorsell@spatialgis.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, April 18, 2006 6:22
PM<br>
<b><span style='font-weight:bold'>To:</span></b> users@mapguide.osgeo.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [mapguide-users] RE:
ODBC problem...</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><!-- Converted from text/rtf format -->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.</span></font><o:p></o:p></p>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>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. </span></font> <o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Choose your other datasource in the repository
that you are connecting to </span></font><o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Choose the Primary Feature class (table)</span></font>
<o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Click on your New Join below the Extension you
just created</span></font> <o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>You will most likely only have one option for
the Secondary class (table)</span></font> <o:p></o:p></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo1'><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Select your Primary Column and Secondary Column
fields. These are the key fields tying together your primary
(tabular) and secondary (spatial) datasources.</span></font> <o:p></o:p></li>
</ul>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>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.</span></font><o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Andy
Morsell</span></font> <o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>-----Original
Message-----</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>From:
Thud732 [</span></font><a href="mailto:devlin.fung@sapience360.com"><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>mailto:devlin.fung@sapience360.com</span></font></a><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>] </span></font><br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Sent:
Tuesday, April 18, 2006 4:30 PM</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>To:
users@mapguide.osgeo.org</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Subject:
[mapguide-users] RE: ODBC problem...</span></font> <o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Hi
Andy:</span></font> <o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Can
you please outline your 'join connection' steps? I was able to establish a
successful test connection, but failed when joining.</span></font><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Thank
you.</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>TC</span></font>
<br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>--</span></font>
<br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>View
this message in context: </span></font><a
href="http://www.nabble.com/Failed-to-test-the-Web-Server-Extensions-after-installation-t1432431.html#a3978903"><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>http://www.nabble.com/Failed-to-test-the-Web-Server-Extensions-after-installation-t1432431.html#a3978903</span></font></a><o:p></o:p></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Sent
from the OSGeo MapGuide forum at Nabble.com.</span></font> <o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>---------------------------------------------------------------------</span></font>
<br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>To
unsubscribe, e-mail: users-unsubscribe@mapguide.osgeo.org</span></font> <br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>For
additional commands, e-mail: users-help@mapguide.osgeo.org</span></font> <o:p></o:p></p>
</div>
</body>
</html>