[gdal-dev] YAML, AppVeyor and the perks of continuous integration (Re: Willing to Pay for Help Building GDAL 3 on WIndows)

[Alan Thomas]

Is there a particular reason why you are building PROJ and SQLite from
scratch? Unless you have a special reason to build these tools (e.g.
custom code), you can download the pre-built binaries (.dll and .lib
files) of these tools from Tamas Szekeres at
http://gisinternals.com/sdk.php. Then, in your gdal/nmake.local file
(you may need to create it if it does not exist), add

# Include PROJ support
# These variables should point to paths in the GIS Internals Development Kit
PROJ_INCLUDE = -I"c:\path\to\release-1xxx-x64\include\proj6"
PROJ_LIBRARY = c:\path\to\release-1xxx-x64\lib\proj_6_0.lib

In particular I highly doubt there is a reason that you need to build
SQLite from scratch...

Alan

On Wed, 29 May 2019 at 11:41, CDelancy
<cdelancy at blackfangtechnologies.com> wrote:
>
> Thank you so much for the explanation, however, I fear it will not help my
> problem.
>
> You see, I cannot build GDAL3 without PROJ4 6.0, and I wouldn't want to
> because important functionality would be missing. However, I cannot build
> PROJ because it depends on SQLite3. I cannot build SQlite3 because there
> appear to be errors in the instructions provided here:
> https://sqlite.org/src/doc/trunk/README.md
>
> "For example:
>
>     mkdir bld
>     cd bld
>     nmake /f Makefile.msc TOP=..\sqlite
>     nmake /f Makefile.msc sqlite3.c TOP=..\sqlite
>     nmake /f Makefile.msc sqlite3.dll TOP=..\sqlite
>     nmake /f Makefile.msc sqlite3.exe TOP=..\sqlite
>     nmake /f Makefile.msc test TOP=..\sqlite"
>
> However, there is no Makefile in the bld directory that was just created, so
> "fatal error U1052: file 'Makefile.msc' not found" results.
>
> If I alter the instructions to cd back into the parent sqlite folder where a
> makefile is located, I get
>
> "        tclsh ..\sqlite\tool\mkopcodec.tcl opcodes.h > opcodes.c
> 'tclsh' is not recognized as an internal or external command,
> operable program or batch file.
> NMAKE : fatal error U1077: 'tclsh' : return code '0x1'
> Stop."
>
> So I Google "tclsh" and now I'm off on in search for a program called
> ActiveTcl. The quest for dependencies has no end in sight.
>
> After installing that program, I return to trying to build sqlite3 with the
> modified command dicuseed previously, the new result is:
>
> "sqlite3.c
> sqlite3.c(19711): error C2065: 'OPFLG_INITIALIZER': undeclared identifier
> sqlite3.c(19711): error C2099: initializer is not a constant
> sqlite3.c(76038): error C2065: 'OP_Init': undeclared identifier
> sqlite3.c(76263): error C2065: 'OP_Goto': undeclared identifier
> sqlite3.c(76270): error C2065: 'OP_String8': undeclared identifier
> sqlite3.c(76292): error C2065: 'OP_Null': undeclared identifier
> sqlite3.c(76292): error C2065: 'OP_String8': undeclared identifier
> sqlite3.c(76294): error C2065: 'OP_Integer': undeclared identifier
> sqlite3.c(76299): error C2065: 'OP_ResultRow': undeclared identifier
> sqlite3.c(76384): error C2065: 'OP_Explain': undeclared identifier
> sqlite3.c(76412): error C2065: 'OP_ParseSchema': undeclared identifier"
>
> Lines like this continue until
>
> "sqlite3.c(85452): fatal error C1003: error count exceeds 100; stopping
> compilation
> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual
> Studio\2017\Community\VC\Tools\MSVC\14.16.27023\bin\HostX86\x86\cl.EXE"' :
> return code '0x2'
> Stop."
>
> So, here I am at a dead end.
>
>
>
> --
> Sent from: http://osgeo-org.1560.x6.nabble.com/GDAL-Dev-f3742093.html
> _______________________________________________
> gdal-dev mailing list
> gdal-dev at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/gdal-dev



-- 
Alan Thomas
Software Developer
ThinkSpatial
http://www.thinkspatial.com.au