indexing service getting error Invalid catalog name 'MyCatlog'. SQLSTATE=42000

hi im trying to access indexing service remotly but im getting ths error Invalid catalog name 'MyCatlog'. SQLSTATE=42000.

this is my code.

string connectionString = string.Format("Provider=MSIDXS.1" );
            DataSet dataSet = null;
            OleDbConnection connection = null;
            string Server="MyMachine";
            string Catalog = "MyCatlog";
            try
            {
                connection = new OleDbConnection(connectionString);
                connection.Open();

                string query = @"SELECT doctitle, vpath, filename, size, write, characterization, rank FROM "+Server+"."+Catalog+"..SCOPE() " +
                "WHERE FREETEXT(Contents, '\"" + searchString + "\"') AND (filename Like '%.asp%'" +
                " OR filename Like '%.shtml%'" +
                ")";
                OleDbCommand command = new OleDbCommand(query, connection);
                OleDbDataAdapter adapter = new OleDbDataAdapter(command);
                dataSet = new DataSet();
                adapter.Fill(dataSet);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                connection.Close();
            }

Re: indexing service getting error Invalid catalog name 'MyCatlog'. SQLSTATE=42000

Hello

If you are using SQLYou should use SqlConnection,SqlCommand in the System.Data.SqlClientotherwises if accessyou can use OleDbBut as far as I seeI don't think there's a FreeText search in the Access db

PSTry to have a test in the sql management studio to test your sql statement to see what's happeningmake sure that there's no errors

Reguards