[mapserver-users] SQL Server 2008 layer

2012-09-03 Thread Chris Jackson 
Hi all

Sorry for this v.basic question.  Trying to load a layer from SQL 2008 R2
64bit using the msplugin_mssql2008.dll and when running shp2image it just
bombs out on that layer saying neither DSN nor Server keyword supplied.
Two things I can see could be the issue - accessing the plugin itself (any
way to test if that is actually loaded okay?) or that the connection string
is duff.
The SQL instance is the default instance on the same box as the web
application, I have seen various flavours of connections out there,with
different starts to the string and ways to define instance.  Below is what
I went with

  PLUGIN "msplugin_mssql2008.dll"
  CONNECTION
"MSSQL:Server=SERVER1;uid=user1;pwd=qwerty1234;database=name1;Integrated
Security=True"

I have the dll in the data folder for the mapfile (it does live in the
mapfile folder and system32 just in case - hardwiring the path using
c:\...\...\msplugin_mssql2008.dll didn't work either)

I am unsure about the beginning of the connection string and the server
reference (I am using the server name  (as it is a default instance - works
in my web apps)).

Any clues much appreciated

Thanks
Chris
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

Re: [mapserver-users] SQL Server 2008 layer only partially displaying

2011-01-09 Thread Tamas Szekeres 
Milena,

Could you inspect in the SQL Server Profiler what kind of SQL requests are
happening in the subsequent requests?

Best regards,

Tamas



2011/1/10 Milena 

>
> Hi all,
>
> I have been trying to display a WMS layer from a SQL server database. Now,
> I
> managed successfully to connect to the database and some part of the layer
> appeared when Getmap requested but not all the polygons I should be seeing.
> The strange thing is every time I refresh the request different parts of
> the
> layer appear. Does anybody know why this might be? Also if I remove the
> Class from the Layer, nothing is displayed. Map detail below
>
> Thanks!
>
> Milen
>
> MAP
>  NAME Spatial
>  IMAGECOLOR 0 255 255
>  SIZE 600 800
>  IMAGETYPE png
>  PROJECTION
>   "init=epsg:4326" #latlon on WGS84
>  END
>  EXTENT 100.00 -35.00 129.00 -11.00
>  # lon/lat extents of WA tenements
>  WEB
>IMAGEPATH "/tmp/ms_tmp/"
>IMAGEURL "/ms_tmp/"
>METADATA
>  "map" "C:/ms4w/apps/Spatial/config.map"
>  "ows_schemas_location" "http://schemas.opengeospatial.net";
>  "ows_title" "Sample WMS"
>  "ows_abstract" "Sample WMS of Spatial"
>  "ows_keywordlist" "Spatial,WMS,Maxwell"
>  "ows_onlineresource"
> "http://localhost:8080//spatial?map=C:/ms4w/apps/Spatial/config.map&";
>  "wms_srs" "EPSG:4326" #latlon
>  "wms_feature_info_mime_type" "text/plain"
>  "wms_feature_info_mime_type" "text/html"
>  "wms_server_version" "1.1.1"
>  "wms_formatlist" "image/png,image/gif,image/jpeg"
>  "wms_format" "image/gif"
>END #metadata
>  END #web
>  LAYER
>  NAME "tenements"
>  CONNECTIONTYPE PLUGIN
>  PLUGIN "C:/ms4w/Apache/specialplugins/msplugin_mssql2008.dll"
>
>  CONNECTION "Server=.\SQL_2008;Database=LeaseCDemo2008GIS;Integrated
> Security=true"
>
>  DATA "geom from dbo.WA_Tenements USING UNIQUE ID USING SRID=0"
>  TYPE POLYGON
>
>  STATUS DEFAULT
>
>  METADATA
>  "ows_title" "tenements"
>  END #metadata
>  PROJECTION
> "init=epsg:4326"
>  END
>  EXTENT 100.00 -35.00 129.000 -11.
>  TOLERANCE 0
>  MAXSCALE 1
>  CLASS
>NAME  "tenements"
>STYLE
>COLOR 255 235 190
>OUTLINECOLOR  0 0 0
>END #style
>
>  END #class
>  END #Layer
> End #Map
>
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/SQL-Server-2008-layer-only-partially-displaying-tp5905621p5905621.html
> Sent from the Mapserver - User mailing list archive at Nabble.com.
> ___
> mapserver-users mailing list
> mapserver-users@lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] SQL Server 2008 layer only partially displaying

2011-01-09 Thread Milena 

Hi all,

I have been trying to display a WMS layer from a SQL server database. Now, I
managed successfully to connect to the database and some part of the layer
appeared when Getmap requested but not all the polygons I should be seeing.
The strange thing is every time I refresh the request different parts of the
layer appear. Does anybody know why this might be? Also if I remove the
Class from the Layer, nothing is displayed. Map detail below

Thanks!

Milen

MAP 
  NAME Spatial 
  IMAGECOLOR 0 255 255 
  SIZE 600 800
  IMAGETYPE png 
  PROJECTION 
   "init=epsg:4326" #latlon on WGS84 
  END 
  EXTENT 100.00 -35.00 129.00 -11.00
  # lon/lat extents of WA tenements
  WEB 
IMAGEPATH "/tmp/ms_tmp/" 
IMAGEURL "/ms_tmp/" 
METADATA 
  "map" "C:/ms4w/apps/Spatial/config.map" 
  "ows_schemas_location" "http://schemas.opengeospatial.net"; 
  "ows_title" "Sample WMS" 
  "ows_abstract" "Sample WMS of Spatial" 
  "ows_keywordlist" "Spatial,WMS,Maxwell" 
  "ows_onlineresource"
"http://localhost:8080//spatial?map=C:/ms4w/apps/Spatial/config.map&"; 
  "wms_srs" "EPSG:4326" #latlon   
  "wms_feature_info_mime_type" "text/plain" 
  "wms_feature_info_mime_type" "text/html" 
  "wms_server_version" "1.1.1" 
  "wms_formatlist" "image/png,image/gif,image/jpeg" 
  "wms_format" "image/gif" 
END #metadata 
  END #web 
  LAYER
  NAME "tenements"
  CONNECTIONTYPE PLUGIN
  PLUGIN "C:/ms4w/Apache/specialplugins/msplugin_mssql2008.dll"

  CONNECTION "Server=.\SQL_2008;Database=LeaseCDemo2008GIS;Integrated
Security=true"

  DATA "geom from dbo.WA_Tenements USING UNIQUE ID USING SRID=0"
  TYPE POLYGON

  STATUS DEFAULT

  METADATA 
  "ows_title" "tenements" 
  END #metadata 
  PROJECTION 
 "init=epsg:4326" 
  END
  EXTENT 100.00 -35.00 129.000 -11.
  TOLERANCE 0
  MAXSCALE 1
  CLASS
NAME  "tenements"
STYLE
COLOR 255 235 190
OUTLINECOLOR  0 0 0
END #style

  END #class
  END #Layer
End #Map
  
-- 
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/SQL-Server-2008-layer-only-partially-displaying-tp5905621p5905621.html
Sent from the Mapserver - User mailing list archive at Nabble.com.
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

[mapserver-users] SQL Server 2008 layer C# MapScript query help

2010-01-21 Thread Willem Swanepoel 
Hi,
I'm just starting out with MapServer / MapScript C#.

I get "Attempted to read or write protected memory" when trying to retrieve
the shape of the selection in a SQL Server layer. Code snippet below
(adapted from example code):

if (layer.queryByPoint(Map, point, mapscript.MS_SINGLE, tolerance) ==
(int)MS_RETURN_VALUE.MS_SUCCESS)   {
resultCacheObj result = layer.getResults();
if (result.numresults > 0)
{   int shapeInd =
result.getResult(0).shapeindex;
layer.open();
shapeObj shape = layer.getFeature(shapeInd, -1);
<<--Attempted to read or write protected memory

string txt = "";

for (int i = 0; i < shape.numvalues;i++)// layer.numitems; i++)
{
   txt += ""+ layer.getItem(i) +": ";
txt += " " + shape.getValue(i) +
"";
}  etc.



Additional notes:
* the tolerance > 0
* IIS 5
* using latest build (MSVC2008 (Win32) -stable
release-1500-gdal-1-6-mapserver-5-6.zip) DLLs (including
msplugin_mssql2008.dll)
* VS 2008 project
* the SQL Server layer geometry is points & draws without problems
* code works for other layers in may map

Additional issue:
When doing a queryByShape on the SQL Server layer and try drawQuery on the
map I get "Image handling error. Failed to draw layer..."

Am doing something wrong - is this the correct way of going about querying &
visualizing? Is what I trying to do possible with SQL Server layers?
Any help/pointers appreciated.

Thanks
Will
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users