How To Open Connection to Azure Sql Database

[ziwa-msft]

Hi,

I have been trying something like this but it is not working:

require ("luasql.odbc") -- create environment object env =luasql.odbc()

-- connect to data source con = assert (env:connect("DSN=myserver.database.windows.net;Database=master;User Id=name;Password=pw;"))

I just want to test luasql with any one of the drivers (mysql, odbc, etc.) Could you please share a pointer on this?

Thanks, Mike