vb6 executable

I'm new to Visual Basic version 6. I have been asked to create an executable that will select records from a sql2000 table. And based on a datatime field send records via HTTP. This job will be put in the system start task. It needs to check for these records based on a timing factor. The current vb6 has start and stop buttons which requires being logged on and remaining logged on. This job will  be running all the time. Any sugestion? Or even a different source than VB6?
PStiresAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

MichaelHildnerCommented:
If you need the application to run continuously without the user being logged in, you can make your application a Windows Service. VB6 cannot create services. IIRC, there is a tool supplied, but not supported by Microsoft that will allow a VB6 app to run as a service. Sorry, it's been a while since I've looked into that.

Another option would be to use .NET, which can create services, or another language that can do the same.

Regards,
Mike
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jmundsackCommented:
The tool Mike referred to is "srvany" documented here:

http://support.microsoft.com/kb/137890

It is part of the "Windows NT Resource Kit," which is quite old now, but as of Windows XP srvany still works -- I'm not sure how it will fare on Vista.  Download it here:

http://www.microsoft.com/downloads/details.aspx?familyid=9d467a69-57ff-4ae7-96ee-b18c4790cffd&displaylang=en

0
PStiresAuthor Commented:
Thanks Guys,
I will recomend that we write it in .NET. I do not want to use a tool that is not supported.

0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic Classic

From novice to tech pro — start learning today.