There are some problems that can be caused by MySQL login

The project is handled according to the boss, want to engage in a similar version of the personal study version to the customer trial. Plan to publish the installation package through the network, let the customer download the installation use, encountered a problem: the database installation. Because the background uses MS SQL Server 2008/2000 database storage files, pictures and other data, but MS SQL Server installation package is large, let customers download is also a problem.

1. Tried to use the MSDE2000, according to Microsoft to say that the Windows Vista operating system does not provide compatible support ( do not know just Vista does not support, or from the Vista start later version of the operating system is not supported?) and now basically is WIN7/8, see online is a lot of tutorial said how to install under Win7, temporarily no environmental test. In addition, MSDE2000 is a very old version, starting with SQL Server 2005, without MSDE, into the Express version.

　　

RELATED links:

http://www.microsoft.com/zh-cn/download/details.aspx?id=22661

Http://jingyan.baidu.com/article/f3e34a126b5181f5ea653544.html

2. SQL Server 2000 took a little time before the unattended automatic installation, the XP, Win7 32/64 and other operating systems to test the basic no problem, can be installed properly, and can be successfully attached to the database through the script. But the final toss out of the entire installation package (including hit SP4 patch) is still relatively large, only the database installation program is more than 300M.

　　

3. SQL Server R2 not to mention, the installation package is more than 4GB, not to mention the installation process is prone to problems, especially after the problem of reloading more trouble. In fact, the installation is a trivial matter, the key is that the current use is cracked version, involving copyright matters will not be clear. SQL Server Express version is free, but there are more complex installation, database file size limit, the installation program is not easy to publish and other issues.

　　

4. MySQL. Open source software, do not be afraid of being called to threaten to send a lawyer letter (with Delphi2010, encountered this kind of thing, although also nothing, but the diaphragm should). Before it was a 5.1.3 version of the compressed package, size 18.2MB,. It can be used directly after decompression. In this way, distribution is convenient. Searched, there are Daniel wrote this article describes a tool to go from MS SQL Server to MySQL software mss2sql (http://blog.csdn.net/andrew_wx/article/details/6832404/). Today when using MySQL, no navicat client, directly from the command line login, error: Cannot connect to MySQL Server on ' localhost ' (10062). Look, there is no MySQL service item at all. Re-installed and started the next service solved the problem ( what happened, the last few days have been well used ). Also, refer to the following: http://www.cnblogs.com/losesea/archive/2012/11/08/2760536.html

　　

At the moment, the rest of the problem is:

1. How to convert the database tables in MS SQL Server 2008 to MySQL. Test the Mss2sql tool mentioned above.

2. The code originally is ADO direct connect SQL Server database, I adjust to also can support MySQL. Remember to look at the design pattern when there are relevant content, take the opportunity to practice.

There are some problems that can be caused by MySQL login