The stuff I posted yesterday seems to have disappeared. Well you won’t get the eloquent wording that I did yesterday again!

Yesterday was spent solving a problem with a COM+ DLL written in VB. (No, I didn’t write it!). I solved a problem with an assumption about date formats that really didn’t hold true for 90% of cases! What is it about dates and computers that programmers don’t get? Maybe it’s only VB programmers, but if you are going to use dates with a SQL database, use ISO format of yyyy-mm-dd hh:mm:ss and nothing will get confused. Display it how you like, but please don’t manipulate it assumming it’ll be in the format dd/mm/yyyy or mm/dd/yyyyy!

The other problem I may have solved is with this COM+ DLL randomly crashing for no apparent reason. Googling showed up a possible cure though. It appears that a MS security fix for an RPC vulnerability breaks the Microsoft Transaction Server…

oops!