Index Server

Discussion in 'ASP .Net' started by Tim, Jul 17, 2003.

  1. Tim

    Tim Guest

    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");
     
    Tim, Jul 17, 2003
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. karthikeyavenkat
    Replies:
    2
    Views:
    629
    Bryce
    Mar 17, 2005
  2. Shawn W_
    Replies:
    5
    Views:
    299
    Aldric Giacomoni
    Sep 16, 2009
  3. ngoc
    Replies:
    5
    Views:
    187
    Tad McClellan
    May 11, 2006
  4. Tomasz Chmielewski

    sorting index-15, index-9, index-110 "the human way"?

    Tomasz Chmielewski, Mar 4, 2008, in forum: Perl Misc
    Replies:
    4
    Views:
    321
    Tomasz Chmielewski
    Mar 4, 2008
  5. Stefan Mueller
    Replies:
    7
    Views:
    199
    Thomas 'PointedEars' Lahn
    Nov 28, 2005
Loading...

Share This Page