Experiences in developing the producer Database

I encountered many problems during the development of the host machine. Two of these problems have plagued me for a long time and I was able to solve them today.

The problem occurs when you use the SQL ce database. The host machine version is wince6.0 and supports SQL ce3.5. Therefore, vs2008 is used for development. The installation of vs2008 was successful only one afternoon after another morning. However, Microsoft SQL Server compact edition is not automatically installed after installation. It is not clear why. During vs2008 installation, I have not seen any options about SQL ce.

However, you only need to go to the Internet to find the SQL ce installation program. After finding it, install it and find it in it. the related files of the cab are installed on the host machine. Since I am working on RDA, that is, remote data access, when I try to push, the client and server versions are prompted to be inconsistent.

There is no way to install. cab from other colleagues. RDA can be used normally. When we are happy, we find that the SELECT statement cannot be correctly executed, and exceptions cannot be captured. When the SELECT statement is executed, RDR = comm. when the executereader () Statement is run, the system encounters an exception and an error. It seems like a memory problem. However, after installing the statement, other colleagues can correctly execute the statement, which is strange, I have not found the cause on the Internet. This problem has been bothering me for two weeks. Later, I searched on Google and found several posts in English. I provided a connection address to download SQL Server compact 3.5. After the download, I uninstalled the local machine, after the installation is re-installed, find the cab file from it and reinstall it to the host machine. The problem is solved and you can query it. Just as I was happy, I found that RDA was unavailable and the version was still prompted to be inconsistent. This is the only way to comfort yourself and crash.

No way, go to the Internet to find the installation file, download a lot, and find no way. Later, when I was about to get off work, I checked the. dll attribute after installing it. The client and server versions were finally consistent. However, the program still showed a version inconsistency error. Depressed, leave after work

When I arrived this morning, I found that I could use it normally, and the query and RDA could be executed normally. I thought, yesterday may be because I didn't restart the host machine.

The problems and solutions are summarized as follows. I hope they will be helpful to you because there are not many online resources concerning the development of the host machine, there are few solutions to this fast problem I have encountered.

1. vs2008 installation fails.

Solution: I found it on the Internet, but the specific website is not retained. Sorry, I just remember the solution to install the Net Framework plugin on the machine separately, in this way, vs2008 can be successfully installed. Be patient when installing the first few software, especially the second one. It may take about half an hour.

2. SQL ce cannot execute the SELECT statement. The error message displayed is sqlceqp35.dll and 0xc0000005. Here is the solution version.

Solution: http://forum.xda-developers.com/showthread.php? T = 502771 & amp; page = 8

After downloading the installation, you can run it normally.

3. The version of the RDA client is inconsistent with that of the server.

Solution version: Go to Microsoft's website to download SSCERuntime-ENU-x86.msi, SSCEServerTools-ENU-x86.msi, after installation can be. Restart the host and PC.

I hope this will help you.