{"id":99,"date":"2005-03-23T10:09:53","date_gmt":"2005-03-23T15:09:53","guid":{"rendered":"\/?p=99"},"modified":"2005-03-30T09:10:00","modified_gmt":"2005-03-30T14:10:00","slug":"installing-microsoft-sql-ce","status":"publish","type":"post","link":"https:\/\/toddsingleton.net\/chronicle\/2005\/03\/23\/installing-microsoft-sql-ce\/","title":{"rendered":"Installing Microsoft SQL CE"},"content":{"rendered":"

\"ipaq\"\/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.<\/p>\n

My main problem was deducing the prerequisites for the Operating system and IIS.<\/p>\n

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:<\/p>\n

  • If you are installing on a server or workstation running IIS which is NOT<\/u> the Windows 2000 SQL server<\/b> you must download and install the sqlce20sql2ksp3a.exe<\/a> from the Microsoft SQL CE website<\/a>.<\/li>\n
  • If you are installing on a server running both IIS and SQL 2000 server that is already running SQL Service Pack 3<\/b>, you must download and install sqlce20sql2ksp3a.exe<\/a> fom the SQL CE website.<\/li>\n
  • To install on an SQL 2000 server running no SQL Service Pack or Service Pack 1<\/b> download and install setup.exe<\/a> from the SQL CE website.<\/li>\n
  • To install on an SQL 2000 server running SQL Service Pack 2<\/b> download and install setup.exe<\/a> from the SQL CE website.<\/li>\n

    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”.<\/p>\n

    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.<\/b><\/u> 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><\/p>\n

    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.<\/p>\n","protected":false},"excerpt":{"rendered":"

    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 … Continue reading Installing Microsoft SQL CE<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-99","post","type-post","status-publish","format-standard","hentry","category-technology"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t