linking sql server to index server 
Author Message
 linking sql server to index server
I would like to know how to link sql server to index server.
I did the following: exec sp_addlinkedserver IndexWeb, 'Index Server', 'MSIDXS', 'Web'......

and with that I encounted the following error when I clicked on the tables.
"Error 7301. Could not obtain a required interface from OLE DB provider 'MSIDXS'.

Any help would be great. Thank you...



Sat, 15 Nov 2003 14:54:00 GMT
 linking sql server to index server

If you want to query index server from SQL Server, just use the following
select statement:

SELECT *
FROM OpenRowset('MSIDXS','SERVERNAME';''; '',  'Select Vpath, path,
FileName, size, write, DocAuthor, DocSubject, DocKeywords, DocTitle
 from SCOPE()
 where FileName LIKE ''%.%'' ')

Other than that, I havn't found an answer to actually linking index server.

Quote:

> I would like to know how to link sql server to index server.
> I did the following: exec sp_addlinkedserver IndexWeb, 'Index

Server', 'MSIDXS', 'Web'......

Quote:

> and with that I encounted the following error when I clicked on the
tables.
> "Error 7301. Could not obtain a required interface from OLE DB
provider 'MSIDXS'.

> Any help would be great. Thank you...

--
Posted via CNET Help.com
http://www.help.com/


Sat, 10 Jan 2004 01:30:10 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Linking Index Server with SQL Server

2. Anyone Linked SQL Server 7.0 and Index Server

3. link server from Oracle to SQL server occurs blocking on SQL server

4. LINKED SERVERS : How to link MySQL server on SQL Sever 2000

5. Accessing Index server data using a linked server...

6. Configuring Linked Server to Remote Index Server

7. Query on Index Server with the help of Linked Server

8. USING INDEX SERVER AS A LINKED SERVER?

9. Linked Server for Index Server

10. Linked Server/Index Server Setup

11. Can't connect linked server to index server on seperate machines

12. Help required setting up the SQL2k server to link up to the Index server


 
Powered by phpBB® Forum Software