Home Database Mysql Tutorial 在台式机上安装SQL Server Compact Edition

在台式机上安装SQL Server Compact Edition

Jun 07, 2016 pm 03:12 PM
compact ed server sql Install

Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) 是 Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile) 的下一版本。SQL Server Compact Edition 可用于 台式 机,不需要 安装 Visual Studio 2005 或 SQL Server 2005

  Microsoft SQL Server 2005 Compact Edition (SQL Server Compact Edition) 是 Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile) 的下一版本。SQL Server Compact Edition 可用于台式机,不需要安装 Visual Studio 2005 或 SQL Server 2005。适用于台式Tablet PC 的 SQL Server Compact Edition 安装程序 (SQLServerEv31-EN.msi) 中包含仅适用于台式机和 Tablet PC 计算机的运行时二进制文件。安装程序包含以下库:

  SQLCESE30.DLL

  SQLCEQP30.DLL

  SQLCEME30.DLL

  SQLCEOLEDB30.DLL(OLEDB 数据访问接口)

  SQLCECA30.DLL

  SQLCECOMPACT30.DLL

  SQLCEER30xx.DLL

  System.Data.SqlServerCe.dll(ADO.NET 数据访问接口)

  适用于台式机和 Tablet PC 的 SQL Server Compact Edition 安装程序发行版不包括用于在移动设备或 SQL Server Compact Edition 服务器工具(也称为连接组件)上安装 SQL Server Compact Edition 的 CAB 文件。

  安装要求

  除非正在使用 OLEDB 数据访问接口,否则必须安装 Microsoft .NET Framework 2.0 或更高版本才能安装 SQL Server Compact Edition。可以从 .NET Framework 2.0 下载中心下载 .NET Framework 2.0。

  由于此安装程序只包含运行时二进制文件,所以,在台式机和 Tablet PC 计算机上安装 SQL Server Compact Edition 时,不需要使用以下软件:

  Internet 信息服务 (IIS) 5.x 或更高版本的 IIS(仅适用于 32 位)

  ActiveSync 4.0 或更高版本

  Internet Explorer 6.0

  当在台式机和 Tablet PC 计算机上安装 SQL Server Compact Edition 时,不需要使用 Visual Studio 和 SQL Server。

  重要事项:

  若要在 SQL Server 和 SQL Server Compact Edition 之间复制数据,必须安装复制组件。有关安装 SQL Server 复制组件的详细信息,请参阅硬件和软件要求。还必须安装服务器工具 (Sqlce30setupen.msi)。有关服务器工具的详细信息,请参阅 Connectivity Tools(连接工具)。

  安装位置

  适用于台式机和 Tablet PC 计算机的 SQL Server Compact Edition 安装程序可在固定位置安装 SQL Server Compact Edition。固定位置安装为 SQL Server Compact Edition 提供了可服务性支持。SQL Server Compact Edition 安装程序将在全局程序集缓存 (GAC) 中安装托管程序集,如 System.Data.SqlServerCe.dll,并在注册表中注册本机 DLL,如 OLE DB 访问接口 (sqlceoledb30.dll)。由于安装了注册表,因此用户只能利用管理凭据安装 SQL Server Compact Edition。SQL Server Compact Edition 可安装在以下位置:

  %Program Files%\Microsoft SQL Server Compact Edition \v3.1

  如果程序文件目录位于 C 驱动器中,则 SQL Server Compact Edition 运行时二进制文件将安装在 C:\Program Files\Microsoft SQL Server Compact Edition \v3.1 目录中。

  在安装 SQL Server Compact Edition 之后,可以在“添加或删除程序”中看到该程序显示为“Microsoft SQL Server 2005 Compact Edition”。

  DataDirectory 支持

  DataDirectory 是表示数据库路径的替换字符串。由于无需对完整路径进行硬编码,DataDirectory 简化了项目的共享和应用程序的部署。例如,无需使用以下连接字符串:

  "Data Source= c:\program files\MyApp\Mydb.sdf"

  通过使用 |DataDirectory|(包含在如下所示的竖线中),即可具有以下连接字符串:

  "Data Source = |DataDirectory|\Mydb.sdf"

  可以通过调用 AppDomain.SetData 在 AppDomain 上设置 DataDirectory 属性。

  注意:

  .NET Compact Framework 不支持 AppDomain.SetData。但是,在为移动设备创建应用程序时,需要使用 .NET Compact Framework 数据访问接口。因此,如果在为移动设备编写应用程序时使用了 DataDirectory 属性,则 SQL Server Compact Edition 将会返回一个错误。

  如果没有设置 DataDirectory 属性,则会应用以下默认规则来访问数据库文件夹路径:

  对于已置于客户端计算机目录中的应用程序,此数据库路径将是置入该应用程序的文件夹。例如,如果 MyApp.exe 置入 /MyDir 文件夹中,则可对 /MyDir 文件夹进行访问。

  对于在 ClickOnce 下运行的应用程序,将会为此目的创建一个数据文件夹,并可对其进行访问。

  对于 Web 应用程序,则可对 App_Data 文件夹进行访问。通过使用 AppDomain.SetData,可以将 DataDirectory 设置为 App_Data 文件夹。

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

What is the difference between HQL and SQL in Hibernate framework? What is the difference between HQL and SQL in Hibernate framework? Apr 17, 2024 pm 02:57 PM

HQL and SQL are compared in the Hibernate framework: HQL (1. Object-oriented syntax, 2. Database-independent queries, 3. Type safety), while SQL directly operates the database (1. Database-independent standards, 2. Complex executable queries and data manipulation).

What should I do if Baidu Netdisk is downloaded successfully but cannot be installed? What should I do if Baidu Netdisk is downloaded successfully but cannot be installed? Mar 13, 2024 pm 10:22 PM

If you have successfully downloaded the installation file of Baidu Netdisk, but cannot install it normally, it may be that there is an error in the integrity of the software file or there is a problem with the residual files and registry entries. Let this site take care of it for users. Let’s introduce the analysis of the problem that Baidu Netdisk is successfully downloaded but cannot be installed. Analysis of the problem that Baidu Netdisk downloaded successfully but could not be installed 1. Check the integrity of the installation file: Make sure that the downloaded installation file is complete and not damaged. You can download it again, or try to download the installation file from another trusted source. 2. Turn off anti-virus software and firewall: Some anti-virus software or firewall programs may prevent the installation program from running properly. Try disabling or exiting the anti-virus software and firewall, then re-run the installation

Fujifilm X-M5 price expectations rise as leaked selfie display adds complexity to the formerly affordable camera line Fujifilm X-M5 price expectations rise as leaked selfie display adds complexity to the formerly affordable camera line Sep 07, 2024 am 09:34 AM

Fujifilm fans were recently very excited at the prospect of the X-T50, since it presented a relaunch of the budget-oriented Fujifilm X-T30 II that had become quite popular in the sub-$1,000 APS-C category. Unfortunately, as the Fujifilm X-T50's launc

Fujifilm X-M5 to arrive with controversial X-T50 film simulation dial as leaker lets slip X-E5 confirmation Fujifilm X-M5 to arrive with controversial X-T50 film simulation dial as leaker lets slip X-E5 confirmation Aug 29, 2024 pm 02:40 PM

The Fujifilm X-M5 has shown itself in a handful of rumours that suggested that the compact APS-C camera would launch as an affordable alternative to the X100VI sometime in late 2024. Now, a new rumour out of Fujirumours reveals Fujifilm's film simula

How to install Android apps on Linux? How to install Android apps on Linux? Mar 19, 2024 am 11:15 AM

Installing Android applications on Linux has always been a concern for many users. Especially for Linux users who like to use Android applications, it is very important to master how to install Android applications on Linux systems. Although running Android applications directly on Linux is not as simple as on the Android platform, by using emulators or third-party tools, we can still happily enjoy Android applications on Linux. The following will introduce how to install Android applications on Linux systems.

How to install Podman on Ubuntu 24.04 How to install Podman on Ubuntu 24.04 Mar 22, 2024 am 11:26 AM

If you have used Docker, you must understand daemons, containers, and their functions. A daemon is a service that runs in the background when a container is already in use in any system. Podman is a free management tool for managing and creating containers without relying on any daemon such as Docker. Therefore, it has advantages in managing containers without the need for long-term backend services. Additionally, Podman does not require root-level permissions to be used. This guide discusses in detail how to install Podman on Ubuntu24. To update the system, we first need to update the system and open the Terminal shell of Ubuntu24. During both installation and upgrade processes, we need to use the command line. a simple

How to Install and Run the Ubuntu Notes App on Ubuntu 24.04 How to Install and Run the Ubuntu Notes App on Ubuntu 24.04 Mar 22, 2024 pm 04:40 PM

While studying in high school, some students take very clear and accurate notes, taking more notes than others in the same class. For some, note-taking is a hobby, while for others, it is a necessity when they easily forget small information about anything important. Microsoft's NTFS application is particularly useful for students who wish to save important notes beyond regular lectures. In this article, we will describe the installation of Ubuntu applications on Ubuntu24. Updating the Ubuntu System Before installing the Ubuntu installer, on Ubuntu24 we need to ensure that the newly configured system has been updated. We can use the most famous "a" in Ubuntu system

Detailed steps to install Go language on Win7 computer Detailed steps to install Go language on Win7 computer Mar 27, 2024 pm 02:00 PM

Detailed steps to install Go language on Win7 computer Go (also known as Golang) is an open source programming language developed by Google. It is simple, efficient and has excellent concurrency performance. It is suitable for the development of cloud services, network applications and back-end systems. . Installing the Go language on a Win7 computer allows you to quickly get started with the language and start writing Go programs. The following will introduce in detail the steps to install the Go language on a Win7 computer, and attach specific code examples. Step 1: Download the Go language installation package and visit the Go official website

See all articles