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

x
?
Solved

Executing a vb aplication in a windows 2003 server

Posted on 2006-06-27
16
Medium Priority
?
358 Views
Last Modified: 2010-04-07
I have done an aplication in vb6 which check a folder in the server every 10 minutes and if it finds any zip file (these files are sent by a web users) it unzip the files, extract the access databases inside, send the records to a sql server and delete all the files (zip and mdb)
This aplication uses common vb tools as (timers, textboxes, filelistboxes...). I have installed on the server and works fine when i open a remote session.
But if i close the session it does not work. I have included a programmed task which call the aplication when the server is turning on, i can see the aplication is running but id does nothing.
Any solution? Thanks
0
Comment
Question by:aplimedia
  • 4
  • 4
  • 2
  • +2
16 Comments
 
LVL 13

Expert Comment

by:jmundsack
ID: 16991790
Rather than have the program running constantly and checking a folder every 10 minutes, why not have it launched every 10 minutes via scheduled task (this will be a pain to set up, because you'll have to put in a new task for every 10-minutes, since each task can only run once a day).  Scheduled tasks will run on the server even if there is no interactive user.
0
 
LVL 5

Expert Comment

by:NAORC
ID: 16991914
For scheduling software, use dazzling events instead.  it works like windows scheduled tasks but allows the options of scheduling stuff to run once, or every x seconds, minutes, hours, days, weeks, months, or years.
0
 
LVL 13

Expert Comment

by:jmundsack
ID: 16992014
Can you post a URL for "dazzling events" please?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 10

Author Comment

by:aplimedia
ID: 16992347
Thanks, I will change the code to use Scheduled tasks but my problem is that the aplication does not run on the server if there is no interactive user. I forgot to say I am using a VPN with Windows 2003, virtuozzo software (I don´t know if this changes something)
0
 
LVL 9

Accepted Solution

by:
justchat_1 earned 1200 total points
ID: 16995399
It can be done with windows task scheduler...
click properties for the task...then schedule...then advanced and click repeat task :)

As far as the problem:
have your program debug to a file so you can see what is happening...
0
 
LVL 13

Expert Comment

by:jmundsack
ID: 16995760
Wow, that is great info, justchat_1...  Thank you!
0
 
LVL 5

Expert Comment

by:NAORC
ID: 17009382
http://www.dazzlingsoftware.com/Downloads/DazzlingEvents.htm

^^It makes windows scheduling look like a kids toy.^^
0
 
LVL 9

Expert Comment

by:justchat_1
ID: 17015675
Any luck on the debug?
0
 
LVL 1

Assisted Solution

by:tguez
tguez earned 800 total points
ID: 17040055
Check the options in the windows task sechuler, there is an opton to tell the task manager to run the program even if there is no session.   Just drill down through the options.

Also, if click on the advanced tab for the repeat, you can tell it to run every 10 minutes, for the next 24 hours.  So you will not need to enter an entry for every them minutes like the user wrote above.  It will start on a certain day, and run every 10 minutes, for 24 hours.  This will essentially mean that the software will be run every 10 minutes.

Tomer
0
 
LVL 13

Expert Comment

by:jmundsack
ID: 17041231
Aplimedia--

justchat_1's message 06/27/2006 01:57PM EST offered the task scheduler advanced solution before tguez, to whom you gave the points.

Just wondered if you noticed that.

Jon
0
 
LVL 10

Author Comment

by:aplimedia
ID: 17060955
@Netminder and jmundsack (And justchat_1 )

Having read over the answers once again, in the coolness of day, I do see clearly how justchat_1  did also suggest the task manager soltution. However, in the heat of the moment the solution suggested by tguez seemed better worded and his explain around the issue made the solution work for me. Sorry, i hate it when this happens to me too. I will be more carefull in the furture.

Aplimedia
0
 
LVL 10

Author Comment

by:aplimedia
ID: 17061422
Yes please Netminder... and apologies to everyone.

Aplimedia
0
 
LVL 10

Author Comment

by:aplimedia
ID: 17061606
Many thanks to all.

Aplimedia
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Suggested Courses

971 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