PRB: Catalog Problems with Site Server 3.0 SQL Samples (184903)
The information in this article 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:
- 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.
REFERENCES
For more information, please refer to the Readme files for SQL samples and
to the Site Server documentation.
Modification Type: | Major | Last Reviewed: | 7/19/2001 |
---|
Keywords: | kbprb KB184903 |
---|
|