[mapserver-users] OGR and MSSQL non-specific error

2012-02-26 Thread Anzel, Phil - NRCS, Fort Collins, CO
All, I'm a bit confused: does MapServer 6.0.1 and OGR officially work with Sql Server 2008? I can see how use of the native SqlGeometry objects might be a bonus and would like to put it to the test. MSSQL access via the plugin works with this LAYER: LAYER NAME 'States' STATUS ON

Re: [mapserver-users] OGR and MSSQL non-specific error

2012-02-26 Thread Tamas Szekeres
Phil, You should not specify the data section in the OGR layer definition unless you would define and sql select statement preceding with the 'where' keyword. The terms 'using unique' and 'using srid' are not meaningful for the ogr driver these parameters are automatically retrieved from the

RE: [mapserver-users] OGR and MSSQL non-specific error

2012-02-26 Thread Anzel, Phil - NRCS, Fort Collins, CO
Hi, Tamas, Thanks for getting back to me so quickly. It works (with a pair of follow-up questions)! Here’s what I used: CONNECTIONTYPE OGR CONNECTION 'MSSQL:server=xxx;database=Navigation;uid=yyy;pwd=zzz’ PROCESSING 'CLOSE_CONNECTION=DEFER' DATA select ShapeGeometry, State_Abbr

[mapserver-users] UTF-8 right to left text

2012-02-26 Thread Ian Walberg
Hello lists, We cannot get all our Arabic text labels to display correctly, it appears that the incorrectly rendered text is not being drawn right to left. Some work and others do not. Our assumption is that there are some non displaying codes we are missing but we do not know enough

Re: [mapserver-users] UTF-8 right to left text

2012-02-26 Thread Rahkonen Jukka
Hi, Did you know that the fresh Spatialite-gui (v. 3.0.1) can import data directly from Excel? -Jukka Rahkonen- Ian Walberg wrote: Steve, Many thanks for getting back to me. We have built with that version of fridibi and do get some text labels

RE: [mapserver-users] UTF-8 right to left text

2012-02-26 Thread Ian Walberg
Jukka, I had seen that and we are hoping to test it this week. Regards Ian -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Rahkonen Jukka Sent: Sunday, February 26, 2012 9:12 PM To: