SQL Server combined with Index Server application 2/3

This article extracts from the Railway publishing house new "use BackOffice to establish Intranet/extranet Application" book (now available in the bookstore. such as Haidian book City, Xidan book building and so on. In the field or need door-to-door readers can go to www.wanbook.com.cn or www.e-bookshop.com.cn online purchase. The book number is ISBN7113039448). This book details how to use the Microsoft BackOffice family of products to build intranet/extranet applications. With it you will master the installation and setup of NT, use IIS to set up a Web site, set up a network conferencing system through ILS, create an enterprise mail and collaboration system with Exchange, build Web database applications with SQL Server, and use proxy Server establishes secure connections to the Internet, creates network TV/radio stations with Media server, builds powerful chat rooms with Chart server, builds personalized mailing lists with Site server, and analyzes access to Web sites, Use Commerce Server to establish business-to-business or business-to-consumer e-commerce sites. In addition, the book also discusses the security of the network, which guides you through a more robust and secure network application. After reading this book, you will find that the implementation of the rich and colorful network applications is so simple ...
Absolutely original, welcome to reprint. But make sure you keep the above text.
Another way to establish a connection is through an SQL statement. Establish a connection using the sp_addlinkedserver storage process. Its grammatical structure is as follows:
sp_addlinkedserver [@server =] ' server ' [,] [@srvproduct =] ' product_name ']
[, ] [@provider =] ' Provider_name '] [,] [@datasrc =] ' data_source ']
[, ] [@location =] ' Location '] [,] [@provstr =] ' provider_string ']
[, ] [@catalog =] ' Catalog ']
This storage process has seven parameters, the meaning of which is as follows:
Server: The name of the connection to establish.
Srvproduct: The product name for the data source to which you want to connect. This parameter defaults to NULL.
Provider: Unique identifier of the product for the data source to which you want to connect. In the Hkey_local_machinesoftwaremicrosoftmssqlserverproviders entry in the registry, you have the name of all connection data types supported by the local server.
DATASRC: As an explanatory information for this data source. This parameter defaults to NULL.
Location: An explanation for the location of this data source. This parameter defaults to NULL.
PROVSTR: The connection string for this data source. This parameter defaults to NULL.
Catalog: Indicates the directory to use when connecting. This parameter defaults to NULL.
The table below lists the values of the parameters used for connecting different types of data.
Data source data type Product_Name provider_name data_source location provider_string Catalog
SQL Server Microsoft OLE DB Provider for SQL Server SQL Server (note)---