[mapserver-users] MSSQL connection OGR with mapscript

[blackcat18]

Hi every one,

I am trying to get data from database using mapscript. whithout
layer1.status, my output bitmap is blank with a size of 2000*2000.

When I add layer1.status = 1, I get that error :

/An exception of type 'System.ApplicationException' occurred in
mapscript_csharp.dll but was not handled in user code
Additional information: msDrawMap(): Image handling error. Failed to draw
layer named 'GRADIN3'.;msOGRFileOpen(): OGR error. Open failed for OGR
connection in layer `GRADIN3'.
Unable to initialize connection to the server for
MSSQL:server=192.168.***.***//SQLSERVER2008;database=OPF_GEO;uid=***;pwd=***;tables=SFP_Siege_CAD(geom),
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied./

I am connected to to my database with SQL Server Management so the
connection is ok. May be the connection string is not written correctly. How
can I correct it ? 


this is my code:

/          OSGeo.MapServer.mapObj map = new
OSGeo.MapServer.mapObj("C://Users//Sweet live//SkyDrive//Projet
OPENFIELD//MapServer//Programme//WebForm_Map//mapTest.map"); 
            map.setExtent(18118500, 3877472, 18138000, 3892012);
            map.setSize(2000, 2000);
            // Ge the first layer and set a classification attribute
            OSGeo.MapServer.layerObj layer1 = new
OSGeo.MapServer.layerObj(map);
            layer1.name = "GRADIN3";
            layer1.type = OSGeo.MapServer.MS_LAYER_TYPE.MS_LAYER_POLYGON;
            //layer1.status = 1;
            //layer1.debug = 1;
            layer1.connectiontype =
OSGeo.MapServer.MS_CONNECTION_TYPE.MS_OGR;
            layer1.connection =
"MSSQL:server=192.168.***.***//SQLSERVER2008;database=OPF_GEO;uid=***;pwd=***;tables=SFP_Siege_CAD(geom)";
            //layer1.data = "select geom from SFP_Siege_CAD";
            OSGeo.MapServer.classObj classSiege = new
OSGeo.MapServer.classObj(layer1);
            classSiege.name ="geom";
            OSGeo.MapServer.styleObj styleSiege = new
OSGeo.MapServer.styleObj(classSiege);
            styleSiege.color.setRGB(125,125,125);
            classSiege.insertStyle(styleSiege,0);
           // map.save("output.map");
             OSGeo.MapServer.imageObj mapimage = map.draw();
            mapimage.save("map.png", map);/

and the output .map:

/MAP
  EXTENT 18118500 3874992 18138000 3894492
  FONTSET "fonts\fonts.list"
  IMAGETYPE "png"
  NAME "MS"
  SIZE 2000 2000
  STATUS ON
  UNITS METERS

  OUTPUTFORMAT
    NAME "png"
    MIMETYPE "image/png"
    DRIVER "AGG/PNG"
    EXTENSION "png"
    IMAGEMODE RGB
    TRANSPARENT FALSE
  END # OUTPUTFORMAT

  LEGEND
    KEYSIZE 20 10
    KEYSPACING 5 5
    LABEL
      SIZE MEDIUM
      OFFSET 0 0
      SHADOWSIZE 1 1
      TYPE BITMAP
    END # LABEL
    STATUS OFF
  END # LEGEND

  QUERYMAP
    SIZE -1 -1
    STATUS OFF
    STYLE HILITE
  END # QUERYMAP

  SCALEBAR
    IMAGECOLOR 255 255 255
    INTERVALS 4
    LABEL
      SIZE MEDIUM
      OFFSET 0 0
      SHADOWSIZE 1 1
      TYPE BITMAP
    END # LABEL
    SIZE 200 3
    STATUS OFF
    UNITS MILES
  END # SCALEBAR

  WEB
  END # WEB

  LAYER
    CONNECTION
"MSSQL:server=192.168.***.***\SQLSERVER2008;database=OPF_GEO;uid=***;pwd=***;tables=SFP_Siege_CAD(geom)"
    CONNECTIONTYPE OGR
    DEBUG ON
    NAME "GRADIN3"
    STATUS ON
    TILEITEM "location"
    TYPE POLYGON
    UNITS METERS
    CLASS
      NAME "geom"
      STYLE
        ANGLE 0
        COLOR 125 125 125
        OFFSET 0 0
      END # STYLE
      STYLE
        ANGLE 0
        COLOR 125 125 125
        OFFSET 0 0
      END # STYLE
    END # CLASS
  END # LAYER

END # MAP/




--
View this message in context: http://osgeo-org.1560.x6.nabble.com/MSSQL-connection-OGR-with-mapscript-tp5142084.html
Sent from the Mapserver - User mailing list archive at Nabble.com.