Getting info from MS SQL

Discuss the use of Lua in Script measures.

Getting info from MS SQL

June 6th, 2018, 11:51 pm
TrippleT
   [4 posts]

Hi,

Have anyone success with connecting to MS SQL database? I think the issue is with Lua, the information for MSSQL is quite rare. it also doesn't help when Lua doesn't report any error. I am using MS SQL Server 2014, have Management Studio and can open the database using Windows Authentication

function getCurrency()
local dbuser="user"
local dbpass="password"
local dbserver="(local)\\DatabaseSource"
local dbname="databaseName"
local connectionString = "Provider=SQLOLEDB; Initial Catalog ="..dbname..";Data Source ="..dbserver.."; User ID="..dbuser.."; Password = "..dbpass.."
database.open(connectionString)
rs = database.query("SELECT * FROM dbo.CURRENCY")
database.close()
-- get the data out of rs
end

Return to “Lua Scripting”



Who is online

Users browsing this forum: No registered users and 2 guests