oledb - Full-text search using Windows Search Service and SQL Server 2008 R2 -


currently i'm trying query windows search service sql server 2008 r2 instance (also tested on sql server 2012) . windows search being exposed ole db datasource, giving me several options query search index. when configuring new linked server in sql server, management studio gives me option select microsoft ole db provider search, implying should able connect sql server. turns out challenge , running however. below you'll find error message stumbled upon.

ole db provider "search.collatordso" linked server "testserver" returned message "command not prepared.".
msg 7399, level 16, state 1, line 2
ole db provider "search.collatordso" linked server "testserver" reported error. command not prepared.
msg 7350, level 16, state 2, line 2
cannot column information ole db provider "search.collatordso" linked server "testserver".

things more interesting. although linked server solution isn't working, i'm able wrap code queries windows search in clr function (using msdn: querying index programmatically) , use if successfully within sql server. less desirable, because of steps needed set (deploying library, configuring permissions, etc.). i've tried several parameter settings, without luck. i've tried enabling of search.collatordso provider options, allowing provider instantiated in-process server. i'm using settings below. security i'm using login's current security context.

  • provider: microsoft ole db provider search
  • data source: (local)
  • provider string: provider=search.collatordso.1;extended?properties="application=windows"
  • location: -

additionally need search network drives, can done using shared windows libraries?

i'm aware more people have been struggling problem on last few years. i'm wondering if has been able , running, or point me in right direction.

oledb works

normal ado/oledb components can query windows search service connection string:

provider=search.collatordso.1;extended properties="application=windows"

and example query:

select top 100000 "system.itemname",     "system.itemnamedisplay",     "system.itemtype",     "system.itemtypetext",     "system.search.entryid",     "system.search.gathertime",     "system.search.hitcount",     "system.search.store",     "system.itemurl",     "system.filename",     "system.fileextension",     "system.itemfolderpathdisplay",     "system.itempathdisplay",     "system.datemodified",     "system.contenttype",     "system.applicationname",     "system.kindtext",     "system.parsingname",     "system.sfgaoflags",     "system.size",     "system.thumbnailcacheid" "systemindex" contains(*,'"contoso*"',1033)

you can try query directly on sql server in sql server management studio attempting run:

select * openrowset(         'search.collatordso',          'application=windows',          'select top 100 "system.itemname", "system.filename" systemindex');

which gives errors:

ole db provider "search.collatordso" linked server "(null)" returned message "command not prepared.".    msg 7399, level 16, state 1, line 1   ole db provider "search.collatordso" linked server "(null)" reported error. command not prepared.   msg 7350, level 16, state 2, line 1   cannot column information ole db provider "search.collatordso" linked server "(null)".

bonus reading

have @ code..it may  use [yourdb]     go      set ansi_nulls on     go     set quoted_identifier on     go      create proc [dbo].[searchalltables]     @searchstr nvarchar(100)         begin     declare @dml nvarchar(max) = n''             if object_id('tempdb.dbo.#results') not null drop table dbo.#results     create table dbo.#results      ([tablename] nvarchar(100),        [columnname] nvarchar(100),        [value] nvarchar(max))       select @dml += ' select ''' + s.name + '.' + t.name + ''' [tablename], ''' +                      c.name + ''' [columnname], cast(' + quotename(c.name) +                     ' nvarchar(max)) [value] ' + quotename(s.name) + '.' + quotename(t.name) +                    ' (nolock) cast(' + quotename(c.name) + ' nvarchar(max)) ' + '''%' + @searchstr + '%'''     sys.schemas s join sys.tables t on s.schema_id = t.schema_id                        join sys.columns c on t.object_id = c.object_id                        join sys.types ty on c.system_type_id = ty.system_type_id , c .user_type_id = ty .user_type_id     t.is_ms_shipped = 0 , ty.name not in ('timestamp', 'image', 'sql_variant')      insert dbo.#results     exec sp_executesql @dml      select *     dbo.#results     end

Comments

Post a Comment

Popular posts from this blog

Android layout hidden on keyboard show -

i have strange problem layout. when tap on edittext , keyboard shown edittext stay on bottom , when tap on to hide keyboard , keyboard hides , edittext go should when want input text. when tap again, keyboard shown , edittext goes down behind keyboard... <relativelayout android:layout_width="match_parent" android:layout_height="match_parent" > <scrollview android:layout_width="match_parent" android:layout_height="fill_parent" android:above="@+id/rl_commands"> <textview android:layout_width="match_parent" android:layout_height="wrap_content"/> </scrollview> <relativelayout android:layout_width="match_parent android:layout_height="24dp" android:id="@+id/rl_commands" android:alignparentbottom="true">
Read more

google app engine - 403 Forbidden POST - Flask WTForms -

i have flask application running on google app engine. trying submit form built using wtform , keep getting following error. 403 forbidden: don't have permission access requested resource. either read-protected or not readable server. location.html (part of code) <form method=post action="/home/location"> .... <button type="submit" class="btn btn-primary" value="submit"> directions </button> </form> main.py @app.route('/home/location', methods=['post', 'get']) def location(): form = cfcdirections.direction(request.form) print(request.method) if request.method == 'post' , form.validate(): print("after if") directions = cfcdirections() street_no = directions.no street = directions.street suburb = directions.suburb postcode = directions.postcode
Read more

c - Why would PK11_GenerateRandom() return an error -8023? -

i looking through internet trying find source of pk11_generaterandom() function see why function fail. have program uses function when moved new flavor of linux, fails after forking ( fork() ) since not believe there problem nss, suspect doing incorrectly disregarded in older versions of linux new 1 there issue. the openssl package same on 'good' , 'bad' server: openssl 0.9.8e-fips-rhel5 01 jul nss rpm differs though. 'good' has nss-3.12.2.0-2.el5 and bas has version nss-3.15.3-4.el5_10 the 'good' server uses quite obsolete linux: linux 2.6.18-128.el5 #1 smp wed jan 21 08:45:05 est 2009 x86_64 x86_64 x86_64 gnu/linux enterprise linux enterprise linux server release 5.3 (carthage) red hat enterprise linux server release 5.3 (tikanga) the 'bad' server newer: linux bad 2.6.18-371.4.1.el5 #1 smp wed jan 29 11:05:49 pst 2014 x86_64 x86_64 x86_64 gnu/linux oracle linux server release 5.10 red hat enterprise linux server release
Read more