Can I request a plugin that will connect to a MSSQL server or ODBC source, run a SQL query, and then display the data that's returned?
We've got a helpdesk system at work that uses MSSQL as a backend. It would be great to show how many open incidents there are on the system on an LCD, and other info too.
I'd like to specify the server name, the connection username and password, the SQL query and how often I want to run the query (I'd only need it to run every 10 minutes say.).
Does anyone fancy having a go at making a plugin for this?
Our new official repo is on github
LCD Smartie version 5.6 is released!
Download it now: https://github.com/LCD-Smartie/LCDSmartie/releases
LCD Smartie version 5.6 is released!
Download it now: https://github.com/LCD-Smartie/LCDSmartie/releases
Plugin to get data from SQL database
Moderators: _X7JAY7X_, caesar, IFR, mattcro, limbo
-
fishthecat
- LCD Smartie Fanatic
- Posts: 132
- Joined: March 9th, 2005, 2:21 pm
- Location: UK
-
cosenodefi
- Plugin Author
- Posts: 37
- Joined: December 10th, 2007, 5:40 pm
- Location: Zaragoza (SPAIN)
Re: Plugin to get data from SQL database
Hello,fishthecat wrote:Can I request a plugin that will connect to a MSSQL server or ODBC source, run a SQL query, and then display the data that's returned?
We've got a helpdesk system at work that uses MSSQL as a backend. It would be great to show how many open incidents there are on the system on an LCD, and other info too.
I'd like to specify the server name, the connection username and password, the SQL query and how often I want to run the query (I'd only need it to run every 10 minutes say.).
Does anyone fancy having a go at making a plugin for this?
Recently, I've had a similar need.. and I've developed a plugin to query a MySQL server. I don't use an ODBC approach, but a direct connect one (via DLL).
Bye