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 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 (comma instead of space)
ogrinfo ODBC:User/Pwd@mssql__archives,msStatut_station2002_2006
But, For some reasons, this still doesn't work to get the list of
tables on our linux distro
ogrinfo ODBC:User/Pwd@mssql__archives
But it is useless in my case.
Also, our virtual data file looks like this on windows
<OGRVRTDataSource>
<OGRVRTLayer name="stations">
<SrcDataSource>ODBC:User/Pwd@mssql__archives</SrcDataSource>
<SrcLayer>dbo.msStatut_station2002_2006</SrcLayer>
<GeometryType>wkbPoint</GeometryType>
<LayerSRS>WGS84</LayerSRS>
<GeometryField encoding="PointFromColumns" x="Longitude" y="Latitude"/>
</OGRVRTLayer>
</OGRVRTDataSource>
That is working on windows
For our distro linux We need to add the table name
<SrcDataSource>ODBC:User/Pwd@mssql__archives,msStatut_station2002_2006</SrcDataSource>
Perhaps it is not a windows vs linux issue but an OGR version issue.
Thanks for your help
Steve
*Brent Fraser <bfra...@geoanalytic.com>*
2012-05-31 10:49
A
steve.tout...@inspq.qc.ca
cc
gdal-dev@lists.osgeo.org
Objet
[Polluriel potentiel] Re: [gdal-dev] ogr ODBC problem
Steve,
Here's a snippet from a MapServer map file I used to access a
non-spatial MS SQL server via OGR+VRT+ODBC:
TYPE POINT
CONNECTIONTYPE OGR
CONNECTION "<OGRVRTDataSource>
<OGRVRTLayer name='v_MyPoints'>
<SrcDataSource>ODBC:username/password@WebMapDSN,v_MyPoints</SrcDataSource>
<SrcSQL>
SELECT * FROM v_MyPoints
WHERE PropertyID=%PropertyID%
</SrcSQL>
*<FID>PointID</FID>*
<GeometryType>wkbPoint</GeometryType>
<GeometryField encoding='PointFromColumns' y='SurfaceLatitude'
x='SurfaceLongitude'/>
<LayerSRS>NAD83</LayerSRS>
</OGRVRTLayer>
</OGRVRTDataSource>"
PROCESSING "CLOSE_CONNECTION=DEFER"
DATA "v_MyPoints"
In my case I was able to use the view's primary key as the FID. Hope
this helps...
Best Regards,
Brent Fraser
On 5/31/2012 7:48 AM, _steve.tout...@inspq.qc.ca_
<mailto:steve.tout...@inspq.qc.ca>wrote:
Thanks Jeff
I got now OGR_ODBC: Table ?s???s!.????????? has no identified FID column.
I found that several users had this problem but found no solution. I
don't have write access to this MSSQL server.
I'm connecting via ODBC to a non spatial table, but it contains
latitude and longitude information. I will use it to define a
OGRVRTDataSourceand create geometry from point.
Any clue on what I can do?
thanks
steve
*Jeff McKenna **_<jmcke...@gatewaygeomatics.com>_*
<mailto:jmcke...@gatewaygeomatics.com>*@lists.osgeo.org*
Envoyé par : _gdal-dev-bounces@lists.osgeo.org_
<mailto:gdal-dev-boun...@lists.osgeo.org>
2012-05-30 17:06
A
_gdal-dev@lists.osgeo.org_ <mailto:gdal-dev@lists.osgeo.org>
cc
Objet
Re: [gdal-dev] ogr ODBC problem
On 12-05-30 5:09 PM, _steve.tout...@inspq.qc.ca_
<mailto:steve.tout...@inspq.qc.ca>wrote:
>
> Hi!
> I use this command to get the tables from an ODBC connection
> ogrinfo ODBC:User/Pwd@DNS
>
> The connection is succesful but I get this error several times
> ERROR 1: No column definitions found for table '?s???s!.???????????',
> layer not usable.
>
> I used OGR ODBC for several months from a Windows server to a MSSQL
server
> Now I'm migrating to linux and accessing the same MSSQL SERVER and I get
> this error.
>
> Note that if I connect with isql, I can connect and query the database
> without problem.
> So the problem really seems to be with OGR
>
> What can cause this No column definitions found for table error
> And why the table name looks like this '?s???s!.???????????',
Hi Steve,
I was just debugging an ogrinfo command for MS4W/Oracle, and was
reminded of the trick to show more debug info at the commandline:
set CPL_DEBUG=on
I'm going to keep that one in my back pocket from now on.
-jeff
--
Jeff McKenna
MapServer Consulting and Training Services_
__http://www.gatewaygeomatics.com/_
_______________________________________________
gdal-dev mailing list_
__gdal-dev@lists.osgeo.org_ <mailto:gdal-dev@lists.osgeo.org>_
__http://lists.osgeo.org/mailman/listinfo/gdal-dev_
_______________________________________________
gdal-dev mailing list
_gdal-dev@lists.osgeo.org_ <mailto:gdal-dev@lists.osgeo.org>
_http://lists.osgeo.org/mailman/listinfo/gdal-dev_
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/gdal-dev
