Re: Full text setup questions
From: John Kane (jt-kane_at_comcast.net)
Date: 11/11/04
- Next message: Hilary Cotter: "Re: search brings no results"
- Previous message: John Kane: "Re: search brings no results"
- In reply to: Karl: "Re: Full text setup questions"
- Next in thread: Karl: "Re: Full text setup questions"
- Reply: Karl: "Re: Full text setup questions"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 11 Nov 2004 11:18:20 -0800
Karl,
To clarify a couple of things... First of all, this is SQL Server T-SQL
code, just not the specific T-SQL CONTAINS implementation. The key
difference can be found in the "FROM SCOPE" spec used with OPENQUERY &
FileSystem. Normal T-SQL CONTAINS is use in a WHERE clause, such as the
below:
select * from pubs_info WHERE CONTAINS(*,'"books"')
The key error "[OLE/DB provider returned message: There is no catalog. ]"
indicates an incorrectly configured or missing Indexing Service Catalog in
the sp_addlinkedserver definition.
Regards,
John
"Karl" <kwiggins@randallpub.com.(nospam)> wrote in message
news:F2B03DDE-C4EC-4BFF-A27C-DCC50933BA4C@microsoft.com...
> Well FTS still has to be set up on the SQL Server doesn't it?
>
> No, we aren't using NNTP, we are indexing articles in our proprietary
> content-management system.
>
> "Hilary Cotter" wrote:
>
> > This is not SQL FTS. This is using Indexing Services. You need to create
a
> > catalog called web using the IS MMC (go to a command prompt) and type
> > ciadv.msc to administer it. To create the catalog in the IS MMC go to
> > action, new and catalog.
> >
> > Then when your catalog is created right click on it and select
properties
> > and tracking. In the WWW Server drop down box select your web server.
> >
> > It also looks like you are indexing your NNTP server. Is this true?
> >
> > --
> > Hilary Cotter
> > Looking for a SQL Server replication book?
> > Now available for purchase at:
> > http://www.nwsu.com/0974973602.html
> >
> >
> > "Karl" <kwiggins@randallpub.com.(nospam)> wrote in message
> > news:BD830BC0-F393-4FBE-A1DC-EB92E2C0CE83@microsoft.com...
> > > My company has a web site that we bought several years ago, and we
have
> > had
> > > to replace the machines that the site runs on. I have inherited the
DBA
> > role
> > > for this system recently. The site search engine has not been working
for
> > > some time, and after digging through the asp code, I found this query:
> > >
> > > sSql="SELECT a.article_id,srch.size,srch.rank "&_
> > > "FROM OPENQUERY(FileSystem,"&_
> > > "'SELECT FileName, Size,rank "&_
> > > "FROM SCOPE('' """ & FormScope & """ '') "&_
> > > "WHERE CONTAINS(Contents,''" & sSearch & "'') order by rank desc,write
> > > desc') srch,articles a"
> > > if NOT isCMS Then
> > > sSql=sSql & ",columns c"
> > > End If
> > > sSql=sSql & " where cast(a.article_id as
> > varchar(15))+'.htm'=srch.filename"
> > > if NOT isCMS Then sSql=sSql & " AND a.status_id in (4,5) AND
> > > c.column_id=a.column_id
> > >
> > > So, after some searching, I discovered that this was using the
Full-Text
> > > Search function in SQL Server to search through the content news
articles
> > > under the wwwroot folder on the web server. What I'm having a hard
time
> > > doing now is creating a linked server in SQL Server for the folder on
the
> > web
> > > server that actually seems to work. I also haven't found enough
> > > documentation on what needs to be set up on both servers for this to
work.
> > > What I have done so far may be incorrect, but I have set up a linked
> > server
> > > like so:
> > >
> > > sp_addlinkedserver @server = 'FileSystem'
> > > , @srvproduct = 'Indexing Service'
> > > , [ @provider = 'MSIDXS'
> > > , [ @datasrc = 'FormScope'
> > > , [ @location = '\\devserver\wwwroot\content\production\'
> > > , [ @catalog = 'Web'
> > >
> > > I have created a Full-Text catalog on the SQL Server called 'Web' and
a
> > > virtual directory on the IIS server called 'Web' that points to the
> > devserver
> > > folder above. When I run the search from the web site, I get this
error:
> > >
> > > An error occurred while processing your query: [OLE/DB provider
returned
> > > message: There is no catalog. ]
> > >
> > > So I'm guessing that the catalog has not been populated with the
content
> > > from the web server, but I have no idea how to do that, or even if I'm
> > > missing one or more steps. I'm scouring the documentation I can find
but
> > no
> > > luck so far. Any ideas?
> > > --
> > > Karl Wiggins
> >
> >
> >
- Next message: Hilary Cotter: "Re: search brings no results"
- Previous message: John Kane: "Re: search brings no results"
- In reply to: Karl: "Re: Full text setup questions"
- Next in thread: Karl: "Re: Full text setup questions"
- Reply: Karl: "Re: Full text setup questions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
