Compiling with OGR version supporting SQL server connection

[Thomas Rokkjaer]

Great thanks Frank.
You pointed me in the right direction.
Found that I simply had to set the ODBC to System DSN.

BR
Thomas Rokkjaer


On 7/11/07, Frank Warmerdam <warmerdam at pobox.com> wrote:
>
> Thomas Rokkjaer wrote:
> > I have followed the guidelines for setting up a virtual spatial data
> connection
> > at
> >
> http://mapserver.gis.umn.edu/docs/reference/vector_data/VirtualSpatialData
> ,
> > installed FWTools 1.3.4, tested the connection via ogrinfo successfully,
> tested
> > the mapfile (specific layer attached) with the shp2img tool
> successfully, but I
> > am having problems with displaying this newly generated layer in my map
> > window.
> > At http://mapserver.gis.umn.edu/docs/howto/ogrmysql I found a how-to for
> > OGR connection to MySQL, where it is stated the following
> > prerequisite "MapServer compiled with OGR version supporting this
> > functinality". How is it possible to compile my current MapServer to
> support
> > OGR for SQL server or should it already work with the current settings?
>
> Thomas,
>
> You are configured to use the OGR ODBC driver, which should be available
> in any GDAL/OGR windows build.  So there is nothing special required.  The
> MySQL case is accessing MySQL directly rather than through ODBC.
>
> If shp2img is working, I'd suggest you carefully review permissions for
> use of the ODBC DSN for whatever user your web server is running as.
>
> >       STYLEITEM "AUTO"
>
> BTW, I don't believe that STYLEITEM "AUTO" is going to do anything
> for ODBC/VRT datasources.  It mostly is useful for mapinfo, and dgn
> file formats.
>
> Best regards,
> --
>
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | President OSGeo, http://osgeo.org
>
>


-- 
Med venlig hilsen

Thomas Rokkjær
Mobil 3095 0774

http://picasaweb.google.com/thomas.rokkjaer
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20070712/84312186/attachment.htm>