Re: [gdal-dev] Absolutely no progress trying to compile GDAL with Oracle support on Windows
Haha amazing! Thanks for your input Tamas. I had all the relevant Oracle and FileGDB pieces installed, and correctly in the path. I just needed to copy ogr_FileGDB.dll from bin\gdal\plugins-external to bin\gdal\plugins and I'm in business. Thanks all for the assistance, especially when it was a matter of reading the docs. I don't see a donate option on the GDAL site but as this is an excellent tool set with great support I'd be happy to contribute. -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Absolutely-no-progress-trying-to-compile-GDAL-with-Oracle-support-on-Windows-tp5018926p5019387.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] Absolutely no progress trying to compile GDAL with Oracle support on Windows
Jukka - Thanks for the suggestion. I have extracted the contents of release-1600-gdal-mapserver.zip (Compiled binaries in a single .zip package ) which seems to include the Oracle plugin (gdal_GEOR.dll and ogr_OCI.dll). However OCI is still not listed in gdalinfo --formats, and running my original ogr2ogr command still fails due to not having the right driver. Is anything special required to enable / load these plugins when using gdal tools? I assume this is the case because I also don't see the FGDB format listed which is also supposed to be included. Thanks again -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Absolutely-no-progress-trying-to-compile-GDAL-with-Oracle-support-on-Windows-tp5018926p5019194.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] Absolutely no progress trying to compile GDAL with Oracle support on Windows
Nicolas - thanks for your input but I have only ever tried to build with the plugin enabled. The OCI format is not listed in gdalinfo. -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Absolutely-no-progress-trying-to-compile-GDAL-with-Oracle-support-on-Windows-tp5018926p5019195.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] Absolutely no progress trying to compile GDAL with Oracle support on Windows
Eli - thanks a bunch for mentioning the .bat file - that got Oracle support working! I really should have seen that, and the read-me in the same directory telling me to run it... I've just got into a routine of getting the binaries, testing with the same commands, and being disappointed. This may be better placed as a separate question, but hopefully it's an easy / quick answer: Whilst Oracle support is working FileGDB is not. gisinternals.com claims ogrinfo --formats includes FileGDB support but I don't seem to have it. I have the FGDB API (version 10.0?) installed and its binaries are included in the path, but for some reason this driver isn't available. Any hints on this last problem would be great. My backup plan is exporting to Shp but I have some field names longer than 10 characters and I don't want to dive into that mess -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Absolutely-no-progress-trying-to-compile-GDAL-with-Oracle-support-on-Windows-tp5018926p5019199.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] ogr2ogr gdalinfo both crashing on 64-bit Windows 7, very little info available
Well thanks for your input Peter, as there is no apparent reason for the crash I've settled for just trying to build gdal from source on Windows. This is presenting its own problems and I am currently headed for a new post in the list... -- View this message in context: http://osgeo-org.1560.n6.nabble.com/ogr2ogr-gdalinfo-both-crashing-on-64-bit-Windows-7-very-little-info-available-tp5018255p5018922.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] Absolutely no progress trying to compile GDAL with Oracle support on Windows
I've started a couple of threads on this forum recently trying to figure out similar problems and currently compiling GDAL 1.9.2 from source on Windows looks like my best option - but STILL I'm getting nowhere. I can't believe how much time this is taking! I've set up my nmake.opt file with everything it needs for OCI: # Add ORACLE support. # Uncomment the following line to enable OCI Oracle Spatial support. ORACLE_HOME = C:\app\mirawan\product\11.2.0 # Uncomment the following if you prefer to build OCI support as a plugin. # OCI_PLUGIN = YES !IFDEF ORACLE_HOME OCI_LIB = $(ORACLE_HOME)\client_1\sdk\lib\msvc\oci.lib OCI_INCLUDE = -I$(ORACLE_HOME)\client_1\sdk\include !ENDIF I've verified several times that the relevant files are where I think they are. I can compile and install with nmake /f makefile.vc and nmake /f makefile.vc install with no trouble. No error messages related to OCI are reported in the build output, even in debug mode (nmake /f makefile.vc DEBUG=1). However when I try to open an OCI data source I just see 'Unable to open datasource ... with the following drivers'. I also tried adding OCI support as a plugin but this was even more frustrating - I followed the steps here http://trac.osgeo.org/gdal/wiki/BuildingOnWindows to compile plugins and nmake ran without any error but apparently nothing changed. TBH I don't even know if I'm looking at the correct plugin - I assume I want georaster for all Oracle support but I can't find any useful documentation on the relationship between georaster and OCI. I am pretty much at the point of putting through my screen in anger. Can anyone give me any idea what's going on here, or a better way of figuring out what the problem might be? Even better - can anyone suggest an automated way of exporting Oracle data to File GeoDatabase that doesn't involve GDAL or FME? Thanks -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Absolutely-no-progress-trying-to-compile-GDAL-with-Oracle-support-on-Windows-tp5018926.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] ogr2ogr gdalinfo both crashing on 64-bit Windows 7, very little info available
Ivan, thanks for the suggestions. The Oracle client is 32 bit, and as you noted GDAL is also 32 bit. The OSGeo4W bin and lib directories are both at the beginning of the path, before the Oracle directories. It might not be relevant but I have an Oracle 11.2 Oracle client talking to a 10.2 instance. I'm trying to avoid compiling GDAL from source on Windows as 1) I'm not familiar enough with the process and 2) I've already lost several hours trying to compile OCI support into a Linux build of GDAL for a separate project and I know how painful this can be. -- View this message in context: http://osgeo-org.1560.n6.nabble.com/ogr2ogr-gdalinfo-both-crashing-on-64-bit-Windows-7-very-little-info-available-tp5018255p5018502.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
Re: [gdal-dev] Problem compiling gdal with OCI support, configure doesn't seem to know where to look
Ethan, Ivan thanks for the suggestions. I am still looking into this but it is a background task. I'll update this thread when I have more results. -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Problem-compiling-gdal-with-OCI-support-configure-doesn-t-seem-to-know-where-to-look-tp5016804p5018254.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] ogr2ogr gdalinfo both crashing on 64-bit Windows 7, very little info available
When I run ogr2ogr or gdalinfo (and maybe other tools, I've never used the others) I always get a crash. I'm using Windows 7 64-bit and gdal 1.9.2. The only information I get from Windows Event Viewer looks like this: ogr2ogr.exe 0.0.0.0 50981d19 ntdll.dll 6.1.7601.17725 4ec49b8f c374 000ce6c3 544 01cdc9024472ef70 c:\OSGeo4W\bin\ogr2ogr.exe c:\Windows\SysWOW64\ntdll.dll 84cba12d-34f5-11e2-8214-002713b231b3 As you can see I'm on a 64-bit system. I assume this is part of the problem somehow. gdalinfo --formats lists some formats and then crashes. I don't know if it crashes before listing all formats or after they're all displayed. ogr2ogr crashes before generating any output. Both commands have been run as both regular user and administrator with no difference. I put c:\OSGeo4W\bin at the beginning of the PATH, and I am executing my command from the 32-bit CMD prompt, but based on the error report I think some part of the process is calling 64-bit ntdll.dll. It might be relevant - I also installed gdal Oracle support. I'm fairly confident this is working as the first time I ran ogr2ogr it complained my TNS entry didn't exist. After I updated the TNS it stopped complaining (then crashed). If I was only seeing crashes in ogr2ogr I'd assume there was an issue with Oracle or my SQL, but gdalinfo is also having problems. This is my ogr2ogr command: ogr2ogr -f CSV c:\users\me\Desktop\test.csv OCI:user/pass@tnsname -sql select id from table Any thoughts or suggestions very much appreciated. I thought maybe I could pass an argument telling the entire process to run as 32-bit but Google isn't giving up the goods. -- View this message in context: http://osgeo-org.1560.n6.nabble.com/ogr2ogr-gdalinfo-both-crashing-on-64-bit-Windows-7-very-little-info-available-tp5018255.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
[gdal-dev] Problem compiling gdal with OCI support, configure doesn't seem to know where to look
First of all sorry for posing a question that has been asked a thousand times before. I did a lot of research but didn't find this specific problem. I have Linux Mint (Ubuntu) with Oracle instant client basic and SDK (11.2) installed from .deb (via Alien). $ORACLE_HOME is set (/usr/lib/oracle/11.2/client) and contains bin, lib, and a symlink to include (/usr/include/oracle/11.2/client). I'm not a total linux n00b but I don't usually compile anything from source. I installed the Oracle software using the instructions here https://help.ubuntu.com/community/Oracle%20Instant%20Client Running 'locate oci.h' shows /home/tom/Downloads/gdal/gdal-1.9.2/ogr/ogrsf_frmts/oci/drv_oci.html /home/tom/Downloads/gdal/gdal-1.9.2/ogr/ogrsf_frmts/oci/ogr_oci.h /usr/include/oracle/11.2/client/oci.h As you can see I'm trying to compile 1.9.2 Stable. No matter what I pass with the ./configure command, config.log always reports configure:22485: checking for Oracle OCI headers in - with nothing after in - as if it doesn't know where the header is supposed to be, and then conftest.cpp:64:29: fatal error: oci.h: No such file or directory These are the arguments I've tried ./configure --with-oci ./configure --with-oci-include='/usr/include/oracle/11.2/client' ./configure --with-oci=/usr/lib/oracle/11.2/client/include ./configure --with-oci=$ORACLE_HOME I even tried copying the contents of /usr/lib/oracle/11.2/client/include to the gdal source directory, but I'm not sure what I thought this would accomplish. Can anyone suggest where I could go next? Any thoughts much appreciated. -- View this message in context: http://osgeo-org.1560.n6.nabble.com/Problem-compiling-gdal-with-OCI-support-configure-doesn-t-seem-to-know-where-to-look-tp5016804.html Sent from the GDAL - Dev mailing list archive at Nabble.com. ___ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev