It is currently March 28th, 2024, 5:46 pm

Getting info from MS SQL

Discuss the use of Lua in Script measures.
Post Reply
TrippleT
Posts: 4
Joined: May 28th, 2018, 9:57 pm

Getting info from MS SQL

Post by TrippleT »

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
Post Reply