LCD Smartie

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?

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?

Hello,

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