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

Thu May 31 11:28:23 PDT 2012

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.Toutant at 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 at 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 at 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 at 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 at 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 at 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 <bfraser at geoanalytic.com>*
>
> 2012-05-31 10:49
>
> 	
> A
> 	Steve.Toutant at inspq.qc.ca
> cc
> 	gdal-dev at 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 at 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.Toutant at inspq.qc.ca_ 
> <mailto:Steve.Toutant at 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 **_<jmckenna at gatewaygeomatics.com>_* 
> <mailto:jmckenna at gatewaygeomatics.com>*@lists.osgeo.org*
> Envoyé par : _gdal-dev-bounces at lists.osgeo.org_ 
> <mailto:gdal-dev-bounces at lists.osgeo.org>
>
> 2012-05-30 17:06
>
> 	
> A
> 	_gdal-dev at lists.osgeo.org_ <mailto:gdal-dev at lists.osgeo.org>
> cc
> 	
> Objet
> 	Re: [gdal-dev] ogr ODBC problem
>
>
>
>
> 	
>
>
>
>
>
>
>
>
> On 12-05-30 5:09 PM, _Steve.Toutant at inspq.qc.ca_ 
> <mailto:Steve.Toutant at inspq.qc.ca>wrote:
> >
> > Hi!
> > I use this command to get the tables from an ODBC connection
> > ogrinfo ODBC:User/Pwd at 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 at lists.osgeo.org_ <mailto:gdal-dev at lists.osgeo.org>_
> __http://lists.osgeo.org/mailman/listinfo/gdal-dev_
>
>
>
> _______________________________________________
> gdal-dev mailing list
> _gdal-dev at lists.osgeo.org_ <mailto:gdal-dev at lists.osgeo.org>
> _http://lists.osgeo.org/mailman/listinfo/gdal-dev_
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20120531/f7d46597/attachment.html>