Connection to MS SQL Server

[ArhiChief]

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.

[agentzh]

@ArhiChief Your error means that nginx cannot find your luasql.odbc module, which means you did not confiugre lua_package_path and/or lua_package_cpath directives properly. A deeper issue is that LuaSQL will always block the nginx event loop and ruin the performance. It should be prohibited in the OpenRestry environment.

I'm not sure about the ODBC protocol details. Wondering if it's feasible to write a lua-resty-odbc library in a similar way to lua-resty-mysql. It seems to me that ODBC is an API standard instead of a wire protocol for communications. You are welcome to contribute here.

[antonheryanto]

@ArhiChief in order to connect to Microsoft SQL Server using cosocket we need to implementation the TDS protocol such as https://github.com/pekim/tedious nodejs library which implemented tds protocol. i have plan to create tds protocol for cosocket to connect to mssql but didn't have time and chance yet

[alyoshark]

Hi @antonheryanto I was wondering if building the library on top of freetds is a feasible solution, or does that inevitably block just like lua odbc. I'm thinking of writing one recently too but TDS protocol looks to have more connection details than the one used in MySQL.

[tomodutch]

Has there been any progress on this? I found this issue because I also have a requirement to connect with an mssql database.

[nevian427]

Any info on this please?

[oawang]

mark

[mark-perfect]

mark