[gdal-dev] RE [Polluriel potentiel] Re: ogr ODBC problem

2012-05-31 Thread Steve . Toutant
Thanks Brent for your answer. But view's primary key? I'm missing something here...What do you mean by that? Do you mean a column with a unique id in the view? There is no such column in my view. Is ogr now needs a unique id in a view? Because it was working before I migrate to linux with a

Re: [gdal-dev] RE [Polluriel potentiel] Re: ogr ODBC problem

2012-05-31 Thread Brent Fraser
Steve, In my case I was getting OGR to get data from a database view, but it could have been a table. I think OGR needs (would like?) to know which column it can use for unque id. I would expect your view (or table) would have a unique key column otherwise relation operations (like

[gdal-dev] RE [Polluriel potentiel] Re: ogr ODBC problem [SOLVED]

2012-05-31 Thread Steve . Toutant
for ogrinfo we were using, as explained here, http://mapserver.org/input/vector/VirtualSpatialData.html#steps-for-display ogrinfo ODBC:User/Pwd@mssql__archives msStatut_station2002_2006 That was working on windows Though, That doesn't work on our linux distro linux sles 11 sp1. It as to be

Re: [gdal-dev] RE [Polluriel potentiel] Re: ogr ODBC problem [SOLVED]

2012-05-31 Thread Brent Fraser
Steve, That's good news. I did run into the spaces problems on Windows (I had a space between the comma and the table name). It caused the connection to fail. Best Regards, Brent Fraser On 5/31/2012 12:14 PM, steve.tout...@inspq.qc.ca wrote: for ogrinfo we were using, as explained