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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-18 : 11:52:17
|
| Steve writes "Hello -I'm trying to build a search engine for an extranet which already uses Index Server. This works fine for static data such as documents, but I also need to return results for dynamic data. I'm using SQL 2000 and ASP. I've tried the Linked Server feature in SQL 2000, and linked to the Index Server catalog, but it generates this error:Error 7301: Could not obtain a required interface from OLE DB provider 'MSIDXS'.Any ideas how to overcome this, or any alternative ideas to combine static/active data queries would be greatly appreciated.Thanks,Steve White" |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-07-18 : 13:33:23
|
| I use this to do "full text searching" of a VARCHAR field. It's been working jsut fine!http://sqlteam.com/item.asp?ItemID=5857Michael<Yoda>Use the Search page you must. Find the answer you will. |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-18 : 17:29:41
|
| Are you linking to a remote Index Server or one locally on the SQL server. Also, what operating system(s) are involved ?HTHJasper Smith |
|
|
|
dickies
Starting Member
5 Posts |
Posted - 2002-07-18 : 18:10:18
|
| Michael -Cheers for the link - just been reading through article. Still want to try to get Index Server and FTS working together via ODBC.Jasper -I'm using both Index Server and SQL Server 2000 on the same NT4 box.... |
|
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-07-18 : 18:36:57
|
| Can you post the query that fails (or an example of one)What catalog are you looking at - is it a custom catalog you created yourself ?HTHJasper Smith |
|
|
|
dickies
Starting Member
5 Posts |
Posted - 2002-07-19 : 08:41:02
|
| I was trying to follow this article...[url]http://www.asptoday.com/content/articles/20000223.asp?WROXEMPTOKEN=250577ZRHVOfu2jvHosdAzSxco[/url] |
|
|
|
|
|
|
Combine SQL Full-Text Search and Index Server