[gdal-dev] ogr ODBC problem

[Brent Fraser]

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 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>@lists.osgeo.org*
> Envoyé par : gdal-dev-bounces at lists.osgeo.org
>
> 2012-05-30 17:06
>
> 	
> A
> 	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 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
> http://lists.osgeo.org/mailman/listinfo/gdal-dev
>
>
>
>
> _______________________________________________
> gdal-dev mailing list
> 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/0e6992c7/attachment.html>