Branching Out

Posted by beakersoft | Posted in Uncategorized | Posted on 23-12-2008

0


Me and a couple of the guys i work with a decided to have a good at writing our own software, and making it available online. We are going under the (rather good i think) name of we3soft, and you can get at our website by visiting www.we3soft.com

We have got quite a few ideas/applications in the pipeline, and hope to start working with some of our local businesses on some of there projects. At the mo we have only one application (and its in beta) avaialble for download on the website. It goes by the name of SwitchWatch.

Basiclly, you can use it to tell you what ports in cisco switches have been unused for a period of time you specifically, this will allow you to tidy up the rats next of cables that lives in your comms room. At the moment the application is still in beta, and will only report on the first 5 unused ports per switch. In order to encourage people to test the app, we are giving away 20 free licences once it comes out of beta.

All you have to do to quailfy for a free copy is head over to www.we3soft.com/switchwatch, download the app and tell us what you think about it in our forum. Let us know if it worked fine, if you had any problems with it or if you have any feature requests. If your are in the first 20 to give us your comment we will send you a free licnece key as soon as we come out of beta, so head over there now!!

Report Services Printer Control Problem

Posted by beakersoft | Posted in SQL Reporting Services | Posted on 23-12-2008

0


Not sure how many of you have hit this, but recently we have had a problem with users not being able to print out reports from the browser. When they hit the print icon after runnig a report, they are given the message

Cannot load client print control’

Turns out that one of the patches Microsoft issue out (on a seemingly never ending basis) breaks(well, blocks) the activex. The patch in question is the ActiveX killbit one (i cant remember the kb number), there appears to be a problem with the old version of the print control activex, and when the latest patch is applied to the clients it stops the print control working.

The way to get it working again is basilcly to patch your reports server. This is something i am always a bit cautious of doing, as in the past i have had problems (service pack one removed the ability to do a multi select parameter) but this time i had a virtual server i could snapshot, patch then test.

To get it working again, i installed first of all SQL 2005 service pack 2 (http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en), then the latest hotfix rollup (http://support.microsoft.com/kb/956854). On a couple of the client machines this seemed to fix the problem without having to re-download the control, but on others we had to remove the control first, then re-install it and it worked a treat

Creating a Check for update Routine

Posted by beakersoft | Posted in Programming | Posted on 07-10-2008

1


First off, i apologise for not blogging for a while, ive had quite a few other projects on over the summer, plus holidays so I’ve not really had time. Hopefully now I should be able to get back into it with a bit more frequency.

Anyway on to the topic of this post. Most applications nowadays will automaticly go onto the web and check to see if there is a new version, and if there is offer to download/install/visit page etc. I was looking for a simple way to do this using the dotnet framework and Visual Basic.Net, and came across the System.Net class.

This class is extremely powerful, as it contains functions for network communication.  The main one we will use here is the System.net.WebClient. We are going to use this to pull a file down of our web server that will give us information about the latest version of our application.

Information File

So first of all, create a text file, we are going to look on our web server for this file and read information. In the file we will have the following info: App name, version and download location, delimited by a pipe (|) character. You could also add extra things like new features, release date etc to this file. The example file will look something like this.

1.1.0|TestApp|www.beakersoft.co.uk/downloads/

Once you have this file, save it as something like TestApp_Ver_Control.txt, and upload it to your web server.

Downloading the Version information

Now the file containing version information is on your web server, we can write a function in vb that will open the file up, get the information contained in it and use that information to decided if our application is the latest version or not. This is where the System.net.WebClient comes in. First of declare a couple of variables. One is the WebClient, one is the url of the file you have just uploaded and a string array to hold the details of the file.

Dim myWebClient As New Net.WebClient
Dim RemoteUri As String = "www.beakersoft.co.uk/TestApp_Ver_Control.txt"
Dim strFileInfo()As String

Now, we can go and get the file of the web server, using the webclient and read the contents into a string. Then we can split the content of the string up using the pipe char, and there you have all the info you need to check the version.

All the code is wrapped up in a try/catch block to make sure we dont get any unhandled errors such as when there is no net connection, file missing etc.

	Try
	Dim file As New System.IO.StreamReader( _
                    myWebClient.OpenRead(RemoteUri))
        Dim Contents As String = file.ReadToEnd()

	'Split up the sections of the text based on the pipe (|) delimiator
	strFileInfo = Split(Contents, "|")

	'see if we need a new version
	If strFileInfo(0) > Application.ProductVersion Then
		'if we have a new version, make sure the app name matchs from the file
                If strFileInfo(1) = application.ProductName Then

			'we have a new version! So throw up a message, set a flag ect

                End If
	End If

	'close the file stream and web client
	myWebClient = Nothing
	file.Close()

        Catch ex As Exception
	If InStr(ex.Message, "(404)") Then
		'404 means file not found on webserver
                Msgbox("Problem Finding the update information file - " & vbNewLine & ex.Message & _
                        vbNewLine & "Please contact the appliaction vendor")
	Else
                Msgbox("Problem getting update information - " & vbNewLine & ex.Message & _
                        vbNewLine & "Check your internet settings and try again")
	End If
End Try

And thats pritty much it! This is a very bare bones way of doing it, and you probably want to add in support for using a proxy (you can do that using the System.Net.WebRequest.DefaultWebProxy class, and pass login credentials to myWebClient.Credentials using Net.NetworkCredential ) but as a very basic form this should work.

Spiceworks 3 has Landed

Posted by beakersoft | Posted in spiceworks | Posted on 14-07-2008

2


Spiceworks 3
Hot on the heals of the last version, Spiceworks 3 has been released. You can see a list of the new features at http://spiceworks.com/3.0/ and download it at www.spiceworks.com

Here’s a list of some of the new features that interested me

  • The interface has been cleaned up quite a bit from the previous version. There are also a couple of new features such as the ‘Glide’ function, it’s kind of like the iPod artwork browser.
  • The network scanning has speed has been improved (see my test results below)
  • The detection of devices has been improved.
  • Exchange server monitoring. (i think this is particularity cool)
  • Whole Environment event charts
  • Loads of bug fixes