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
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
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
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