MSSQL vdf problem

[Eijnden, B. van den (Bart)]

Hi,

you have CONNECTIONTYPE stated twice.

It should be:

 CONNECTIONTYPE OGR
 CONNECTION "default.ovf"

Best regards,
Bart

-----Oorspronkelijk bericht-----
Van: UMN MapServer Users List
[mailto:MAPSERVER-USERS at LISTS.UMN.EDU]Namens Artur Skalski
Verzonden: woensdag 14 december 2005 13:31
Aan: MAPSERVER-USERS at LISTS.UMN.EDU
Onderwerp: [UMN_MAPSERVER-USERS] MSSQL vdf problem


Hi All

I'm trying to display a layer created upon x and y from mssql database.

when I try tu run application, i get following error mesage:
"<!-- PHP Warning: [MapServer Error]: getSymbol(): Parsing error near
(default.ovf):(line 286) in C:\Inetpub\wwwroot\mapserver\framedefs\map.phtml
on line 15 PHP Warning: Failed to open map file default.map in C:
\Inetpub\wwwroot\mapserver\framedefs\map.phtml on line 15 PHP Fatal error:
Call to a member function on a non-object in C:
\Inetpub\wwwroot\mapserver\framedefs\php\default.inc.php on line 868"

I've set up a DSN, it's working
name = pralkajola
user = artur
pass = artur

database name is "str",
table with x y name is "geoxy"

my "default.vfd" file looks like that:

<OGRVRTDataSource>
    <OGRVRTLayer name="geoxy">
        <SrcDataSource>ODBC:pralkajola</SrcDataSource>
 <SrcLayer>geoxy</SrcLayer>
 <GeometryType>wkbPoint</GeometryType>
 <GeometryField encoding="PointFromColumns" x="x" y="y"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

and my map file (default.map) for virtual layer looks like that:
#
LAYER
 NAME "virtual"
 TYPE POINT
 CONNECTIONTYPE OGR
 CONNECTIONTYPE "default.ovf"
 DATA "geoxy"
 STATUS DEFAULT
 CLASS
  SYMBOL 'point'
      SIZE 20
 END
END
#

many thaks for any advice!!!

regards

Artur

Disclaimer
************************************************************************
Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te 
informeren. Wij adviseren u om bij twijfel over de juistheid of de 
volledigheid van de mail contact met afzender op te nemen.

This message shall not constitute any rights or obligations.
This message is intended solely for the addressee.
If you have received this message in error, please delete it and
notify the sender immediately. When in doubt whether this message
is correct or complete, please contact the sender.
************************************************************************