Hi, there is a good Wiki article on this:
http://en.wikipedia.org/wiki/SQL_Server_Compact MS offer a couple of different flavours of the SQL Server e.g. the above (for mobile and Windows CE) , SQL Server Express (Visual Studio), etc These allow you to use MS SQL without the need for a full blown SQL Server setup and licenses and they have a smaller footprint. I guess it is a move on from MS Access in some ways to allow the development platforms a standard DB interface and the overhead costs. I have even in the past installed ARS on the Express version of SQL Server with no issues (e.g. Laptop - no VM), although I have not tried the later versions. Cheers Carl http://www.missingpiecessoftware.com/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe Martin D'Souza Sent: 03 July 2012 17:24 To: [email protected] Subject: Completely OT: MS SQL Server 'Compact' 3.5 SP1... How does this differ from the regular SQL server? ** I recently purchased an OBD II Reader (for reading onboard diagnostics on my car), and the data link connector for a PC installs a MS SQL Server Compact 3.5 SP1. I had never heard of this product (SQL Server ‘Compact’) until I just had to install both the 32 and 64 bit version of it to support the data link connector for the OBD II reader.. Has anyone had to use this (SQL Server Compact) in the past? How does this differ from the regular SQL server that we use for lets say the AR System?? Joe PS: Since this is no relation with the AR System, please reply to me directly if you will and spare the bandwith on the list. I was tempted to ask the list here only because this tool uses a RDBMS which is a type of the MS-SQL server so some of you might have had to use it with some other non-related tools.. _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
