Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Member
20 Points
7 Posts
Jan 17, 2012 08:47 AM|LINK
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(); }
vinodreddy
Member
20 Points
7 Posts
indexing service getting error Invalid catalog name 'MyCatlog'. SQLSTATE=42000
Jan 17, 2012 08:47 AM|LINK
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();
}
Vinod Reddy