Thanks Stephen, I should have included this in my first msg, apologies, but thanks for the reply.
I'm running GDAL v1.6.1, from ogrinfo --version GDAL 1.6.1, released 2009/05/11 And, running isql (from unixodbc) also works. isql --help unixODBC 2.2.12 isql -v metp niwatest niwatest libnuma: Warning: /sys not mounted or no numa system. Assuming one node: No such file or directory +---------------------------------------+ | Connected! | | | | sql-statement | | help [tablename] | | quit | | | +---------------------------------------+ SQL> select count(*) from land_station; +-----------------------------------------+ | COUNT(*) | +-----------------------------------------+ | 8338 | +-----------------------------------------+ So isql succeeds, and is definately using ODBC. ogrinfo just hangs. Both have the /sys warning msg, which I am ignoring. I'm still lost with respect to this.... Thanks, Brent --- On Mon, 2/21/11, Stephen Woodbridge <wood...@swoodbridge.com> wrote: From: Stephen Woodbridge <wood...@swoodbridge.com> Subject: Re: [mapserver-users] OGR VRT ODBC connection problem To: pcr...@pcreso.com Cc: mapserver-us...@lists.osgeo.org, gdal-dev@lists.osgeo.org Date: Monday, February 21, 2011, 2:12 PM 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, pcr...@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@metp <mailto:niwatest/niwatest@metp> > select count(*) from land_station; > 8338 > > etc... > > However, when testing with ogr2ogr, I get: > > ogrinfo ODBC:user/user@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-us...@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
