accessing full text cat via ixsso

[s_m_b]

trying to figure this through, but no clear answers anywhere.
I've set up a full text catalog on the sql 2k server that runs the site,
and want to query it via the ixsso.query object.

what is the basic sql syntax for this, as the sql server is on a different
server to the web site containing the query page.

[Gang_Warily]

Hi

I think you need to connect to the SQL 2000 database on the other server.
I think ixsso.query will only connect to Indexing Service ... a completely
different kind of query & data source.

This is an Indexing Service group ...
I could be wrong - hope this points you in the right direction for the SQL
syntax
http://msdn2.microsoft.com/en-us/library/aa172870(SQL.80).aspx
Check related pages in the menu to the left.

http://msdn2.microsoft.com/en-us/library/aa172861(SQL.80).aspx
"Note SQL Server does not support full-text search over linked servers."
I hope that doesn't mean 'remote queries' ?

Eric

Post by s_m_b
trying to figure this through, but no clear answers anywhere.
I've set up a full text catalog on the sql 2k server that runs the site,
and want to query it via the ixsso.query object.
what is the basic sql syntax for this, as the sql server is on a different
server to the web site containing the query page.

[Hilary Cotter]

It used to be possible to query MSSearch catalogs like this

objIS.Catalog="MSSearch://CatalogName"

But this has been locked down for a while.
--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

Post by s_m_b
trying to figure this through, but no clear answers anywhere.
I've set up a full text catalog on the sql 2k server that runs the site,
and want to query it via the ixsso.query object.
what is the basic sql syntax for this, as the sql server is on a different
server to the web site containing the query page.