<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><P>Hi Bob,</P>
<P> </P>
<P> I think the issue which you talking about is due to caching problem of MapGuide ,i also tried with KingOracle Provider and in that case also if you change or add new column it will show only once you restart the Map Server.</P>
<P> </P>
<P>Anyway you can give a try with King Oracle FDO Provider and you can also download fdo2fdo tools in order to create KingFdo Class Table for Oracle.</P>
<P> </P>
<P>Max </P>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR><BR> </DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">----- Original Message ----<BR>From: Bob Cassarly <bob.cassarly@famis.com><BR>To: mapguide-users@lists.osgeo.org<BR>Sent: Monday, March 10, 2008 4:06:08 AM<BR>Subject: Re: [mapguide-users] Problems with SDF/Database Joins (Oracle)<BR><BR><BR>Max,<BR><BR>That is the driver I was using from my DSN.<BR>My problem appears to be a problem is with the way MapGuide OS is caching<BR>the database table/columns<BR><BR>If you first create a new Data Connection that uses a DSN (that uses the<BR>Oracle Instant Client 10.2.0.3) it does indeed work and the tables<BR>enumerate. The problem I noticed with this is that if you change a table or<BR>view definition to add a table/view column the new column does not appear in<BR>the label/theme list. This seems like a bug to me (especially considering<BR>there does not seem to be a mechanism to update the cache).<BR><BR>If
create a Data Source that uses the FDO ODBC Microsoft for Oracle driver<BR>it connect sucessfully to the database but the tables do not enumerate. If<BR>I save that Data Connection as then later change Data Connection to use a<BR>DSN the tables do not enumerate. This also seems like a bug to me.<BR><BR>So the question is where are the database tables/columns cached too and is<BR>it possible to refresh the cache. Personally I would prefer that the<BR>table/column NOT be cached at all but maybe I am asking too much. <BR><BR>Bob<BR><BR><BR><BR>Hi,<BR> I think you try to connect Oracle Database with Oracle Instant<BR>Client 10.2.0.3 and oracle odbc driver-win32 10.2.0.3 . <BR><BR>Try ODBC FDO "Connect via a Data Source Name (DSN) set up on this server"<BR>and use the above DSN which you created using the oracle odbc driver-win32<BR>10.2.0.3 . <BR><BR><BR>Max !!<BR><BR><BR>-- <BR>View this
message in context: <A href="http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15946485.html" target=_blank>http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15946485.html</A><BR>Sent from the MapGuide Users mailing list archive at <A href="http://nabble.com/" target=_blank>Nabble.com</A>.<BR><BR>_______________________________________________<BR>mapguide-users mailing list<BR><A href="mailto:mapguide-users@lists.osgeo.org" ymailto="mailto:mapguide-users@lists.osgeo.org">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></DIV>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><BR></DIV></div><br>
<hr size=1>Looking for last minute shopping deals? <a href="http://us.rd.yahoo.com/evt=51734/*http://tools.search.yahoo.com/newsearch/category.php?category=shopping">
Find them fast with Yahoo! Search.</a></body></html>