Microsoft KB Archive/184903

= PRB: Catalog Problems with Site Server 3.0 SQL Samples =

Article ID: 184903

Article Last Modified on 7/19/2001

-

APPLIES TO


 * Microsoft OLE DB Provider for Site Server 3.0

-



This article was previously published under Q184903



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:
 * 1) Go to the Programs\Microsoft Site Server\Administration\Site Server Service Admin (MMC) folder.
 * 2) Expand the 'Search'/'' folder and right-click the "Search Server" folder to see the Context menu.
 * 3) Select Properties in the Context menu.
 * 4) 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,   \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.

