lunarmodules / luasql

LuaSQL is a simple interface from Lua to a DBMS.
http://lunarmodules.github.io/luasql
539 stars 191 forks source link

Support for directly providing ODBC DNS #28

Closed blumf closed 8 years ago

blumf commented 9 years ago

A new way of using the env.connect method, providing a table of options.

In this case, the old method can now be used as: env.connect{ user = "foo", password = "bar", source = "My DB DSN from odbcad32" }

But also, a DSN can be provided: env.connect{ dsn = [[DRIVER={Microsoft Access Driver (.mdb, .accdb)};PWD=bar;DBQ=C:\path\my_db.mdb]] }

blumf commented 8 years ago

See new pull #54 using minimal changeset