[gdal-dev] Re: [mapserver-users] OGR VRT ODBC connection problem

[Stephen Woodbridge]

Hi Brent,

I'm certainly not an expert on this, but I think the issue might be that 
sqlplus does not use an ODBC connection it uses some proprietary Oracle 
socket protocol to connect.

Do you have ODBC services setup, configured and running on the Linux 
host? How have you verified this?

If not then this is likely the issue. Sorry I don't use ODBC, so I can't 
help much more then this.

-Steve W

On 2/20/2011 7:12 PM, pcreso at pcreso.com wrote:
>
> Hi,
>
> Apologies for the cross posting, but I figure there are experts on both
> lists.
>
> I'm trying to get a ogr virtual connection working from a Linux host to
> a remote Oracle DB to use mapserver for a WFS service providing the
> required data..
>
> ODBC is working, eg:
>
> sqlplus user/user at metp <mailto:niwatest/niwatest at metp>
> select count(*) from land_station;
> 8338
>
> etc...
>
> However, when testing with ogr2ogr, I get:
>
> ogrinfo ODBC:user/user at metp land_station
>
> libnuma: Warning: /sys not mounted or no numa system. Assuming one node:
> No such file or directory
>
> and the terminal window hangs, I'm unable to get any response, & have to
> kill the connection to continue.
>
>
> Any suggestions?
>
>
> Thanks,
>
> Brent Wood
>
>
>
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users