I maked it fast. So there is just a TADOQuery component with the connection string, and your CoInitialize(nil) in ServiceCreate with a call to a timer. The OnTime procedure (of the timer) is writing the DB with the query. And of course a CoUnInitialize() in ServiceDestroy. Nothing else to declare...
Query is simple as that (it's a test with Ms Northwind DB):
var
RegionID: integer;
RegionDescription: string;
begin
RegionID:=5;
RegionDescription:='Green grass & pretty girls !';
With ADOQuery2 do
begin
SQL.Clear...
Hi,
I wrote a server application (with Delphi6) few month ago. When i decided to turn it into an Application Service, there were no trouble at all, except one: it doesn't write on MsSQLServer 2000. I Changed security properties (Windows & SQL Server) on my SQL server. My connection string is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.