Installing Microsoft SQL CE

ipaqThis 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:

  • If you are installing on a server or workstation running IIS which is NOT the Windows 2000 SQL server you must download and install the sqlce20sql2ksp3a.exe from the Microsoft SQL CE website.
  • If you are installing on a server running both IIS and SQL 2000 server that is already running SQL Service Pack 3, you must download and install sqlce20sql2ksp3a.exe fom the SQL CE website.
  • To install on an SQL 2000 server running no SQL Service Pack or Service Pack 1 download and install setup.exe from the SQL CE website.
  • To install on an SQL 2000 server running SQL Service Pack 2 download and install setup.exe from the SQL CE website.
  • 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.

    imageAnd 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.

    imageThe 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.

    imageSo 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.

    imageConnor 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

    imageI 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.

    imageI 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.

    Finally, a local bank.

    imageAfter 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

    imageAmy 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 Virgina Declaration of Rights preceded the Bill of Rights after the signing of the Constitution.
  • imageThe 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.
  • Thomas Jefferson attended the College of William and Mary here which still has the oldest building of higher education in North America standing at it’s entrance.
  • imageBasically 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. image

    Instead I took her on a tour of North America’s first insane asylum now called the DeWitt Wallace Public Hospital. Nice accomodations.image

    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.image