Interestingly, the DLLs always end with "30" in all versions. Mar CTP standalone and Mar CTP of VS Orcas: Version 3.5, build. Standalone download of SQL Server Compact Edition 3.1: Version 3.1, build. SQL Server 2005 RTM and SP1: Version 3.0, build. The versions that come with various product versions are: When installed with SQL Server it lives in the C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE directory. There are subdirectories that contain the redistributables for various compact devices and versions of Windows CE. When installed with VS or standalone it lives in the directory C:\Programįiles\Microsoft SQL Server Compact Edition\v3.x. You can program it with the ADO.NET data provider or OLE DB provider. It consists of 6 DLLs, no services, not even an exe. It also ships with Visual Studio, if you install the Compact Framework dev tools. I believe it installs if you install the SQL Server 2005 adminstrative tools, but doesn't show up in Add/Remove Programs. SQLCE ships with SQL Server 2005 and will also ship with the next version of SQL Server (Katmai). For simplicity, I'll refer to all versions as SQLCE from now on. SQL Server Compact Edition's original name was SQL Server Mobile, but as of version 3.1 its now supported on a variety of mobile devices but its also supported on Tablet and Desktop PCs. So I thought I'd write it down as I went along. Although I've taken a cursory glance before this, its my first attempt to put all the pieces into place. If strVersion = '.As part of a project, I've had occasion to look at the SQL Server Compact Edition in earnest. RegQueryStringValue(HKLM, 'SOFTWARE\Microsoft\Microsoft SQL Server Compact Edition\v3.5\ENU', 'DesktopRuntimeServicePackLevel', strServicePack) RegQueryStringValue(HKLM, 'SOFTWARE\Microsoft\Microsoft SQL Server Compact Edition\v3.5\ENU', 'DesktopRuntimeVersion', strVersion) Check if Microsoft SQL Server Compact 3.5 SP2 is installed Source: "Source Files\SSCERuntime_x86-ENU.msi" DestDir: "\SSCERuntime_x86-ENU.msi"" /quiet /norestart" StatusMsg: "Installing Microsoft SQL Server Compact 3.5 SP2." Flags: runhidden Check: not IsMSSQ元5Installed Here is how to include the installer in your Inno Setup package, check for an existing installation and, if required, run the installer silently: Run msiexec.exe /? to obtain the full list of switches. They are just standard MSI files, so you apply the standard Windows Installer switches to msiexec.exe. However, if you need native 64-bit support, you can run the 圆4 package instead. If it's a 32-bit application you will only need to run the SSCERuntime_x86-ENU.msi installation package (even on 圆4 Windows as it will be running in the x86 emulator). Not RegKeyExists(HKLM, 'SOFTWARE\Microsoft\Microsoft SQL Server Compact Edition\v3.5\ENU')Īnd not RegKeyExists(HKLM, 'Wow6432Node\SOFTWARE\Microsoft\Microsoft SQL Server Compact Edition\v3.5\ENU')ĬustomMessage('sqlcompact35sp2_title圆4'),ĬustomMessage('sqlcompact35sp2_size圆4'), Not RegKeyExists(HKLM, 'SOFTWARE\Microsoft\Microsoft SQL Server Compact Edition\v3.5\ENU')) then Sqlcompact35sp2_title圆4=SQL Server Compact 3.5 Service Pack 2 圆4 Sqlcompact35sp2_title=SQL Server Compact 3.5 Service Pack 2 I've modified Modular InnoSetup Dependecy Installer to install Sql Compact DBįile: scripts/products/sqlcompact35sp2.iss You need to extraxt files from e SSCERuntime-ENU.exe and then host SSCERuntime_圆4-ENU.msi and SSCERuntime_x86-ENU.msi by yourself.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |