Index Server

[cameron]

I have Index Server searching a directory of HTML files. I have set a
few custom META tags in these HTML files so that these tags show up in
the index searcher properities, so I get an entry like:

d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1 adxeffectivedate [no friendly name]
VT_LPWSTR 4 Secondary

When setting up the search in c# I specify the column name which is the
friendly name, when I right click and do a properities, I can not set
the friendly name. I have stopped and started the service and played
with what is there. How do I either set the friendly name or select the
property without the friendly name?

-Cam

[Jack Blalock]

Here is an article that shows how to do this in normal asp:

Using Index Server to Query and Display META TAG Information
[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;185985[/url]

You specify this with DefineColumn, and then are able to include this with
your normal columns.

Jack Blalock [MSFT]
This posting is provided "AS IS", with no warranties, and confers no rights.

[Tim]

I'm trying to query the index server for document properties. The
create view statement below is executed and later I call a function
that fires the execution of the view which is shown below the view.
I'm getting an error of "System.Data.OleDb.OleDbException: View
'#WKCSEARCHVIEW' has not been defined in catalog 'Web'.
SQLSTATE=42S02" on the last line.

Any help would be appreciated.

-Tim


//OleDbConnection
OleDbConnection oConn = new OleDbConnection("provider=msidxs; data
source=Web");
oConn.Open();

OleDbCommand oCmd = new OleDbCommand(strSetProperty, oConn);
oCmd.ExecuteNonQuery();
//this does fire, I use the same connection for a few events

strCreateView = "CREATE VIEW #WKCSearchView AS ";
strCreateView += "SELECT FileIndex, DocTitle, vpath, filename, size,
write, characterization, rank ";

strCreateView += "FROM SCOPE(' DEEP TRAVERSAL OF ( " + strScope + " )
')";

oCmd.CommandText = strCreateView;
oCmd.ExecuteNonQuery();



//set up the provider
string strProvider = "PROVIDER=MSIDXS; DATA SOURCE=Web";

//create the connection and open it
OleDbConnection oConn = new OleDbConnection(strProvider);
oConn.Open();

OleDbDataAdapter oCmd = new OleDbDataAdapter(strSql, oConn);
DataSet oDS = new DataSet();

oCmd.Fill(oDS, "Results");