On Fri, Feb 12, 2010 at 11:32 PM, Eric Wolf <ebw...@gmail.com> wrote:
> Thanks for the replies. Sorry I didn't give more details on the > environment. > > I am running on Windows, at the command line, both ogr2ogr and the python > script. > > Created an environment variable for ORACLE_SID=ORCL > > I double-checked my OCI string by using sqlplus to connect: > > sqlplus scott/ti...@orcl > > This works fine. I changed the script to use that in the call to > ogr.Open(). No luck. > > I imported gdal and sprinkled print 'Error:', gdal.GetLastErrorMsg() in my > exception handlers. I got: > > Unable to open Oracle connection None > Error: > > Still no dice. If I take the same script and modify the GetDriverByName and > Open to use a shapefile, it works perfectly. > > -Eric > > > > -=--=---=----=----=---=--=-=--=---=----=---=--=-=- > Eric B. Wolf New! 720-334-7734 > USGS Geographer > Center of Excellence in GIScience > PhD Student > CU-Boulder - Geography > > GPG Public Key: http://www.h4h.net/ebwolf.public.key.txt > > > On Fri, Feb 12, 2010 at 6:56 AM, Abhay <abhay.me...@gmail.com> wrote: > >> >> >> On Fri, Feb 12, 2010 at 2:48 PM, Eric Wolf <ebw...@gmail.com> wrote: >> >>> I'm using GDAL/OGR 1.6.1 with ActivePython 2.6.4-10 and >>> cx_Oracle-5.0.3-11g. I am trying to connect to an Oracle 11g instance. >>> >>> This works: >>> >>> ogr2ogr -f "KML" emp.kml OCI:scott/tiger "EMP" >>> >>> What am I doing wrong. This fails, ds is None: >>> >>> from osgeo import ogr >>> >>> try: >>> d = ogr.GetDriverByName('OCI') >>> except: >>> print "Unable to GetDriverByName" >>> quit() >>> >>> ds = None >>> >>> try: >>> ds = ogr.Open('OCI:scott/tiger') >>> except: >>> print "Unable to open OCI connection" >>> quit() >>> >>> if ds is None: >>> print "Unable to open Oracle connection", ds >>> quit() >>> >>> lyr = ds.GetLayerByName('EMP') >>> number = lyr.GetFeatureCount() >>> >>> print "Features: " + str(number) >>> >>> >>> >>> >>> -=--=---=----=----=---=--=-=--=---=----=---=--=-=- >>> Eric B. Wolf New! 720-334-7734 >>> USGS Geographer >>> Center of Excellence in GIScience >>> PhD Student >>> CU-Boulder - Geography >>> >>> GPG Public Key: http://www.h4h.net/ebwolf.public.key.txt >>> >>> _______________________________________________ >>> gdal-dev mailing list >>> gdal-dev@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/gdal-dev >>> >> >> Hi Eric, >> >> Form your mail it not clear what is cause of the problem. >> >> There 2 scenario here >> >> 1) you are on a remote machine form where your trying to connect oracle >> server machine: >> >> a) Have you installed any Oracle Client in your system. Considering that >> you are using the complete oracle client installation you can use the >> following : >> OCI:scott/tiger@<Tnsname entry for eg. ORCL> >> >> b) if you are trying out with Instant client for 11g you should try either >> of the following >> >> OCI:scott/tiger@//localhost/<your ORACLE SERVICE IDENTIFIER for eg ORCL>. >> >> 2) you are on the oracle server machine where >> >> you must set the oracle SID. like the following >> on windows >> SET ORACLE_SID=ORCL >> or >> on *nix >> export ORACLE_SID=ORCL >> >> then try your implementation or use methods stated in 1) >> >> >> >> >> Rgds. >> >> Abhay. >> > > > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev > Hi Eric, What I still did not get is whether your running Oracle Server 11g on the same machine on which your developing. Also have you tried connecting the same using "cx_Oracle.Connection" whether this connect string is working. Are you using gdal-1.6.1-py2.6-win32.egg install with Python or build your on using SWIG python implementation. Interestingly, what I found is that in gdal-1.6.1-py2.5-win32.egg which install using easy_install seem not work with OCI driver as way it should. But connection string using cx_Oracle is working. So it seem gdal-1.6.1-py*-win32.egg is broken for OCI plugin or probably it must be some setup I must have overlooked will setup, if someone else is working with same setup could help on this or Howard could comment on this. I have build my own egg using latest repo of gdal build and is working. If you need I can share the same egg file (for python 2.6) or wait for Howard to compile for the latest build of GDAL-1.7 for python officially as you would need gdalwin32-17 for this along with OCI build plugin. Rgds. Abhay.
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
