How to publish a program based on MS SQL Server

Many friends have a headache for the publisher after writing a SQL Server based program, because it's not enough to just publish applications and BDE, you have to install SQL Server client software, do you want to provide a CD-ROM for SQL Server? Below JoJo to introduce a solution to the way:

1. Prepare a copy of install Shield Express, preferably more than 2.01 version, in Delphi installation disk has a special version can also be used, in accordance with the production of general Procedures installation disk method to establish the installation program, you must install BDE and SQL LINKS.

2. Find the following files below your Windows\System (of course your machine must have SQL Server installed):

Dbmssocn.dll TCP/IP support files

Dbmsspxn.dll IPX Support Files

Dbnmpntw.dll Named pipe support file

Ntwdblib.dll SQL Server Core file (most important for this file)

3. In the groups and files of fpecify components and files, add the above files to program files. Of course, you can also create a group that copies these files into the system directory, However, JoJo individuals tend to copy to the installation directory, in order to reverse the installation can be completely deleted.

4. If your program is running relatively simple (for example, only one network segment) Now you are done, but unfortunately most people's network environment is not so simple, the following will also modify the registry:

To modify a key value:

Where dsquery set the default connection protocol, which is set ipx,128.1.1.1 is a proprietary connection, here is to set a connection name 128.1.1 connection, using the TCP/IP protocol, IP address is 128.1.1.1, you can also change the key name to another name, As long as it is the same as the server name in your alias.

At this point, your installation disk has been made, now only need to building a moment on it.