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

[Steve.Toutant at inspq.qc.ca]

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 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 OGRVRTDataSource and 
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/e8e48d83/attachment-0001.html>