MSSQL vdf problem

[Skalski Artur - askals]

Many thanks Bart!!!!!

all this time because of this stiupid misstake...

$@^$@#%@#@....

all works now!!!

Artur Skalski


-----Original Message-----
From: Eijnden, B. van den (Bart) [mailto:b.vdeijnden at agi.rws.minvenw.nl]
Sent: Wednesday, December 14, 2005 1:30 PM
To: Skalski Artur - askals; MAPSERVER-USERS at LISTS.UMN.EDU
Subject: RE: [UMN_MAPSERVER-USERS] MSSQL vdf problem


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.
************************************************************************

*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.

If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank you.
*************************************************************************