I have a requirement to run some code on a server. The purpose of the code
is purely to process data between an MS SQL box and a remote Oracle box. It
has no UI, and needs no user intervention to run.
The 2nd part of the requirement is to have a UI that will allow an operator
to view the progress / current status of the processing. Even if the UI is
not loaded, the processing must continue.
I have a few ideas on how to tackle this, but would welcome opinions.
Any ideas most welcome. 8 1434
You could of course run your program as a service for one thing. You may
also want to include messageQueues for instance, so that one of the servers
can be totally down and it won't have an affect on the other machine. It's
a bit vague of a description so i"m hesitant to recommend much more, but if
you let me know i'll be glad to see if I can help.
--
W.G. Ryan, eMVP
Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know! https://www.windowsembeddedeval.com/...ity/newsgroups
"JohnFol" <Wi****@wobble. com> wrote in message
news:OE******** *******@tk2msft ngp13.phx.gbl.. . I have a requirement to run some code on a server. The purpose of the code is purely to process data between an MS SQL box and a remote Oracle box.
It has no UI, and needs no user intervention to run.
The 2nd part of the requirement is to have a UI that will allow an
operator to view the progress / current status of the processing. Even if the UI is not loaded, the processing must continue.
I have a few ideas on how to tackle this, but would welcome opinions.
Any ideas most welcome.
Hi, and thanks for the prompt reply.
My first thought was Windows Service, but I could not find a method of
raising events from it that the form (if open) could respond to.
For example, if within myService I had
Public Event MyHandler(ByVal strSomeData As String)
And then in the form I try and connect to it .. .
Public WithEvents MyServiceEvent As New
ServiceProcess. ServiceControll er("MyServiceNa me")
I can't get the 2 to synch up.
Again, any thoughts welcome.
"William Ryan eMVP" <do********@com cast.nospam.net > wrote in message
news:uB******** ******@TK2MSFTN GP10.phx.gbl... You could of course run your program as a service for one thing. You may also want to include messageQueues for instance, so that one of the
servers can be totally down and it won't have an affect on the other machine.
It's a bit vague of a description so i"m hesitant to recommend much more, but
if you let me know i'll be glad to see if I can help.
--
W.G. Ryan, eMVP
Have an opinion on the effectiveness of Microsoft Embedded newsgroups? Let Microsoft know! https://www.windowsembeddedeval.com/...ity/newsgroups "JohnFol" <Wi****@wobble. com> wrote in message news:OE******** *******@tk2msft ngp13.phx.gbl.. . I have a requirement to run some code on a server. The purpose of the
code is purely to process data between an MS SQL box and a remote Oracle box. It has no UI, and needs no user intervention to run.
The 2nd part of the requirement is to have a UI that will allow an operator to view the progress / current status of the processing. Even if the UI
is not loaded, the processing must continue.
I have a few ideas on how to tackle this, but would welcome opinions.
Any ideas most welcome.
For pure processing of data, I would consider creating a DTS task in SQL
Server. You can partially monitor it, so it may not be choice #1. In SQL
Server 2005, you have more monitoring options.
You can export DTS code to VB and set up a process to figure out where you
are.
With .NET you can make a service that runs these DTS processes. It will have
to use COM interop.
You can also roll your own DTS with a .NET service. The service option is
nice, as you can set up hooks to more easily monitor. The executable hooks
into the service and checks status, et al.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** ***
Think Outside the Box!
*************** *************** *************** ***
"JohnFol" <Wi****@wobble. com> wrote in message
news:OE******** *******@tk2msft ngp13.phx.gbl.. . I have a requirement to run some code on a server. The purpose of the code is purely to process data between an MS SQL box and a remote Oracle box.
It has no UI, and needs no user intervention to run.
The 2nd part of the requirement is to have a UI that will allow an
operator to view the progress / current status of the processing. Even if the UI is not loaded, the processing must continue.
I have a few ideas on how to tackle this, but would welcome opinions.
Any ideas most welcome.
Hi Gregory, and thanks for the suggestions. I think it will be SQL2000, so
it sounds like my monitoring will have to be external to SQL.
A common theme to your reply and Williams' is the concept of interacting
with a service. I've tried the CustomerCommand , but it's a call into the
service and does not return values. Nor can I raise an event from the
service. This would give my UI something to hook into. Looks like I am
missing some key feature of services.
FYI
I aim to create Perfmon entries / counters, but the UI (if running) needs to
list something like the following:
"12 Jan 2004 10:00:03 Processing Order XYZ"
"12 Jan 2004 10:00:04 Order XYZ sucessfully processed"
.. . . you get the gist.
Thanks again for the ideas.
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM> wrote
in message news:uK******** ******@TK2MSFTN GP10.phx.gbl... For pure processing of data, I would consider creating a DTS task in SQL Server. You can partially monitor it, so it may not be choice #1. In SQL Server 2005, you have more monitoring options.
You can export DTS code to VB and set up a process to figure out where you are.
With .NET you can make a service that runs these DTS processes. It will
have to use COM interop.
You can also roll your own DTS with a .NET service. The service option is nice, as you can set up hooks to more easily monitor. The executable hooks into the service and checks status, et al.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "JohnFol" <Wi****@wobble. com> wrote in message news:OE******** *******@tk2msft ngp13.phx.gbl.. . I have a requirement to run some code on a server. The purpose of the
code is purely to process data between an MS SQL box and a remote Oracle box. It has no UI, and needs no user intervention to run.
The 2nd part of the requirement is to have a UI that will allow an operator to view the progress / current status of the processing. Even if the UI
is not loaded, the processing must continue.
I have a few ideas on how to tackle this, but would welcome opinions.
Any ideas most welcome.
John,
I too would recommend a Windows Service.
To enable the service to communicate with the Form, you can use .NET
Remoting, a database Table, a file, or Performance Counters. Depending on
how dynamic/static you want the Form to be.
I find Performance Counters or a database table to be easier, however the
Form then needs to poll for updated data... I would use a Forms.Timer to
pool for the updated progress...
Hope this helps
Jay
"JohnFol" <Wi****@wobble. com> wrote in message
news:uB******** ******@TK2MSFTN GP12.phx.gbl... Hi Gregory, and thanks for the suggestions. I think it will be SQL2000, so it sounds like my monitoring will have to be external to SQL.
A common theme to your reply and Williams' is the concept of interacting with a service. I've tried the CustomerCommand , but it's a call into the service and does not return values. Nor can I raise an event from the service. This would give my UI something to hook into. Looks like I am missing some key feature of services.
FYI I aim to create Perfmon entries / counters, but the UI (if running) needs
to list something like the following:
"12 Jan 2004 10:00:03 Processing Order XYZ" "12 Jan 2004 10:00:04 Order XYZ sucessfully processed"
. . . you get the gist.
Thanks again for the ideas.
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM>
wrote in message news:uK******** ******@TK2MSFTN GP10.phx.gbl... For pure processing of data, I would consider creating a DTS task in SQL Server. You can partially monitor it, so it may not be choice #1. In SQL Server 2005, you have more monitoring options.
You can export DTS code to VB and set up a process to figure out where
you are.
With .NET you can make a service that runs these DTS processes. It will have to use COM interop.
You can also roll your own DTS with a .NET service. The service option
is nice, as you can set up hooks to more easily monitor. The executable
hooks into the service and checks status, et al.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "JohnFol" <Wi****@wobble. com> wrote in message news:OE******** *******@tk2msft ngp13.phx.gbl.. . I have a requirement to run some code on a server. The purpose of the code is purely to process data between an MS SQL box and a remote Oracle
box. It has no UI, and needs no user intervention to run.
The 2nd part of the requirement is to have a UI that will allow an operator to view the progress / current status of the processing. Even if the
UI is not loaded, the processing must continue.
I have a few ideas on how to tackle this, but would welcome opinions.
Any ideas most welcome.
The service can expose certain interfaces that your tool can query, or
continue to query. You can even make the service continually raise events
and subscribe. There are a variety of ways to architect.
--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** ***
Think Outside the Box!
*************** *************** *************** ***
"JohnFol" <Wi****@wobble. com> wrote in message
news:uB******** ******@TK2MSFTN GP12.phx.gbl... Hi Gregory, and thanks for the suggestions. I think it will be SQL2000, so it sounds like my monitoring will have to be external to SQL.
A common theme to your reply and Williams' is the concept of interacting with a service. I've tried the CustomerCommand , but it's a call into the service and does not return values. Nor can I raise an event from the service. This would give my UI something to hook into. Looks like I am missing some key feature of services.
FYI I aim to create Perfmon entries / counters, but the UI (if running) needs
to list something like the following:
"12 Jan 2004 10:00:03 Processing Order XYZ" "12 Jan 2004 10:00:04 Order XYZ sucessfully processed"
. . . you get the gist.
Thanks again for the ideas.
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM>
wrote in message news:uK******** ******@TK2MSFTN GP10.phx.gbl... For pure processing of data, I would consider creating a DTS task in SQL Server. You can partially monitor it, so it may not be choice #1. In SQL Server 2005, you have more monitoring options.
You can export DTS code to VB and set up a process to figure out where
you are.
With .NET you can make a service that runs these DTS processes. It will have to use COM interop.
You can also roll your own DTS with a .NET service. The service option
is nice, as you can set up hooks to more easily monitor. The executable
hooks into the service and checks status, et al.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "JohnFol" <Wi****@wobble. com> wrote in message news:OE******** *******@tk2msft ngp13.phx.gbl.. . I have a requirement to run some code on a server. The purpose of the code is purely to process data between an MS SQL box and a remote Oracle
box. It has no UI, and needs no user intervention to run.
The 2nd part of the requirement is to have a UI that will allow an operator to view the progress / current status of the processing. Even if the
UI is not loaded, the processing must continue.
I have a few ideas on how to tackle this, but would welcome opinions.
Any ideas most welcome.
Hi,
windows service which exposes some methods via remoting. Your monitoring
app will connect to the service, and it can subscribe to events raised
in the service as well.
Sunny
In article <u7************ **@TK2MSFTNGP11 .phx.gbl>, Wi****@wobble.c om
says... Hi, and thanks for the prompt reply.
My first thought was Windows Service, but I could not find a method of raising events from it that the form (if open) could respond to.
For example, if within myService I had
Public Event MyHandler(ByVal strSomeData As String)
And then in the form I try and connect to it .. .
Public WithEvents MyServiceEvent As New ServiceProcess. ServiceControll er("MyServiceNa me")
I can't get the 2 to synch up.
Again, any thoughts welcome. "William Ryan eMVP" <do********@com cast.nospam.net > wrote in message news:uB******** ******@TK2MSFTN GP10.phx.gbl... You could of course run your program as a service for one thing. You may also want to include messageQueues for instance, so that one of the servers can be totally down and it won't have an affect on the other machine. It's a bit vague of a description so i"m hesitant to recommend much more, but if you let me know i'll be glad to see if I can help.
--
W.G. Ryan, eMVP
Have an opinion on the effectiveness of Microsoft Embedded newsgroups? Let Microsoft know! https://www.windowsembeddedeval.com/...ity/newsgroups "JohnFol" <Wi****@wobble. com> wrote in message news:OE******** *******@tk2msft ngp13.phx.gbl.. . I have a requirement to run some code on a server. The purpose of the code is purely to process data between an MS SQL box and a remote Oracle box. It has no UI, and needs no user intervention to run.
The 2nd part of the requirement is to have a UI that will allow an operator to view the progress / current status of the processing. Even if the UI is not loaded, the processing must continue.
I have a few ideas on how to tackle this, but would welcome opinions.
Any ideas most welcome.
Gregory, sound like that has hit the nail on the head. Could you give me a
pointer ?
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM> wrote
in message news:%2******** *******@TK2MSFT NGP10.phx.gbl.. . The service can expose certain interfaces that your tool can query, or continue to query. You can even make the service continually raise events and subscribe. There are a variety of ways to architect.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "JohnFol" <Wi****@wobble. com> wrote in message news:uB******** ******@TK2MSFTN GP12.phx.gbl... Hi Gregory, and thanks for the suggestions. I think it will be SQL2000,
so it sounds like my monitoring will have to be external to SQL.
A common theme to your reply and Williams' is the concept of interacting with a service. I've tried the CustomerCommand , but it's a call into the service and does not return values. Nor can I raise an event from the service. This would give my UI something to hook into. Looks like I am missing some key feature of services.
FYI I aim to create Perfmon entries / counters, but the UI (if running)
needs to list something like the following:
"12 Jan 2004 10:00:03 Processing Order XYZ" "12 Jan 2004 10:00:04 Order XYZ sucessfully processed"
. . . you get the gist.
Thanks again for the ideas.
"Cowboy (Gregory A. Beamer) [MVP]" <No************ @comcast.netNoS pamM> wrote in message news:uK******** ******@TK2MSFTN GP10.phx.gbl... For pure processing of data, I would consider creating a DTS task in
SQL Server. You can partially monitor it, so it may not be choice #1. In
SQL Server 2005, you have more monitoring options.
You can export DTS code to VB and set up a process to figure out where you are.
With .NET you can make a service that runs these DTS processes. It
will have to use COM interop.
You can also roll your own DTS with a .NET service. The service option is nice, as you can set up hooks to more easily monitor. The executable hooks into the service and checks status, et al.
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA
*************** *************** *************** *** Think Outside the Box! *************** *************** *************** *** "JohnFol" <Wi****@wobble. com> wrote in message news:OE******** *******@tk2msft ngp13.phx.gbl.. . > I have a requirement to run some code on a server. The purpose of
the code > is purely to process data between an MS SQL box and a remote Oracle box. It > has no UI, and needs no user intervention to run. > > The 2nd part of the requirement is to have a UI that will allow an operator > to view the progress / current status of the processing. Even if the
UI is > not loaded, the processing must continue. > > I have a few ideas on how to tackle this, but would welcome
opinions. > > Any ideas most welcome. > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Sridhar R |
last post by:
>From technical point of view, I could not understand the the reasoning
behind using Java in major companies. Sure that Python, is used in
some, but still Java is considered as a sure-job language.
After being a python programmer for long time, I consider it painful to
learn/use Java now (well, like many I will be forced to do that in my
job).
What makes such companies to choose Java over dynamic, productive
languages like Python? ...
|
by: jklimek |
last post by:
In May of this year I graduated from Penn State with a BS in IST
(Information Sciences and Technology). Right after graduation I got a
database programming job with a company that uses Delphi 6 and MS SQL
Server 2000.
I've been working with this company for six months now but I'm still
not very good with SQL. I can do basic SQL queries and table joins (as
well as use datetime functions and cursors), but I'd say I'm only at an...
|
by: Peter Foti |
last post by:
Simple question... which is better to use for defining font sizes and why?
px and em seem to be the leading candidates. I know what the general answer
is going to be, but I'm hoping to ultimately get some good real world
examples.
Fire away! :)
Regards,
Peter Foti
|
by: JohnFol |
last post by:
Gregory, sound like that has hit the nail on the head. Could you give me a
pointer ?
"Cowboy (Gregory A. Beamer) " <NoSpamMgbworld@comcast.netNoSpamM> wrote
in message news:%2383pM$RZEHA.228@TK2MSFTNGP10.phx.gbl...
> The service can expose certain interfaces that your tool can query, or
> continue to query. You can even make the service continually raise events
|
by: RichG |
last post by:
We are building a new developement system specifically for .NET developement.
We will bw using VB. and C#.
What will be the best OS to install on the new system.
What will be the best concidering the developed apps will be ran on
everything from Win98 to XP Pro.
What will be the best considering building interactive web apps using ASP.NET
| |
by: Matt Kruse |
last post by:
http://www.JavascriptToolbox.com/bestpractices/
I started writing this up as a guide for some people who were looking for
general tips on how to do things the 'right way' with Javascript. Their code
was littered with document.all and eval, for example, and I wanted to create
a practical list of best practices that they could easily put to use.
The above URL is version 1.0 (draft) that resulted. IMO, it is not a
replacement for the FAQ,...
|
by: Ron |
last post by:
Greetings,
Any recommendations on a book or online tutorial that my 15 yr old son
can use to teach himself C? At 12 he downloaded a crude level editor
for Jedi Knight called JED and taught himself how to make levels.
Awesome ones I might add. So he is bright and a self learner. What
in your opinion would be the best way for him to go? He wants to
learn using his iMac. OS 9.2.2
Thank you.
|
by: M.-A. Lemburg |
last post by:
On 2008-05-08 16:16, Florencio Cano wrote:
The choice of protocol depends a lot on what you want to transfer.
SOAP would be a good choice if you want to send to data to other
servers as well, e.g. Java-based ones.
XML-RPC and JSON are better for simple data structures.
If you have control over both client and server and don't
|
by: Ken North |
last post by:
If you submit the best question for the workshop at LinkedData Planet,
you'll win admission to the conference, including keynotes by W3C
Director Sir Tim Berners-Lee, IBM CTO for Information Management Anant
Jhingran and OpenLink CEO Kingsley Idehen.
Are you applying semantic technologies for web or enterprise
applications? Do you have a problem or question related to RDF, SPARQL,
taxonomies, ontologies or semantic technologies? Do you...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |