I'm currently writing an application that I'd really like to be an NT service application. It needs to update one table in a database with relevant information from another table, every now and again.
Basically, how do I use the TSQLConnection and TSQLQuery components within a service application.
I can connect to the DB (I think), but running a Query brings up an error message.
Does anyone know how to do this?
(High points cos I really wanna do this.)