Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.
New versions and coding, coding...
Posted on 4-Nov-2004 15:38 by M Freitas. | Tags Filed under: Blog.


New versions and coding, coding...
Just got the news that Sprite Software released version 2 of 117151 Sprite Backup for Smartphones. Apparently upgrade from v1 to v2 is free to current users, so I visited their website looking for my download. Found the new version, installed on my Windows Mobile Smartphone and got "The evaluation period for Sprite Backup has completed"... What? Ok, go back to their website - and nowhere there's ANY information about how to get this update. I then opened a support request, which was responded in a couple of hours - well we're an the same timezone, I wouldn't expect less... However, replies to that e-mail are not accepted, I had to go back to their site to update the ticket. Not happy.

An example of good update is from Anton Tomov. He sent an e-mail to all registered users of it very good 52913 Pocket Hack Master program for Pocket PC, including the new key to activate the program. Much better doing like this! His program is a really good overclock utility for Pocket PC.

Also, installed an application other day and didn't like it. After removal I found out that the remove programs routine is not removing an entry from the notification database. Now every time I place the Smartphone in the cradle it comes with a "Can not execute program...". Of course, the program is not there anymore. Should have an easy way of fixing this.

As you know I'm working on migrating the Geekzone database to a more robust platform. I'm in the middle of testing the current code with Microsoft SQL Server 2000. For this I have Virtual PC 2004 SP1 running Windows 2003 Server. On this virtual machine I have IIS and SQL Server. Of course thi is not our production machine.

The site is hosted by Intellihost, an Iconz service, based in Auckland. The guys are good, and work fast when needed. As I found out a couple of times, even during weekends when there's no formal support I still can call their help desk and get some action going on.

Back to this migration stuff... I have been changing lots of the scripts to use Stored Procedures. However I've noticed some weird stuff. For example SELECT * returns all columns on Query Analyzer, but on the ASP script some just come back as nulls! Someone suggested on the SQL newsgroup that I should invoke the columns by name, and move some to the end of the SELECT statement. It worked, after moving some of the columns. Why? Why? Why?

So, after spending a couple of hours on this problem, I'm back on the coding bench. Good stuff is coming out, performance increased at least four times on my test machine!



comments powered by Disqus




Trending now »

Hot discussions in our forums right now:

The President Of The USA - Who do you think?
Created by TimA, last reply by freitasm on 5-Dec-2016 11:04 (898 replies)
Pages... 58 59 60


Christmas. Bah, humbug.
Created by Rikkitic, last reply by alasta on 3-Dec-2016 13:43 (40 replies)
Pages... 2 3


NZ Prime Minister John Key Resigns
Created by ajobbins, last reply by sen8or on 5-Dec-2016 13:35 (18 replies)
Pages... 2


'Quality' NZ news on the way?
Created by Rikkitic, last reply by alasta on 4-Dec-2016 09:49 (91 replies)
Pages... 5 6 7


Spark Ultra Fast Fibre MAX performance and discussion (Some might say Gigabit)
Created by Talkiet, last reply by sbiddle on 3-Dec-2016 21:15 (55 replies)
Pages... 2 3 4


Dishwasher not Working Properly
Created by tdgeek, last reply by ubergeeknz on 5-Dec-2016 13:32 (17 replies)
Pages... 2


Gigabit cable now available
Created by sub, last reply by Scotty1986 on 2-Dec-2016 12:00 (712 replies)
Pages... 46 47 48


Best of both worlds finally - Plex on kodi
Created by davidcole, last reply by reven on 1-Dec-2016 21:00 (15 replies)