[mapguide-users] MapGuide OSGeo.ODBC FDO not releasing schema cache

[neilyoung]

Thanks for the quick reply. 

Please Forgive my ignorance, but how exactly would I do that? 

I went to the mapagent index, and selected GetResourceContent, but all i got
was a few lines of text. What would I do with that to perform the
SetResouceContent? 


zspitzer wrote:
> 
> just save the feature source definition, that will flush the cache
> 
> either via studio/maestro or via the api
> 
> geResourceContent then  setResourceContent
> 
> 
> 
> 2009/12/23 neilyoung <neil.young at ch2m.com>:
>>
>> I have numerous layers pointing ot the same ODBC connection using a DSN
>> pointing to a SQL Server database.
>>
>> We have changed the schema, however when looking at the tables, we do not
>> see the updates to the schema.
>>
>> I have disabled caching for the OSGEO.ODBC FDO
>> (DataConnectionPoolExcludedProviders = OSGeo.ODBC), and restarted the
>> service and the new schema still isn't showing up. Even if I create a new
>> DSN on the server if the database name referred to in the DSN is the
>> same,
>> then the old schema still shows up.
>>
>> Any ideas on how the cache can be removed? It seems as though it may not
>> be
>> caching, but the the cache still remains.
>>
>> All assistance is appreciated.
>> --
>> View this message in context:
>> http://n2.nabble.com/MapGuide-OSGeo-ODBC-FDO-not-releasing-schema-cache-tp4206600p4206600.html
>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
> 
> 
> 
> -- 
> Zac Spitzer
> Solution Architect / Director
> Ennoble Consultancy Australia
> http://www.ennoble.com.au
> http://zacster.blogspot.com
> +61 405 847 168
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/MapGuide-OSGeo-ODBC-FDO-not-releasing-schema-cache-tp4206600p4206675.html
Sent from the MapGuide Users mailing list archive at Nabble.com.