Vista Search - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Vista Search

Author

Topic

niallk
Starting Member

3 Posts

Posted - 2007-02-09 : 10:33:15

Hi

I'm trying to use Express to query the Vista Search engine using a linked server as follows:-

sp_addlinkedserver @server = 'myLinkedSvr', @provider = 'Search.CollatorDSO.1', @datasrc = 'SYSTEMINDEX', @srvproduct = '', @provstr='Application=Windows'
go
SELECT FileName FROM OPENQUERY("myLinkedSvr", 'SELECT Filename FROM SYSTEMINDEX')
go

but this returns

Server: Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "Search.CollatorDSO.1" for linked server "myLinkedSvr" reported an error. Command was not prepared.
Server: Msg 7350, Level 16, State 1, Line 1
Cannot get the column information from OLE DB provider "Search.CollatorDSO.1" for linked server "myLinkedSvr".
OLE DB provider "Search.CollatorDSO.1" for linked server "myLinkedSvr" returned message "Command was not prepared.".

It's obviously "almost" working because it complains if I query a column that does not exist.

Any ideas?

tia
Niall

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-09 : 10:36:08

Can we call this duplicate?

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78564[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

niallk
Starting Member

3 Posts

Posted - 2007-02-09 : 15:17:37

Yes, it was a duplicate. Original deleted.

Niall

quote:
Originally posted by harsh_athalye

Can we call this duplicate?

[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=78564[/url]

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources