Ahh... If I set the SQL login to default to any other schema than dbo, then ALL schemas will display features from Lat Long.<br><br>If it is defaulted to dbo, then only dbo will display.<br><br><br>Please correct me if anyone gets different results.<br>
<br><br>Cheers,<br><br>Kori Maleski<br><br><br><br><br><br><div class="gmail_quote">On Fri, Aug 13, 2010 at 4:51 PM, Kori Maleski <span dir="ltr"><<a href="mailto:kori.maleski@gmail.com">kori.maleski@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">The ODBC SQL login has the same rights, and the schemas are in the same database.<br><br>The work around is to create a dbo.view of the other schema.table. <br>
<br><br><br>Cheers,<br><font color="#888888"><br>Kori Maleski</font><div><div></div><div class="h5"><br><br><br><div class="gmail_quote">
On Fri, Aug 13, 2010 at 4:33 PM, Dave Wilson <span dir="ltr"><<a href="mailto:dave.wilson@autodesk.com" target="_blank">dave.wilson@autodesk.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="EN-US">
<div>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">When you say it doesn't work under another schema does your ODBC
login have rights to the other schema and some of the system tables? I'm not
sure exactly what the rights need to be. This is a question for the FDO users
list.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">I suspect it's a permissions issue.</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);">Dave</span></p>
<p class="MsoNormal"><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;">
<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org" target="_blank">mapguide-users-bounces@lists.osgeo.org</a>]
<b>On Behalf Of </b>Kori Maleski<br>
<b>Sent:</b> Friday, August 13, 2010 3:57 PM<br>
<b>To:</b> MapGuide Users Mail List<br>
<b>Subject:</b> Re: [mapguide-users] Problem with ODBC and Point Feature
Display via Lat Long</span></p>
</div><div><div></div><div>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="margin-bottom: 12pt;">Thanks Warren!<br>
<br>
So much for organizing by schema. Can't wait to get to switch to MS SQL
2008 for spatial.<br>
<br>
<br>
Cheers,<br>
<br>
<br>
Kori Maleski</p>
<div>
<p class="MsoNormal">On Fri, Aug 13, 2010 at 3:50 PM, Warren Medernach <<a href="mailto:wmedernach@gmail.com" target="_blank">wmedernach@gmail.com</a>> wrote:</p>
<p class="MsoNormal">Hey Kori,</p>
<div>
<p class="MsoNormal">While this isn't an 'identical' test, I just tested this in
MGE 2011 and can confirm the same results.</p>
</div>
<div>
<p class="MsoNormal">The points DO NOT display under a different schema.</p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
Warren M</p>
<div>
<div>
<div>
<p class="MsoNormal">On Fri, Aug 13, 2010 at 3:27 PM, Kori Maleski <<a href="mailto:kori.maleski@gmail.com" target="_blank">kori.maleski@gmail.com</a>>
wrote:</p>
</div>
</div>
<blockquote style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(204, 204, 204); border-width: medium medium medium 1pt; padding: 0in 0in 0in 6pt; margin-left: 4.8pt; margin-right: 0in;">
<div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
<br>
MapGuide 2.1.0.4283<br>
SQL Server 2005<br>
ODBC FDO 3.4<br>
<br>
<br>
I can create a Feature from the Lat Long columns of a table under the dbo
schema, but if I use another schema the feature does not display in the map.<br>
<br>
<br>
Anybody else encounter this?<br>
<br>
<br>
<br>
Cheers,<br>
<span style="color: rgb(136, 136, 136);"><br>
<br>
Kori Maleski<br>
<br>
</span></p>
</div>
</div>
<div>
<p class="MsoNormal" style="margin-bottom: 12pt;">_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"> </p>
</div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a></p>
</div>
<p class="MsoNormal"> </p>
</div></div></div>
</div>
<br>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org" target="_blank">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></blockquote></div><br>
</div></div></blockquote></div><br>