Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-18 Thread Eric Wolf
eve that you should use a GDAL/Python wrapper compatible (UNICODE) >> with the Python you have. >> >> By the way, what is the character set of your database? >> >> select * from NLS_DATABASE_PARAMETERS; >> >> There is also the NLS_LANG. NLS_LANG is set as

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-15 Thread Eric Wolf
s also the NLS_LANG. NLS_LANG is set as a local environment variable > on UNIX and is set in the registry on Windows. > > I just following that clue, but can you use ogr.Open() with a local file, > like a shape file? > > Best regards, > > Ivan > > > > > >

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-15 Thread Ivan Lucena
METERS; There is also the NLS_LANG. NLS_LANG is set as a local environment variable on UNIX and is set in the registry on Windows. I just following that clue, but can you use ogr.Open() with a local file, like a shape file? Best regards, Ivan > ---Original Message--- > From:

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-15 Thread Eric Wolf
I'm beginning to think something is wrong at my end. I just installed Python 2.5, GDAL 1.5 and cx_Oracle for Python 2.5. I'm still getting the same behavior. cx_Oracle works, OGR doesn't. Is the clue in my last email? I mean, the Unicode version of cx_Oracle didn't work but the non-Unicode version

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-15 Thread Ivan
Eric, Eric Wolf wrote: I'm running Oracle 11g on the same machine as the Python script. I did test cx_Oracle and found that it wasn't working. I was using the Unicode cx_Oracle 5.0.3. Switching to the non-Unicode cx_Oracle got it working. But OGR is still not connecting. Does OGR rely on cx

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-15 Thread Eric Wolf
I'm running Oracle 11g on the same machine as the Python script. I did test cx_Oracle and found that it wasn't working. I was using the Unicode cx_Oracle 5.0.3. Switching to the non-Unicode cx_Oracle got it working. But OGR is still not connecting. Does OGR rely on cx_Oracle? I think I'll try re

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-14 Thread Peter J Halls
Eric, when you installed the Oracle Client, which options did you install? SQLPlus will install (and work) regardless of whether the OCI libraries are installed - this has given grief to many here who have not read the documentation prior to performing the install! The Oracle tool I have f

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-14 Thread Abhay
On Fri, Feb 12, 2010 at 11:32 PM, Eric Wolf 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

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-12 Thread Eric Wolf
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...@

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-12 Thread Abhay
On Fri, Feb 12, 2010 at 2:48 PM, Eric Wolf 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

Re: [gdal-dev] Oracle OCI connection in Python OGR

2010-02-12 Thread Alan Boudreault
Eric, Could you try a OCI connection string like: "OCI:user/passw...@host/SID" Alan On February 12, 2010 04:18:23 am Eric Wolf 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: > > ogr

[gdal-dev] Oracle OCI connection in Python OGR

2010-02-12 Thread Eric Wolf
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('O