[Mapserver-users] Mapserver using MSSQL

[Norbert Thieme]

Kalpin Erlangga Silaen schrieb:
> Dear all,
> 
> 1. While I try use ogrinfo I get error like this :
>      D:\openev_fw\bin>ogrinfo layer1.ovf
> FAILURE:
> Unable to open datasource `layer1.ovf' with the following drivers.
>   -> ESRI Shapefile
>   -> UK .NTF
>   -> SDTS
>   -> TIGER
>   -> IHO S-57 (ENC)
>   -> MapInfo File
>   -> DGN
>   -> GML
>   -> AVCBin
>   -> OGDI
> 

Hi,

in your version of OGR ODBC is missing. This version seem not to be 
compiled with ODBC support. So you have to get another version of OGR.

Regards,
Norbert


> D:\openev_fw\bin>
> 
> 2. I am using Mapserver version 4.2 beta2 (ms42b2_gif_pg.zip)
> 
> 3. Yes, I am using System DSN to create ODBC connection.
> 
> I have try change LAYER_1 to another one like KAMPUN_1 and still same error.
> I am still need your help.
> 
> Thank you
> 
> 
> 
> Kalpin Erlangga Silaen
> 
> ----- Original Message ----- 
> From: <bartvde at xs4all.nl>
> To: "Kalpin Erlangga Silaen" <kalpin at solonet.co.id>
> Cc: <mapserver-users at lists.gis.umn.edu>
> Sent: Tuesday, June 01, 2004 5:27 PM
> Subject: Re: [Mapserver-users] Mapserver using MSSQL
> 
> 
> 
>>Hi,
>>
>>1. can ogrinfo read the ovf file successfully?
>>
>>2. which version of Mapserver are you using (try 4.2 beta3 from
>>http://www.maptools.org/php_mapscript/index.phtml?page=downloads.html).
>>
>>3. are you using a System DSN?
>>
>>One thing which is incorrect for sure but I don't know if this is fatal,
>>your <LayerSRS>LAYER_1</LayerSRS>. You can probably use your EPSG code for
>>this.
>>
>>Best regards,
>>Bart
>>
>>
>>>Dear all,
>>>
>>>Today, I am trying run MapServer under windows using MSSQL 2000. I have
>>>read previous thread/mails and try to follow every step but I got error
>>>like below :
>>>
>>>msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_1'.
>>>msOGRFileOpen(): OGR error. Open failed for OGR connection `layer1.ovf'.
>>>File not found or unsupported format.
>>>
>>>My Layer code :
>>>
>>>LAYER
>>>  NAME LAYER_1
>>>  TYPE POLYGON
>>>  STATUS DEFAULT
>>>  CONNECTIONTYPE OGR
>>>  CONNECTION "layer1.ovf"
>>>  DATA "layer1"
>>>  CLASS
>>>    NAME 'My City'
>>>    OUTLINECOLOR 128 128 128
>>>    COLOR 225 225 185
>>>    TEMPLATE "layer1.html"
>>>  END
>>>  HEADER "layer_1_header.html"
>>>  FOOTER "layer_1_footer.html"
>>>  METADATA
>>>    WMS_TITLE "My City"
>>>    WMS_ABSTRACT "Layer Shapefile."
>>>    WMS_SRS "EPSG:26915"
>>>  END
>>>END
>>>
>>>and my layer1.ovf :
>>>
>>><OGRVRTDataSource>
>>>    <OGRVRTLayer name="LAYER_1">
>>>        <SrcDataSource>ODBC:sa/kalpin at mstest</SrcDataSource>
>>>  <SrcLayer>River</SrcLayer>
>>> <GeometryType>wkbPoint</GeometryType>
>>>        <LayerSRS>LAYER_1</LayerSRS>
>>> <GeometryField encoding="PointFromColumns" x="x" y="y"/>
>>>    </OGRVRTLayer>
>>></OGRVRTDataSource>
>>>
>>>
>>>Help me please
>>>
>>>
>>>
>>>Thank you
>>>
>>>
>>>
>>>Kalpin Erlangga Silaen
>>
>>
>>
>>
> 
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> 
>