MSDEWIN10 cannot be used in win7/WIN8.1 (x64 ).
By force installation (administrator privilege) and Manual start of the service, you can install and use MSDE on Windows 81
Microsoft SQL Server 2000 Service Pack 4 Desktop Engine (MSDE 2000)
However, when MSDE is run on 64-bit Windows 7 7 (all-in-one computer), it is found that the speed of adding data to the table using ADO RecordSet is very slow and the performance problem is very serious. as a result, the program cannot run normally.
Later there was no way. I changed SQL2008R2 Express and found that the performance was very good, and the software system was running very smoothly.
This may be an example, but as a pitfall, You need to record it to prevent it from falling in again.
It seems that MSDE is indeed old, and there will be various strange problems in the 64-bit operating system (Win7, Win81.
In the new Win10 system, MSDE cannot be properly installed using the MSDE Installer. It is said that a test version of win10 is acceptable and there is no chance to verify it.
Since Microsoft has abandoned WinXP, it seems that it is time to give up MSDE on the new system.
Attachment: MSDE2000 (SP4 ):
1. Download the webpage.
Http://www.microsoft.com/downloads/zh-cn/details.aspx? FamilyID = 8e2dfc8d-c20e-4446-99a9-b7f0127f8bc5
SQL2000.MSDE-KB884525-SP4 x86-CHS.EXE
The setup. ini file used for msde installation. Here, msde is the Instance name, abcedefg is the password, and the last item is to enable TCP/IP access protocol.
[Options]
INSTANCENAME = "msde"
SAPWD = "abcdefg"
SECURITYMODE = SQL
DISABLENETWORKPROTOCOLS = 0