PRB: Catalog Problems with Site Server 3.0 SQL Samples

ID: Q184903

The information in this article applies to:

Microsoft OLE DB Provider for Site Server, version 3.0

SYMPTOMS

Running the "SQL Extensions Search" sample included with Site Server 3.0 and querying may produce this error:

Your query could not be executed:
SELECT * FROM ssextended_webinfo WHERE CONTAINS('Site AND Server')>0 ORDER
BY Rank DESC
Invalid catalog name . SQLSTATE=42000
Check the syntax of your query, and then try again.

CAUSE

The default catalog is not set for this installation.

RESOLUTION

To set the default catalog, run the Site Server Admin tool as follows:

Go to the Programs\Microsoft Site Server\Administration\Site Server Service Admin (MMC) folder.

Expand the 'Search'/'<YourSite>' folder and right-click the "Search Server" folder to see the Context menu.

Select Properties in the Context menu.

Select a default catalog in the default catalog box.

You can also set a default catalog using the HTML-based Admin tool as well as from the command line.

STATUS

This behavior is by design.

MORE INFORMATION

The same steps may be needed for running a few other Site Server samples that do not allow the user to specify a catalog on the sample page. If there is no default catalog, your query will return the following:

The requested catalog is empty or has not been added to the Search server.

The SQL Multicolumn Search Sample gives this error:

One or more of the specified search catalogs is not available. Please contact the administrator of this site.

The SQL Multicolumn Search sample shows the "catalog1 and catalog2" on the sample page. Specifying a default catalog will not fix the problem. You need to modify the source code of the sample to use an existing catalog name (such as KMSampleCatalog1). To do that, open the file,


   <Path>\Microsoft Site Server\Sites\samples\knowledge\search\multicolumn

in Notepad and change the following line:


   CatalogList = "catalog1,catalog2"

-to-


   CatalogList = "KMSamplecatalog1,KMSamplecatalog2"

You can also create your own catalog with the name catalog1 or catalog2.

REFERENCES

For more information, please refer to the Readme files for SQL samples and to the Site Server documentation.

Additional query words: MSSearchSQL

Keywords :
Version : WINDOWS:3.0
Platform : WINDOWS
Issue type : kbprb