This is so wrong it’s funny.
Installing Microsoft SQL CE
This week I learned all about installing Microsoft SQL CE Tools version 2.0 the hard way. I hope this entry makes it easier for someone browsing the Internet for information on this topic since there is very little out there. SQL CE Tools allow for web based communication from a PDA to a Microsoft SQL 2000 database.
My main problem was deducing the prerequisites for the Operating system and IIS.
First, the SQL CE Tools must be loaded on a server (or workstation) running Internet Information Server (IIS). Then you’ll need to know what version of the Tools to install. Here are the rules:
I ran into an unusual, undocumented problem during my installation attempts. The installation would get to a point of copying files and then the dialog box would display “rolling back action” and provide a message stating “Installation Incomplete”.
After a lot of research I determined that because of the MDAC level upgrade that is performed during the install and some of the .net tools that are packaged you cannot load the SQL CE Tools or CE Developer Tools over an RDP Terminal Server connection. You must be in “user /install mode” while logged on to the server locally. This has to do with the TMP and TEMP environment variables when connected with a remote or roaming profile.
I hope this helps anyone looking for information on installing SQL CE Tools. I’m currently using the SQL CE Developer Tools to implement a pretty cool bar code scanning solution using a HP iPAQ hx4700 and a Socket 464 SD card into Prophet 21 Commerce Center. Soon I’ll know more than I ever wanted to about connecting PDA’s to SQL via a C++ application.
How should Terri Schiavo die?
Seems everyone’s asking the wrong question. It’s not if, it’s how.
As a co-worker put it this morning, everything must be AOK in the USA. I suppose the war in Iraq is complete and the budget deficit is taken care of. The argument over social security must be over and oil prices are fine as long as we’re paying more than $2.00 a gallon.
Now that the government has fixed all these “little” problems apparently they have time to concentrate exclusively on Terri Schiavo. It’s important for the government to act quickly to decide who lives and dies. Medical professionals be damned. We don’t want the medical community making medical decisions now do we?
Of course not. We want the courts to decide based on hearsay and a power of attorney agreement. But when the courts rule in favor of the current state laws we want our federal legislators to quickly enact new laws because the current laws don’t suit an immediate cause. Queue the President and the moral right. There’s something to gain here – it adds credibility to “the right to live” which, lucky for them, sounds a lot like “the right to life”.
But what about Terri Schiavo’s implied wishes that she not be left in a vegetative state? Certainly her husband would know if she wanted to be left in this condition. So let’s quickly abide by the state courts decision and once again sentence her to death by starvation. The feeding tubes have been removed. Terry you will wither and die.
But wait – the aforementioned emergency legislation could save you – if indeed you need to be saved. No doctor would want to put the cause of death as dehydration and starvation on a death certificate would he? Well then, do we have a credible case for euthanasia? One beyond the tabloid version of the “right to die” promoted by Dr. Kevorkian?
There’s no way euthanasia would get past the conservative right. Doctors can’t be in the business of putting people to sleep like dogs, even if it is in their best interest. So here is our conundrum in detail. Doctor’s can’t be trusted to make straight-forward medical decisions when there are moral and political issues at stake. Clearly this requires legislation at the federal level???
I was wrong.
This week I came to a reckoning while using my new Canon Elan 7 non-digital SLR. Shooting film is expensive and time consuming. I even went so far as to delete a previous, long-winded post I created about why you should shoot film instead of digital.
Once you go digital it’s hard to go back. So what I’ve got to figure out is how to get the same quality out of a “low cost” digital camera. I can just forget about the frames-per-second that an SLR can achieve. It’s not that important anyway. A hot shoe and a snyc terminal are a must for an off-camera flash and the maximum aperture has got to be at least 2.0 for those times when I don’t want to use a flash at all. It also has to be at least 5 megapixels.
And so the top contenders are: The Sony DSC-V3 (7.2 megapixel) and the The Olympus C-5050 (5 megapixel). The Sony is nice but really expensive. It requires a Sony memory stick or a Compact flash card – neither of which I own. I also don’t own a Compact flash card reader.
The Olympus is less expensive and can only be bought used. But it will accept xD, Smartmedia and Compact flash cards. I already own xD and Smartmedia cards plus the reader connected to my PC. So it seems like a no brainer. The editors of Digital Camera magazine have set the C-5050 as the comparison standard in high-end point and shoots for the past 2 years which gives me even more confidence that this is the camera I need to get – after I sell the Canon.
It’s time to be outside.
So we went to Toys-R-Us and bought Connor a new slide for the backyard. We got the big red one. When the store rep brought the first slide up to the front of the store someone stole it with another purchase that was loaded into their car. How cheap and low can you get, stealing kids toys. We waited 30 minutes for them to bring up another one.
Connor was a little scared of it at first but after he figured out he could drag his feet to slow himself down we couldn’t stop him. Later this afternoon he’s going down head first like he does it on the bigger slides in the park. As you can tell by the photos it’s time for him to get another haircut this week.
36,000 miles
I took this picture of my odometer yesterday when I got in my truck and noticed it was at exactly 36000.0 miles. Makes me feel good about the extended 3-years or 36,000 miles of warranty I purchased. It sounds like I may have to use it for the transmission very soon. I have some kind of metallic rattle going on when the truck’s idling.
I found some images on my Stylus 300 from back in Feb. including the little spread Amy set out for me on Valentines day. She even cooked! The poor Stylus is getting on it’s last leg but I don’t want to buy another digital camera until I can get a digital SLR.
Connor’s Entry
Connor’s got something to tell everyone:
mhj nnnnnnnnnnnnnnnnnnn v v j BN B V
Finally, a local bank.
After seven years I finally switched to a local bank. TD Waterhouse was good to me but recently I ran into a few glitches that made it time to switch. One of those glitches was a 10 day wait for a deposit of $678 to post. Another thing I didn’t like was their on-line banking. When looking at transactions they only say something like: Visa 00562432353543 – $20.00.
That doesn’t tell me anything. Most banks websites convert the transaction to the exact location where the money was spent. Like Starbucks, Target, Exxon etc. including the address. I asked several times why TD Waterhouse didn’t incorporate this over the last couple of years and I never got an answer. Worst of all was I had to mail in deposits because there are no local branches in NC. Oh well, Bank of America has the best on-line banking and the account is completly free. Bye, bye TD Waterhouse.
Williamsburg, VA in February
Amy and I spent last weekend in Williamsburg. It was actually pretty cool because I found out a lot of things about how Virginia played into the revolution. Here’s a couple of interesting things about the area:
The Virginia colonies were the first to declared independence from Britain at the Fifth Virginia convention and told the Virginia delegates to propose total colonial independence before the Continental Congress in Boston.
Basically Virginia always revolted first from the Williamsburg Capital. Therefore they had a large armory where the powder kegs to the right were stored.
Amy wasn’t happy that I didn’t take her on a ride in a horse drawn carriage. 
Instead I took her on a tour of North America’s first insane asylum now called the DeWitt Wallace Public Hospital. Nice accomodations.
That’s when she had me put in the stock for the rest of the day.
So I was right in the middle of Duke of Gloucester St. ready for everyone to throw rotten cabbage at me.
Turns out that one week ago I was right where the revolution really started and tomorrow I’m leaving for Charleston where it all ended.
Backup Exec V9.1
Today I went into grunt mode, I had to upgrade Dillon’s Veritas Backup Exec to Version 9.1 build 4691. I ran into a common problem where all the jobs want to go into a “queued” status instead of running. Seems to be the result of BEDB database corruption as far as I can determine. Hopefully this upgrade will help otherwise I may have to get Veritas involved.
Also, this morning I had to detach and re-attach a production database for our Business Objects reporting website “Infoview”. The drive that the database and it’s corresponding log file sits on were full. I simply did a sp_detach_db in query analyzer, deleted the corresponding log file and reattached the database so that a new, empty log file would be created. Note to self: Remember to rebuild the full text catalog for the Dillon Custom Application any time the Dillon database on DSCSQL1 is detached, otherwise the “filter” in the Telemarketing module will not work. – If I type it, I won’t forget it.
Sorry ’bout the boring techno entry – look for pics of our trip to Williamsburg shortly!