There are some times when I am just plain DUMB. OK. You do not all need to agree with me – I can hear the chorus now of people agreeing with the statement… But I suppose I had better say why I am dumb. I suppose I had better explain…

Last night I got in the new WebService stuff. This is fine and good. This included a new database and a new script. There was a minor problem with this – one of the functions in the script would not work. And I could not work out why. VERY STRANGE. The stored procedure in the database was missing. After a lot of mucking around this morning I found out that the database did not import correctly and I was too dumb to recognise that the big red icon when I tried to import was an error message and not a green icon saying things went well. So, all I need to do is to re-import the data into the database and try again?

Well, YES. That is what I did. But for reasons which I will not explain I imported them into the SQLserver 2005 instead of SQLserver2000 instance. It just sounded like a good idea at the time. Then I imported some vehicle positions and started testing. Brilliant. The positions showed up in my viewing software.

Then I realised one thing about 15 minutes later… I was getting two vehicle positions displayed, but I had only set up one vehicle. What is going on? Hmm. Lets look. Dumb me! When I had imported the database into the 2005 server I gave the database a new name… and the server software was pointing to the old name. D’Oh!