<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Thanks Stephen, <br><br>I should have included this in my first msg, apologies, but thanks for the reply.<br><br>I'm running GDAL v1.6.1, from<br>ogrinfo --version<br>GDAL 1.6.1, released 2009/05/11<br> <br><br>And, running isql (from unixodbc) also works.<br><br>isql --help<br>unixODBC 2.2.12<br><br>isql -v metp niwatest niwatest<br>libnuma: Warning: /sys not mounted or no numa system. Assuming one node: No such file or directory<br>+---------------------------------------+<br>| Connected!
|<br>| |<br>| sql-statement |<br>| help [tablename] |<br>| quit
|<br>| |<br>+---------------------------------------+<br>SQL> select count(*) from land_station;<br>+-----------------------------------------+<br>| COUNT(*) |<br>+-----------------------------------------+<br>| 8338 |<br>+-----------------------------------------+ <br><br><br>So isql succeeds, and is definately using
ODBC.<br><br>ogrinfo just hangs. Both have the /sys warning msg, which I am ignoring.<br><br><br>I'm still lost with respect to this....<br><br><br>Thanks,<br><br> Brent<br><br><br><br>--- On <b>Mon, 2/21/11, Stephen Woodbridge <i><woodbri@swoodbridge.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Stephen Woodbridge <woodbri@swoodbridge.com><br>Subject: Re: [mapserver-users] OGR VRT ODBC connection problem<br>To: pcreso@pcreso.com<br>Cc: mapserver-users@lists.osgeo.org, gdal-dev@lists.osgeo.org<br>Date: Monday, February 21, 2011, 2:12 PM<br><br><div class="plainMail">Hi Brent,<br><br>I'm certainly not an expert on this, but I think the issue might be that <br>sqlplus does not use an ODBC connection it uses some proprietary Oracle <br>socket protocol to connect.<br><br>Do you have ODBC services setup, configured and running on the Linux <br>host?
How have you verified this?<br><br>If not then this is likely the issue. Sorry I don't use ODBC, so I can't <br>help much more then this.<br><br>-Steve W<br><br>On 2/20/2011 7:12 PM, <a ymailto="mailto:pcreso@pcreso.com" href="/mc/compose?to=pcreso@pcreso.com">pcreso@pcreso.com</a> wrote:<br>><br>> Hi,<br>><br>> Apologies for the cross posting, but I figure there are experts on both<br>> lists.<br>><br>> I'm trying to get a ogr virtual connection working from a Linux host to<br>> a remote Oracle DB to use mapserver for a WFS service providing the<br>> required data..<br>><br>> ODBC is working, eg:<br>><br>> sqlplus user/user@metp <mailto:niwatest/niwatest@metp><br>> select count(*) from land_station;<br>> 8338<br>><br>> etc...<br>><br>> However, when testing with ogr2ogr, I get:<br>><br>> ogrinfo ODBC:user/user@metp land_station<br>><br>> libnuma: Warning: /sys not mounted or no
numa system. Assuming one node:<br>> No such file or directory<br>><br>> and the terminal window hangs, I'm unable to get any response, & have to<br>> kill the connection to continue.<br>><br>><br>> Any suggestions?<br>><br>><br>> Thanks,<br>><br>> Brent Wood<br>><br>><br>><br>><br>><br>><br>> _______________________________________________<br>> mapserver-users mailing list<br>> <a ymailto="mailto:mapserver-users@lists.osgeo.org" href="/mc/compose?to=mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>> <a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br><br></div></blockquote></td></tr></table>