Clinton

Wednesday 30 November 2011

MS SQL Script Runner

Currently I'm making a script runner using C# WPF in visual studio 2010. It can run many MS-SQL scripts with the click of one button. This is a progress so far screen shot...

Features are :
Drag And Drop script files
Run a directory of script files
Sql Script out put messages during execution
Script passed or failed that are colored green and red (yellow for running)
Stop on error option
Open script on error option
Run report with time taken for each script
Total duration time
Test DB connection
Asynchronus
.Net 4 & tested with SQL 2008
Single exe file

More to come.....

Edit:

This is now complete. If anyone is interested just ask for the exe file. One of the biggest advantages with our script runner is that faster than the DB client library. We are using SMO library for execution, we managed to compile it for .net4. We have a large statement timeout but can abort at any time during the execution.

Saturday 19 November 2011

JoikuSpot - Changing the landing page.

I wanted to change the landing page for joikuspot. I thought people who log onto my phone should have to see something that I want them to see first; almost as a prank. I searched around and came accross the following.
"This shows you where you can change the (URL) for the (landing page) in all versions of JoikuSpot Premium...

The (landing page) variable is found in the language file (IE; English = JoikuSpot_0x20010B5A.r01) that you are using for managing your version of the JoikuSpot Premiuminterface. So if you are using English, you would modify (C:/resource/apps/JoikuSpot_0x20010B5A.r01), if you are using French, you would modify (C:/resource/apps/JoikuSpot_0x20010B5A.r02). This is just to show you where it located so you can modify it to point to whatever url you want to use for your own personallanding page.

It doesn't matter what language file type you are using, you will find the the (URL) to change right before (192.168.0.1)"

To change this value I used a program called SISContents, this allows you navigate through the hidden phone system files. I realised then that the URL address in the file mentioned above had to be the exact same length to keep the file check sum correct. Then for signing I used a program called Markit SIS signer.

This how ever doesn't work! I can't see any other files that can be changed fo the landing page either.
I even tried with joikuspot light which has the redirect page turned on, but no luck, the same old usual landing page.

If anyone has any knowledge aobut this please let me know. It's very specific and i doubt anyone knows?

Friday 11 November 2011

/// 
/// Returns the content of a given web adress as string.
/// 
/// URL of the webpage
/// Website content
public string DownloadWebPage(string Url)
{
    // Open a connection
    HttpWebRequest WebRequestObject = (HttpWebRequest)HttpWebRequest.Create(Url);
 
    // You can also specify additional header values like 
    // the user agent or the referer:
    WebRequestObject.UserAgent = ".NET Framework/2.0";
    WebRequestObject.Referer = "http://www.example.com/";
 
    // Request response:
    WebResponse Response = WebRequestObject.GetResponse();
 
    // Open data stream:
    Stream WebStream = Response.GetResponseStream();
 
    // Create reader object:
    StreamReader Reader = new StreamReader(WebStream);
 
    // Read the entire stream content:
    string PageContent = Reader.ReadToEnd();
 
    // Cleanup
    Reader.Close();
    WebStream.Close();
    Response.Close();
 
    return PageContent;
}

string PageContent = DownloadWebPage("http://www.jonasjohn.de/");

Wednesday 9 November 2011

stupid iPhone 4s

Proud owner of a 4S as of yesterday but trying to add my Gmail account using Exchange is not working at all - I keep getting prompted to enter my password. I know this password is correct as I am logged into my PC.

When I set up my Gmail account using Gmail settings this works fine - thus proving I'm not insane and forgetting my password.

To add weight that this is a bug - my iPad (which is set up as intended) now prompts me for my password for the Gmail account - it has not done this before and has been running iOS5 since the 16th.

The settings match the ones on the iPhone 4 in the house which leaves me to think this is either related to my Gmail account (I don't see how as my Blackberry still lets me get access to my Gmail) or its either a 4s problem or iOS5 problem.

It didn't take long last night to find others having the same problem but I am yet to see any resolution of this and I actually lost sleep trying to think what else it could be.

Very frustrated as this works fine on the 4 in the house and was working on the iPad before initialising on the 4s.