Document Title: How to post MS SQL Server program keyword: Post-based MS SQL Server-based program This article has been read 1999 since 2003-3-1 Add to C Builder Research Website.
-------------------------------------------------- ------------------------------ based on how the publisher of the MS SQL Server: ---------- If you reprint, please ensure the integrity of this document and indicate it. Welcome to C Builder Research, http://www.ccrun.com/doc/go.asp? Id = 471 Many friends feel headache for the release program after writing SQLServer-based programs, because only release applications and BDE is not enough If you have to install SQLServer Client software, do you want to provide a SQLSERVER CD? Below Jojo introduces a solution:
1. Prepare a version of Install Shield Express, preferably 2.01 or more, there is a private version on the Delphi installation disk. You must establish an installer according to the method of making a general program installation disk. You must install BDE and SQL Links.
2. Locate the following files below your Windows / System (Of course your machine must already have SQLServer):
DBMSSOCN.DLL TCP / IP Support file DBMSSPXN.DLL IPX Support file DBNMPNTW.DLL Name Pipe Support file NTWDBLIB.DLL SQLSERVER core file (this file is most important) 3. In the Groups and Files of FPecify Components and Files, the above The file is added to Program Files. Of course, you can also create a group, copy these files into the System directory, but Jojo personal tends to copy to the installation directory so that you can completely remove them.
4. If your program is relatively simple (such as only one network segment) now you have already gotten it, but unfortunately, most people are not so simple. Here's also modify the registry:
Modify the key value:
Where DSQuery sets the default connection protocol, set IPX, 128.1.1.1 is a proprietary connection, here is a connection with a connection name of 128.1.1, use TCP / IP protocol, IP address is 128.1 .1.1, you can also change the key name to other names, as long as the server name is the same as the server name in your alias.
At this point, your installation disk has been made, and now you can only need building.
