"Wanted" - 10/10

Just came back form the cinema and wondeful experirience watching Wanted with James McAvoy, Morgan Freeman and Angelina Jolie. A must see!

Browser compatible InfoPath form linked to a web service

I had to create an InfoPath form to submit data to a SQL 2005 database and was surprised you can't submit to SQL directly if you run the form from the web browser. Instead you need to write a web service which will link InfoPath form and SQL database.

So I write a simple webservice and create the InfoPath form which I link to this service. Run the form from InfoPath to test it; submit data successfully and checked on the database that the web service done its bit. Published the form to MOSS 2007 so everything done... Not!

I had to:

• In the form options
  - under Compatibility tick "design a form template that can be opened in a browser or InfoPath and enter URL of the MOSS with InfoPath Form Services;
  - under Browser Choose to show toolbars and Submit command;
• In Tools / Data Connection convert the data connection and store it on the same MOSS (link type Relative to site collection);
• In Tools / Submit Options tick "Allow users to submit this form" and set it to send form data to a web service;
• Publish form to the SharePoint server.
• In the SharePoint library on the lib settings go to Advanced Settings and make sure that under Browser-enabled Documents that browser-enabled docs are displayed as a web page.

Now it's done. I think... It works anyway...

Team Fortress 2 - Excellent game

Wish the day had more hours. This and incredible game with stunning visual style. The game has nine well balanced character classes: Spy, Pyro, Soldier, Heavy, Medic, Sniper, Demoman, Scout and Engineer each with different abilities which gives you lots to try and bound to have few favourites. There's also great variety of maps. I can see myself spending many many hours playing this game in the comming months...

Can't submit data direct to SQL Server using browser-compatible InfoPath form

Apparently you need to write a web service that will accept the data on the SQL Server's behalf. Not happy!

Portal song "Still Alive" in the Rock Band

As I was playing Rock Band with my kids last night I was very pleasantly surprised to see "Still alive" as one of the songs in the list of songs. Absolutely brilliant! I've been humming it for a week now and to be able to play it on Rock Band it's a real treat. Well chuffed...

Download and print Lyrics to Still Alive from Gamespot site

Gaming Community

If you are playing XBOX 360 games on-line on XBOX Live you'd have noticed that there are always a lot of people playing most games. But as with most things with "a lot of" there is bound to be one or two uneducated, rude, racist, unfriendly or unsporting people (ussually pre or early teens). It helps a lot if you have a lot of friends in your friends list and that way you know who you're playing with. I was lucky to find some good friends on the o35s.net - Gaming community for the elderly. Check it out regardless of your age; there are lots of members from young teens to their 60s. ;-)

Finally done it! COD4 Mile High Club!

Last night I made my third attempt to get the "Mile High Club" achievement on XBOX 360 and after about 30 mins I done it. Must have died over 100 times on this level alone. In the end got very, very, very... (did I say very?) very pissed with them guys wearing winter hats on the plane and so I shot them all and threw the hostage from the plane. Nice! ;-)

My strategy was:

1. Switch to pistol and run past the guy coming out of the toilet;
2. Shoot the shotgun guy on the left and whiles walking forward flash the end of the corridor;
3. Soon as you flash run and grab the shotgun; If loaded use it to clear this 1st corridor; If not switch to MP5;
4. Run to the next corridor left or right behind the chairs and flash bang towards the middle of the corridor;
5. Run and stay low behind wooden cover on the left and whiles waiting for your two mates load your shotgun;
6. Up the stairs on the right and flash bang through the door on the left and go straight in towards the last corridor whiles unloading your shotgun;
7. Flash the last corridor and grab another 4 flash bangs just before the last corridor whiles reloading or switching your weapon;
8. Flash again down the corridor and go in;
   
9. Don't rush to shut the last terrorist holding the hostage;
10. Aim slightly above his head and shoot! Job done...
    

Installing Visual Studio 2005 Business Intelligence Project templates

I had to change my PC recently. I installed Visual Studio 2005 in my new PC and later on tried to install BIP templates from SQL 2005 Server disk but I wasn't able because SQL install application was detecting as already installed.

Problem solved by removing SQL 2005 form my PC/Control Panel/Add Remove Programs and installing it again from SQL 2005 Server disk.

SharePoint Portal Server 2007 lost the global navigation bar

I thought I might have to do a restore due to a corrupt database when the global navigation bar disappeared from all sites.

In the end the problem was fixed in no time at all after restarting WWW Publishing Service which incidentally was the first service I decided to restart.

Battlefield: Bad Company

Didn't think much of this game but after seeing this trailer I will most probably get it ASAP.

Portal

Played this game for the last 3-4 days and it is brilliant. Short but sweet. Well recommended!