[MS4W-Users] Oracle Unable to open datasource

Simon Mercier smercier at mapgears.com
Wed May 30 13:18:40 EST 2012


Hi list

I try to connect "ogrinfo" and Oracle in my ms4w install directory and it
don't work?  I still don't find out what's going on :-(

1) I use a the last ms4w 3.0.6 build.

2) I download the Oracle Instantclient 11.2.03 and set ORACLE_HOME.  If I
try to connect via sqlplus, everything work fine (I also try with a
tnsnames.ora and work fine to)

C:\..\ms4w306>sqlplus dt/dr2011 at LC/GEOSID

SQL*Plus: Release 11.2.0.3.0 Production on Wed May 30 10:46:15 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options

SQL>

3) But for ogrinfo it just don't work.  I moved the ogr_OCI.dll from
ignored path to /ms4w306/gdalplugins and set all Environment variables. A
formats option show that OCI driver is support:


C:\..\ms4w306>ogrinfo --formats
Supported Formats:
  -> "OCI" (read/write)
  -> "ESRI Shapefile" (read/write)
  -> "MapInfo File" (read/write)
  -> "UK .NTF" (readonly)
  ...

C:\..\ms4w306>ogrinfo OCI:dt/dr2011 at LC/GEOSID
ERROR 1:  in <unnamed>
FAILURE:
Unable to open datasource `OCI:dt/dr2011 at LC/GEOSID' with the following
driver
s.
  -> OCI
  -> ESRI Shapefile
  -> MapInfo File
  -> UK .NTF
  -> SDTS
  ...

4) Same problem with mapserv and shp2img in my ms4w install dir.  Where
should I look now to make it run ?

thank's


---
Simon Mercier
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/ms4w-users/attachments/20120530/803dd65c/attachment.htm 


More information about the MS4W-Users mailing list