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?
LCD Smartie official repo is on github
Download the latest version: https://github.com/LCD-Smartie/LCDSmartie/releases
Download the latest version: https://github.com/LCD-Smartie/LCDSmartie/releases
The forums are safe — thanks to your support!A huge thank-you to all who donated — especially Hydrolisk1792. Your contributions are keeping LCD Smartie alive and glowing!
We're still working to fully fund the hosting cost — if you've found LCD Smartie helpful, please consider supporting us on Ko-fi
(Every bit helps — and we deeply appreciate it!)
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