Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Best way to connect(notify) to an existing Delphi desktop application that will now be deployed on a server

Posted on 2008-10-15
1
Medium Priority
?
419 Views
Last Modified: 2013-11-23
I have an application that connects to an SQL server, gets articles and associated data then creates HTML files. Now I want to use this app on windows server 2008. I am using an ASP.NET application to write and update articles to the SQL server.
Any ideas on how to notify the Desktop app that a new article has been added or updated on the sql server?
Just setting one flag is enough like updateavailable:=true . How would I communicate the state of this flag to the delphi app. TCP? CGI?
thanks
0
Comment
Question by:Alavna
1 Comment
 
LVL 1

Accepted Solution

by:
chgtj001 earned 2000 total points
ID: 22728234
The simplest way is to create a timer in your delphi application, and query the flag in the database every a few minutes. The limitation is that it may delay a few minutes when an update is commited.

Another solution is using Sql server notication service. You can write a .net client if you are using delphi.net.  Here is a tutorial for writing a c# client.
http://9tutorials.com/2007/05/10/implementing-sql-server-2005-query-notifications-in-c-windows-application.html
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Here is a helpful source code for C++ Builder programmers that allows you to manage and manipulate HTML content from C++ code, while also handling HTML events like onclick, onmouseover, ... Some objects defined and used in this source include: …
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
Suggested Courses

782 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question