[mapserver-users] mapserver-users Digest, Vol 56, Issue 1

[Chris Jackson]

Apologies all, one last question...
To retrieve attributes from MS SQL I thought something like the following
would work:
 DATA "SitePoint1 from (select SiteID,SitePoint1,SiteName from Site) USING
UNIQUE SiteID USING SRID=4326"
However, the layer fails to draw.  Am I in need of a newer MSSQL2008 driver
or is it a poorly formed query?
Thanks
Chris

On 3 September 2012 20:27, Chris Jackson <webturtles at gmail.com> wrote:

> Fixed it in the end.
>
>  PLUGIN "C:\..\...\msplugin_mssql2008.dll"
>  CONNECTION "server=xxxxx;uid=xxxx;pwd=xxxxxx;database=xxxxx;Integrated
> Security=false"
>
> What is odd is I can only get a geometry type to work, my driver is dated
> Jan-10, maybe pre-geography datatype support - all I can think of.
>
>  DATA "SitePoint1 from Site USING UNIQUE SiteID USING SRID=4326"
>   #DATA "SitePoint (geography)  from Site USING UNIQUE SiteID USING
> SRID=4326" - throws an error about not finding geometry type
>
> Chris
>
> On 3 September 2012 20:00, <mapserver-users-request at lists.osgeo.org>wrote:
>
>> Send mapserver-users mailing list submissions to
>>         mapserver-users at lists.osgeo.org
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>>         http://lists.osgeo.org/mailman/listinfo/mapserver-users
>> or, via email, send a message with subject or body 'help' to
>>         mapserver-users-request at lists.osgeo.org
>>
>> You can reach the person managing the list at
>>         mapserver-users-owner at lists.osgeo.org
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of mapserver-users digest..."
>>
>>
>> Today's Topics:
>>
>>    1. SQL Server 2008 layer (Chris Jackson)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Mon, 3 Sep 2012 15:51:33 +0100
>> From: Chris Jackson <webturtles at gmail.com>
>> To: mapserver-users at lists.osgeo.org
>> Subject: [mapserver-users] SQL Server 2008 layer
>> Message-ID:
>>         <CACU1gf7PSCZ25axKSJwwPCcD-Y=
>> FNB1dht2X-_G_eSEiYGCWDQ at mail.gmail.com>
>> Content-Type: text/plain; charset="iso-8859-1"
>>
>> 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
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120903/84d3118f/attachment-0001.html
>> >
>>
>> ------------------------------
>>
>> _______________________________________________
>> mapserver-users mailing list
>> mapserver-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>>
>>
>> End of mapserver-users Digest, Vol 56, Issue 1
>> **********************************************
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120903/c1c23dc5/attachment.htm>