[mapserver-users] OGR VRT ODBC connection problem

[pcreso at pcreso.com]

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 <woodbri at swoodbridge.com> wrote:

From: Stephen Woodbridge <woodbri at swoodbridge.com>
Subject: Re: [mapserver-users] OGR VRT ODBC connection problem
To: pcreso at pcreso.com
Cc: mapserver-users at lists.osgeo.org, gdal-dev at 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, 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110220/d180c1ac/attachment.htm>