[mapserver-users] OGRVRT Data Sources and SQL server

[Jeff McKenna]

On 12-05-29 8:40 AM, Jeff McKenna wrote:
> On 12-05-29 5:57 AM, Chris Jackson wrote:
>> Hi Robert
>>
>> Thanks for the reply, you have got me to a point where ogrinfo
>> commandline processes an ovf file using sql authentication fine. 
>> However it will still not display using shp2img commandline (other layer
>> in mapfile draws fine). My layer definition is fairly simple, but I am
>> scratching my head to think what is stopping the layer from drawing! 
>> The points are in standard lat/long so using WGS84 (layer and map
>> projection).
> 
> Hmm tricky.  I would then:
> 
> - remove all layers from my mapfile, leaving only the one problem layer
> - remove all PROJECTION objects
> - then I would execute ogrinfo on my ovf file
> - and use the extents returned there in the EXTENT parameter of my
> mapfile.
> 
> Worth a shot.

Then finally, if I can't get that to work, I would try to get the exact
command/sql being sent to my database, through enabling debugging for
that layer (see http://www.mapserver.org/optimization/debugging.html).
Sometimes just seeing the sql will point to a problem.

Hope that all helps.

-jeff




-- 
Jeff McKenna
MapServer Consulting and Training Services
http://www.gatewaygeomatics.com/