Re: Help to connect Lua with IBM-DB2 Through LuaSQL

[Scott Morgan <blumf@...>]

On 01/08/14 06:53, T Poojita wrote:
> Dear Users,
> 
> We have been trying to connect with IBM-DB2 through LuaSQL ODBC on Linux
> machine.
> 
> I have edited the config file to make odbc, libodbc* libraries are
> present in the path :
> /usr/lib64/
> While making luasql for odbc, the below error appears:
> src/ls_odbc.c:23:17: error: sql.h: No such file or directory
> src/ls_odbc.c:24:22: error: sqltypes.h: No such file or directory
> src/ls_odbc.c:25:20: error: sqlext.h: No such file or directory
> 
> Also below rpm packages are found installed in my system, should I
> install any special rpm for reaching IBM-DB2 through ODBC ?
> 
> unixODBC-2.2.14-12.el6_3.x86_64


I don't use RPM based systems, or ODBC on Linux, but...

You'll probably need the unixODBC-devel[0] package, which contains the
files to compile against like 'sql.h'

But you'll also need to find a DB2 driver for ODBC to use. UnixODBC will
be able to point you to them (and give support for setting up that side
of things):

http://www.unixodbc.org/

Maybe this:
http://www-03.ibm.com/systems/power/software/i/access/linux.html

Scott

[0]
http://rpmfind.net//linux/RPM/centos/6.5/x86_64/Packages/unixODBC-devel-2.2.14-12.el6_3.x86_64.html