Jerry, here are some instructions describing how a colleague used workarounds and CLR extensions to enable the delivery of spatial information with GeoServer and SQL Server 2005: https://www.seegrid.csiro.au/wiki/Infosrvices/GeoserverMsSqlServer2005Connectivity
This worked well with WFS for simple features and app-schema complex features. This approach has not been tested with WMS; I do not know if there are spatial indices, which are IIRC required by WMS. Kind regards, Ben. On 09/10/13 19:19, Jerry O'Sullivan wrote: > Stefano > > Thanks..the sql server db is 2005 so I don't have geometry support > available in the db > > The only options I can see are > 1) Install postgres to pull the data from sql server every hour but th > is seems a bit messy but might be the best option if I use geoserver > 2) investigate if there is an ogr data store for geoserver out there. > 3) Use Mapserver! > > What do you think? > > Thanks, > Jerry > > On Oct 9, 2013 11:10 a.m., "Stefano Iacovella" > <[email protected] <mailto:[email protected]>> wrote: > > Hi Jerry, > > In Oracle or PostGIS I would create a spatial view converting your > textual values to a geometry field. > You should use a similar function in SQL Server and then publish the > view on GeoServer. > > Kind Regards, > > Stefano > > --------------------------------------------------- > 41.95581N 12.52854E > > > http://www.linkedin.com/in/stefanoiacovella > > http://twitter.com/#!/Iacovellas > > > 2013/10/9 osullivj <[email protected] > <mailto:[email protected]>> > > Hi > > I have a SQL Server DB with point data stored in 2 Columns (X,Y) > > Can these be mapped directly using GeoServer > > Thanks, > Jerry > > > > -- > View this message in context: > > http://osgeo-org.1560.x6.nabble.com/Point-Data-in-X-Y-Fields-in-RDBMS-tp5082553.html > Sent from the GeoServer - User mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get > the most from > the latest Intel processors and coprocessors. See abstracts and > register > > > http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk > _______________________________________________ > Geoserver-users mailing list > [email protected] > <mailto:[email protected]> > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk > > > > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Ben Caradoc-Davies <[email protected]> Software Engineer CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60134071&iu=/4140/ostg.clktrk _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
