Connection to MS SQL Server

Hello!

For some reasons I need to communicate with Microsoft SQL Server in my lua-nginx-module script.

I'd successfully do this stuff using luasql.obdc module (link). So, I decide to use this code in nginx, but without result:

2016/04/27 17:10:17 [error] 12185#0: *1 lua entry thread aborted: runtime error: content_by_lua(nginx.conf:37):2: module 'luasql.odbc' not found: no field package.preload['luasql.odbc'] no file '/usr/share/lua/5.1/odbc/luasql/odbc.lua' no file '/etc/nginx/lualib/luasql/odbc.lua' no file '/etc/nginx/lualib/luasql/odbc/init.lua' no file './luasql/odbc.lua' no file '/etc/nginx/luajit/share/luajit-2.1.0-beta1/luasql/odbc.lua' no file '/usr/local/share/lua/5.1/luasql/odbc.lua' no file '/usr/local/share/lua/5.1/luasql/odbc/init.lua' no file '/etc/nginx/luajit/share/lua/5.1/luasql/odbc.lua' no file '/etc/nginx/luajit/share/lua/5.1/luasql/odbc/init.lua' no file '/etc/nginx/lualib/luasql/odbc.so' no file './luasql/odbc.so' no file '/usr/local/lib/lua/5.1/luasql/odbc.so' no file '/etc/nginx/luajit/lib/lua/5.1/luasql/odbc.so' no file '/usr/local/lib/lua/5.1/loadall.so' no file '/etc/nginx/lualib/luasql.so' no file './luasql.so' no file '/usr/local/lib/lua/5.1/luasql.so' no file '/etc/nginx/luajit/lib/lua/5.1/luasql.so' no file '/usr/local/lib/lua/5.1/loadall.so' stack traceback: coroutine 0: [C]: in function 'require'

I know there is resty.mysql module to work with MySQL, but it is not my variant.

So, do you have any ideas how to implement MS SQL Server support into lua-nginx-module.

Thanks in advance.

Start with the issue's content_by_lua example and the require('luasql.odbc') failure, then compare the mentioned resty.mysql module with the repository's Lua integration points. No repository file or test is identified in the issue; done would require a defined approach for communicating with Microsoft SQL Server from lua-nginx-module.