Réf. : Re: Réf. : RE: [mapserver-users] problem with connection to oracle

[youness . elmedraoui]

Hello,

i compiled ogr and i did some test to verify connection to my oracle database:

i run a command ogrinfo oci:user/p...@db and the result is ok: he displayed a list of my tables.

i run a second command : ogrinfo oci:user/p...@db <table_name> and the result is:

 

Layer name: TEST_MAPSERVER.PNT
Geometry: Unknown (any)
Feature Count: 1
Extent: (867840.129169, 325739.403081) - (867840.129169, 325739.403081)
Layer SRS WKT:
PROJCS["NTF (Paris) / Lambert Sud France",
    GEOGCS["NTF (Paris)",
        DATUM["Nouvelle Triangulation Francaise (Paris) (EPSG ID 6807)",
            SPHEROID["Clarke 1880 (IGN) (EPSG ID 7011)",6378249.2,293.4660212936293951]],
        PRIMEM["Paris",2.596921],
        UNIT["grad",0.01570796326794895]],
    PROJECTION["Lambert Sud France (EPSG OP 18093)"],
    UNIT["Meter",1.0]]
Geometry Column = GEOMETRY1
ID: Integer (10.0)
OGRFeature(TEST_MAPSERVER.PNT):0
  ID (Integer) = 1
  POINT (867840.12916935398 325739.40308143501 0)

when i want to test my mapfile with a command shp2img i have an error msg :

C:\MS4W\tools\mapserv>shp2img -m C:\test_mapServ_vb\App_Data\vbmapfileOracle.map -i png -o C:\test_m
apServ_vb\App_Data\temp\testmap.png -all_debug 1
msDrawMap(): Image handling error. Failed to draw layer named 'PNT'. <br>
msOGRFileOpen(): OGR error. Open failed for OGR connection in layer `PNT'.  File not found or unsupported format. <br>

my mapfile :

MAP

NAME "local10g"
SIZE 400 400
STATUS ON
EXTENT 867840 325739 900840 400739
UNITS METERS
CONFIG "MS_ERRORFILE" "/ms4w/ms_error.txt"
DEBUG 2
WEB
  IMAGEPATH "C:\test_mapServ_vb\App_Data\temp"
  IMAGEURL "C:\test_mapServ_vb\App_Data\temp"
END

LAYER
  NAME "PNT"
  STATUS ON
  TYPE POINT
  CONNECTIONTYPE OGR
  CONNECTION "OCI:user/p...@local10g"
  DATA "PNT"
  CLASS
    STYLE
      COLOR 255 235 190
      OUTLINECOLOR 0 0 0
      SYMBOL 0
    END
  END
END

 

END

when i tried with oraclespatial, it's work.

 

someone can help me plz?

Best regards,
Youness ELMEDRAOUI

Les informations figurant sur cet e-mail ont un caractère strictement confidentiel et sont exclusivement adressées au destinataire mentionné ci-dessus.Tout usage, reproduction ou divulgation de cet e-mail est strictement interdit si vous n'en êtes pas le destinataire.Dans ce cas, veuillez nous en avertir immédiatement par la même voie et détruire l'original. Merci

_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users