[gdal-dev] Specify ODBC PATH

[Hector muro]

Hi all,

I have successfully installed gdal (from source) with the MSSQLSpatial
driver in a couple servers (RHEL), but there is one that is resisting and I
think it's got to do with the ODBC installation.

If I do the following, cat /etc/odbcinst.ini

I obtain this:

[PostgreSQL]
Description=ODBC for PostgreSQL
Driver=/usr/lib/psqlodbcw.so
Setup=/usr/lib/libodbcpsqlS.so
Driver64=/usr/lib64/psqlodbcw.so
Setup64=/usr/lib64/libodbcpsqlS.so
FileUsage=1

[MySQL]
Description=ODBC for MySQL
Driver=/usr/lib/libmyodbc5.so
Setup=/usr/lib/libodbcmyS.so
Driver64=/usr/lib64/libmyodbc5.so
Setup64=/usr/lib64/libodbcmyS.so
FileUsage=1

[ODBC Driver 17 for SQL Server]
Description=Microsoft ODBC Driver 17 for SQL Server
Driver=/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1
UsageCount=1

So, using the configure with normal flags, does not configure the
installation for MSSQLSpatial, even adding the flag
"--enable-driver-mssqlspatial".

Then I tried with the following flag:
--with-odbc=/opt/microsoft/msodbcsql17, which made the configuration
prepare for odbc and mssqlspatial, but then, when running "make", I got the
following error:

In file included from cpl_odbc.cpp:32:0:
cpl_odbc.h:39:17: fatal error: sql.h: No such file or directory
 #include <sql.h>
                 ^
compilation terminated.
make[1]: *** [cpl_odbc.lo] Error 1
make: *** [port-target] Error 2

Any ideas about which configuration am I getting wrong to get that error?

Thanks and regards,

Hector
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/gdal-dev/attachments/20200805/725bb9c0/attachment.html>