[mapserver-users] Re: OGR problem connecting to mdb using ovf - SOLVED

[Dejan.Gambin at pula.hr]

I have solved the problem by using System DSN correctly and removing user 
dsn

Thanks very much

regards, dejan

Dejan Gambin/GradPula wrote on 27.01.2009 16:23:16:

> Hi,
> 
> I need to connect to Access database that has (among the other 
> columns) spatial data in two columns named "x coord" and "y coord". 
> I am trying to implement Virtual Spatial Data according to http:
> //www.mapserver.org/input/vector/VirtualSpatialData.html. 
> 
> I have made ovf file like this:
> 
> <OGRVRTDataSource>
>         <OGRVRTLayer name="krk">
>         <SrcDataSource>ODBC:@Krk</SrcDataSource>
>         <SrcLayer>baza</SrcLayer>
>         <GeometryType>wkbPoint</GeometryType>
>         <GeometryField encoding="PointFromColumns" x="x koord" y="y 
koord"/>
>         </OGRVRTLayer>
> </OGRVRTDataSource>
> 
> and map file layer like this (using p.mapper):
> 
> LAYER # kc
>   CONNECTION "krk.ovf"
>   CONNECTIONTYPE OGR
>   NAME  "krk"
>   DATA  "krk"
>   STATUS       ON
>   TYPE         POINT
>   METADATA 
>     "DESCRIPTION" "KC"
>     "LAYER_ENCODING" "WINDOWS-1250"
>   END  # Metadata 
>   CLASS
>     Name 'Kc broj'
>     COLOR 0 0 0
>     SYMBOL 'circle'
>     SIZE 10
>     TEMPLATE void
>   END  # Class
> END
> 
> I have also made use and system dsn connection named "krk".
> 
> Testing with ogrinfo works fine, for example:
> 
> C:\Projekti\GIS\WebGIS\podaci\krk>ogrinfo krk.ovf krk|more
> ERROR 4: Update access not supported for VRT datasources.
> Had to open data source read-only.
> INFO: Open of `krk.ovf'
>       using driver `VRT' successful.
> 
> Layer name: krk
> Geometry: Point
> Feature Count: 2
> Extent: (5000450.000000, 4997536.000000) - (5196390.000000, 
5000300.000000)
> Layer SRS WKT:
> ...
> ...
> 
> But trying to run on web I am getting internal server error: 
> CGI/FastCGI has encountered a problem and needs to close...". Also, 
> my php error log file says:
> 
> [27-Jan-2009 16:21:45] PHP Warning:  [MapServer Error]: 
> msOGRFileOpen(): Open failed for OGR connection `C:
> /Projekti/GIS/WebGIS/podaci/krk/krk.ovf'.
> Unable to initialize ODBC connection to DSN for @Krk,
> [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed
> 
>  in C:\ms4w\apps\pmapper\pmapper-3.2.0\incphp\initgroups.php on line 239
> [27-Jan-2009 16:21:45] PHP Stack trace:
> [27-Jan-2009 16:21:45] PHP   1. {main}() C:
> \ms4w\apps\pmapper\pmapper-3.2.0\map.phtml:0
> [27-Jan-2009 16:21:45] PHP   2. include_once() C:
> \ms4w\apps\pmapper\pmapper-3.2.0\map.phtml:51
> [27-Jan-2009 16:21:45] PHP   3. Init_map->initAllParameters() C:
> \ms4w\apps\pmapper\pmapper-3.2.0\incphp\init\init.php:34
> [27-Jan-2009 16:21:45] PHP   4. Init_map->_initGroups() C:
> \ms4w\apps\pmapper\pmapper-3.2.0\incphp\init\initmap.php:60
> [27-Jan-2009 16:21:45] PHP   5. Init_groups->Init_groups() C:
> \ms4w\apps\pmapper\pmapper-3.2.0\incphp\init\initmap.php:292
> [27-Jan-2009 16:21:45] PHP   6. Init_groups->_createGroups() C:
> \ms4w\apps\pmapper\pmapper-3.2.0\incphp\initgroups.php:48
> [27-Jan-2009 16:21:45] PHP   7. Init_groups->_initResultFields() C:
> \ms4w\apps\pmapper\pmapper-3.2.0\incphp\initgroups.php:117
> [27-Jan-2009 16:21:45] PHP   8. ms_layer_obj->open() C:
> \ms4w\apps\pmapper\pmapper-3.2.0\incphp\initgroups.php:239
> 
> Any help would be greatly appreciated
> 
> Thanks very much
> 
> regards, dejan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20090127/c7dd8e4a/attachment.html