473,586 Members | 2,495 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Automatic Updates

Are you using an intranet or the internet to push the
updates? If the internet, you probably can't get there
without a web server. If you are using an intranet, you
can do it from a shared folder. Paul Kimmel has a new
book
http://www.amazon.com/exec/obidos/AS...24075/internco
m-20/002-4611773-6304806 that discusses this in depth...
I can send you some code to do it. Effectively you need
two assemblies, one that calls the second, and it looks
to somehwere 'else' to check if the somewhere 'else' on
is newer than the one it wants to use. I've done it on
the intranet at work, and on a scale of 1 to 10, it's
about a 4 the first time through, and much easier
afterward, setting the permissions is the main gotcha.

Let me know which scenario you are using and I can be of
more help.

Good Luck,

Bill

W.G. Ryan
do********@comc ast.nospam.net
www.knowdotnet.com
-----Original Message-----
I am building an application that would check for newest releases on startand if new releases exist, it would update itself. All reference I havefound are using a web server which I don't want to use.

I am doing this in VB.net, and the updates should be stored on SQL Server2000.

Any ideas how can I do this. I have heard something about AutoUpdate class.Would it work with an SQL Server as well?

Any help will be appreciated,
--
Dino Buljubasic
Software Developer
http://rivusglobal.com
.

Jul 19 '05 #1
7 2972
Thanks William,

the update will be done over INTERNET. Since I am quite inexperienced with
this, can you explain to me how to do it please.

My idea is to have somewhere on my server (SQL Server or Web Server) a file
with information about the release (eg. a file with date stamp, version
number, and whatever else is needed).

Then, when my application starts, it will read the file and check if a newer
version has been stored on SQL Server (It has to be SQL Server 2000). If
yes, it will connect to the SQL Server 2000 (if it has access rights),
download vb.net executable file of the newer application which will replace
the old application on clients machine.

The thing is that the executable file of the release has to be protected
from public access, that is why I want to have it on SQL Server 2000 and
only users that have access rights can download it. The access right should
be set using user name and password.

Thank you for your help. I appreciate it very much.

--
Dino Buljubasic
Software Developer
http://rivusglobal.com

"William Ryan" <do********@com cast.nospam.net > wrote in message
news:04******** *************** *****@phx.gbl.. .
Are you using an intranet or the internet to push the
updates? If the internet, you probably can't get there
without a web server. If you are using an intranet, you
can do it from a shared folder. Paul Kimmel has a new
book
http://www.amazon.com/exec/obidos/AS...24075/internco
m-20/002-4611773-6304806 that discusses this in depth...
I can send you some code to do it. Effectively you need
two assemblies, one that calls the second, and it looks
to somehwere 'else' to check if the somewhere 'else' on
is newer than the one it wants to use. I've done it on
the intranet at work, and on a scale of 1 to 10, it's
about a 4 the first time through, and much easier
afterward, setting the permissions is the main gotcha.

Let me know which scenario you are using and I can be of
more help.

Good Luck,

Bill

W.G. Ryan
do********@comc ast.nospam.net
www.knowdotnet.com
-----Original Message-----
I am building an application that would check for newest

releases on start
and if new releases exist, it would update itself. All

reference I have
found are using a web server which I don't want to use.

I am doing this in VB.net, and the updates should be

stored on SQL Server
2000.

Any ideas how can I do this. I have heard something

about AutoUpdate class.
Would it work with an SQL Server as well?

Any help will be appreciated,
--
Dino Buljubasic
Software Developer
http://rivusglobal.com
.

Jul 19 '05 #2
Dino M. Buljubasic <di************ *@rivusglobal.c om> wrote:
the update will be done over INTERNET. Since I am quite inexperienced with
this, can you explain to me how to do it please.

My idea is to have somewhere on my server (SQL Server or Web Server) a file
with information about the release (eg. a file with date stamp, version
number, and whatever else is needed).

Then, when my application starts, it will read the file and check if a newer
version has been stored on SQL Server (It has to be SQL Server 2000). If
yes, it will connect to the SQL Server 2000 (if it has access rights),
download vb.net executable file of the newer application which will replace
the old application on clients machine.

The thing is that the executable file of the release has to be protected
from public access, that is why I want to have it on SQL Server 2000 and
only users that have access rights can download it. The access right should
be set using user name and password.

Thank you for your help. I appreciate it very much.


Is there any reason for not getting the webserver to make the
connection and serve up the file, using the username and password given
by the user? That way you wouldn't have to open up your SQL server to
the outside world. (At least, not for this particular bit of
functionality.)

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet/
If replying to the group, please do not mail me too
Jul 19 '05 #3
Dino M. Buljubasic <di************ *@rivusglobal.c om> wrote:
I am concerned about the security when using web server. That is the main
reason I'd like to use SQL Server 2000 or maybe FTP server (but .NET does
not offer any support for FTP)


Why do you think that putting a SQL server 2000 box or FTP server on
the net is more secure than putting a webserver there?

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet/
If replying to the group, please do not mail me too
Jul 19 '05 #4
I don't know much about security issues but I heard about crawlers and
simmilar software that can get anything from an HTTP Server.

Basically, I am looking for the best solution and since I don't have much of
experience, can you please tell me more about advantages and disadvantages
of web server, sql server and ftp server?

What do you thing is the best way to go for and why giving the requirement I
listed before.

Thank you, any suggestions are welcome.

--
Dino Buljubasic
Software Developer
http://rivusglobal.com

"Jon Skeet" <sk***@pobox.co m> wrote in message
news:MP******** *************** *@news.microsof t.com...
Dino M. Buljubasic <di************ *@rivusglobal.c om> wrote:
I am concerned about the security when using web server. That is the main reason I'd like to use SQL Server 2000 or maybe FTP server (but .NET does not offer any support for FTP)


Why do you think that putting a SQL server 2000 box or FTP server on
the net is more secure than putting a webserver there?

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet/
If replying to the group, please do not mail me too

Jul 19 '05 #5
Dino M. Buljubasic <di************ *@rivusglobal.c om> wrote:
I don't know much about security issues but I heard about crawlers and
simmilar software that can get anything from an HTTP Server.
That's rubbish. If something is password protected, it's password
protected, unless there's a bug in the server - and there can be bugs
in ftp servers and SQL servers just as easily as in web servers.
Basically, I am looking for the best solution and since I don't have much of
experience, can you please tell me more about advantages and disadvantages
of web server, sql server and ftp server?
Well, web servers are generally more commonly on the net than either of
the others, so are likely to have had more things thrown at them over
time. FTP servers would come second in that regard.
What do you thing is the best way to go for and why giving the requirement I
listed before.


I would just go with a web server solution. Putting a database server
up on the net doesn't gain you anything, and opens you up *slightly*
more for denial of service attacks, I suspect.

Given that as you said before, everything is geared towards using a web
server, I'd be looking for some really pretty convincing arguments
against using a web server before considering it - and crawlers being
able to "get anything" *isn't* a convincing argument.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet/
If replying to the group, please do not mail me too
Jul 19 '05 #6
Are you talking about IIS server when you say 'web server'?

I heard that IIS has lots of holes and compatibility issues with .NET.

Also, setting permissions for users can be troublesome. Is that right?
"Jon Skeet" <sk***@pobox.co m> wrote in message
news:MP******** *************** *@news.microsof t.com...
Dino M. Buljubasic <di************ *@rivusglobal.c om> wrote:
I don't know much about security issues but I heard about crawlers and
simmilar software that can get anything from an HTTP Server.


That's rubbish. If something is password protected, it's password
protected, unless there's a bug in the server - and there can be bugs
in ftp servers and SQL servers just as easily as in web servers.
Basically, I am looking for the best solution and since I don't have much of experience, can you please tell me more about advantages and disadvantages of web server, sql server and ftp server?


Well, web servers are generally more commonly on the net than either of
the others, so are likely to have had more things thrown at them over
time. FTP servers would come second in that regard.
What do you thing is the best way to go for and why giving the requirement I listed before.


I would just go with a web server solution. Putting a database server
up on the net doesn't gain you anything, and opens you up *slightly*
more for denial of service attacks, I suspect.

Given that as you said before, everything is geared towards using a web
server, I'd be looking for some really pretty convincing arguments
against using a web server before considering it - and crawlers being
able to "get anything" *isn't* a convincing argument.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet/
If replying to the group, please do not mail me too

Jul 19 '05 #7
Dino M. Buljubasic <di************ *@rivusglobal.c om> wrote:
Are you talking about IIS server when you say 'web server'?
Or Apache.
I heard that IIS has lots of holes and compatibility issues with .NET.
Did you hear about the SQL Slammer worm that went round recently too?
Also, setting permissions for users can be troublesome. Is that right?


Don't know, myself - I haven't administered any IIS boxes personally.
I'm sure it's doable though.

--
Jon Skeet - <sk***@pobox.co m>
http://www.pobox.com/~skeet/
If replying to the group, please do not mail me too
Jul 19 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3112
by: The List Man | last post by:
Crontabs for automatic site updates. Does anyone know how to set up a crontab for automatically updating a webpage on a regular basis. We know how to set these to run perl files, but seem to have an issue as far as comming up with the command to copy one html file to replace another. Any help or simple scripts to do this will be greatly...
6
5469
by: Gert van der Kooij | last post by:
Hi, It's no problem to define the automatic maintenance using the wizard but I want to use commands to automate automation. I captured the SQL statements when activating the maintenance but that didn't help. I couldn't find anything about it in the docs so if anybody could help with this it would be great. Kind regards, Gert
2
3092
by: Ty Moffett | last post by:
Below is a set of insructions that changes the registry keys pertaining to Automatic Updates on my Windows XP box. I can make changes using the control panel applet and see the changes reflected via regedit.exe. However when I make the changes with the code below those changed are NOT reflected in the control panel applet even though they...
1
4032
by: Michel Esber | last post by:
Hello, Linux RedHat AS4 running DB2 V8 FP11. I have followed the docs at http://tinyurl.com/qckrn and enabled automatic statistics collection. It has been 2 days since I updated my DB cfg and I don´t see any activity regarding auto runstats. Also, the field STATS_TIME from syscat.tables shows that all my table statistics were last...
0
1183
by: =?Utf-8?B?VG9kZA==?= | last post by:
I need to be able to set Windows "Automatic Updates" to "Download updates for me, but let me choose when to install them" on my clients computers programmatically. If someone could point me in the right direction I would appreciate it. -- Thanks, Todd Manchester Chronicle Technologies Inc
4
1688
by: =?Utf-8?B?Zmx5ZXJk?= | last post by:
I have win xp home, automatic updates set for auto at 3:00 am. The download and install happens. (Proved by looking on web update history and in windows directory) however the yellow icon w/ the exclamation point shows up in the tray to manually install the same updates. Also most of the last several updates show up several times as...
1
1221
by: =?Utf-8?B?LUdFUC4=?= | last post by:
My wife's machine had to have Windows XP Pro repaired from the original old installation CDs, which seemed to work fine until Automatic Updates revealed it needed 89 critical updates...all of which downloaded, none of which installed after multiple frustrating tries. On Discussion Group exchange someone advised running CHKDSK, which I did...
1
1605
by: =?Utf-8?B?RUVL?= | last post by:
I cannot enable my Automatic Updates. Whenever I enable it, it goes directly to disable. I hve a Windows security Alert constantly in my tool bar. When I click on that, I can't even switch Updates from off to on. Am I infected? I am not an expert with computers, so please help. Thanks.
2
1512
by: raaman rai | last post by:
I have turned up Automatic Updates in my system in it daily updates and ask for restart after successful installation. Today again my system was restarted on its own after the updates but surprisingly i was greeted with the logon screen. Infact i have no password assigned for my system and i have only one system account created when i installed...
0
1129
by: raaman rai | last post by:
This is quite irratiting to find out that my system is enabled with automatic updates and it periodically updates my pc with the latest updates. But recently i encountered network problem once the updates get installed. Then i had to restore my system and it worked but again the updates were left to run as usual. And again i got the same problem...
0
8204
Oralloy
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. ...
0
8220
tracyyun
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...
0
6617
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5712
isladogs
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...
0
5392
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...
0
3838
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3869
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2345
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
0
1184
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.