Using ODBC/OVF with MS SQL

[Fawcett, David]

In your annotation layer, do you have MINSCALE, MAXSCALE,
MINFEATURESIZE, OR MAXFEATURESIZE in your mapfile layer definition?  



-----Original Message-----
From: UMN MapServer Users List [mailto:MAPSERVER-USERS at LISTS.UMN.EDU] On
Behalf Of mikiet
Sent: Tuesday, February 06, 2007 11:11 AM
To: MAPSERVER-USERS at LISTS.UMN.EDU
Subject: Re: [UMN_MAPSERVER-USERS] Using ODBC/OVF with MS SQL


Hi , further to my previous message, I've done a lot of head scratching
and experimentation and have managed to refine the problem.......

I removed the SrcSQL from my OVF file and replaced it with a SrcLayer

At first I still received no annotations, however when i zoomed in by
changing the map extents my annotations appeared.

I can put this second issue (the annotations only appearing at a zoomed
in
view) down to the performance required to  annotate quite a large number
of point on the map. However my way to get around this was to use the
SrcSQL 
to limit the number of points being brought back. Can anyone tell me if
there is a problem using this with ODBC/OVF as I was not having the
problem using the OVF with my MySQL database...

Cheers
Mike.
-- 
View this message in context:
http://www.nabble.com/Using-ODBC-OVF-with-MS-SQL-tf3181356.html#a8829936
Sent from the Mapserver - User mailing list archive at Nabble.com.