p2p.wrox.com: Archives - asp

asp_databases thread: help neede on Index server search

Message #1 by ANURAGG <ANURAGG@i...> on Thu, 22 Jun 2000 20:35:33 +0530

Hi,

I am trying to use Microsoft index server for text search.But it is giving

me the ff error





ADODB.Connection error '800a0e7a' 

ADO could not find the specified provider. 

/search1.asp, line 21 





This is the code i am using for it

********************************************************

<%@ Language=VBScript %>

<HTML>

<HEAD>

<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">

</HEAD>

<BODY>

<form method="post" action="search1.asp">

Search <input name="search" size=30>

<input type="submit" value="Go!">

</form>

<hr>



<%

search=Trim(Request.form("search"))

if search <> "" then

	search=replace(search,"'","")

	Set Con = Server.CreateObject("ADODB.Connection")

	Con.ConnectionString =  "provider=msidxs"

	Con.Open

	Set AdoCommand = Server.CreateObject("ADODB.Command")

	set AdoCommand.ActiveConnection = Con

	Set RS = Server.CreateObject("ADODB.RecordSet")

	AdoCommand.Properties("Bookmarkable") = True

	AdoCommand.CommandText = "select characterization,"&"docTitle,VPATH

" & " from scope('Deep traversal of ""/Uploads""') where

FreeText(Contents,'" & search & "')>0 order by Rank DESC"

	RS.open AdoCommand

	SearchString = AdoCommand.Properties("Query Restriction")

	If RS.EOF then

		Response.Write("no matches found")

	else

		while not RS.EOF

		%>

		<p><a href="<%=RS("VPath")%>"><%=RS("DocTitle")%></a>

		<blockquote>

		<%=server.HTMLEncode(RS("Characterization"))%>

		</blockquote>

		

		<%RS.Movenext

		wend

	end if

end if%>



</BODY>

</HTML>



***********************************************

Can anyone help me in rectifying the prob.

I'll also like to know the pointers to know about hit highlighting...

TIA

Anurag

Message #2 by Kent Tegels <kent@t...> on Thu, 22 Jun 2000 10:30:47 -0500 (CDT)

Your connection string isn't quite to snuff. You need to specify a data

source. Try something like Provider=MSIDXS.1;Data Source=web



kt



On Thu, 22 Jun 2000, ANURAGG wrote:



> Hi,

> I am trying to use Microsoft index server for text search.But it is giving

> me the ff error

> 

> 

> ADODB.Connection error '800a0e7a' 

> ADO could not find the specified provider. 

> /search1.asp, line 21 

> 

> 

> This is the code i am using for it

> ********************************************************

> <%@ Language=VBScript %>

> <HTML>

> <HEAD>

> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">

> </HEAD>

> <BODY>

> <form method="post" action="search1.asp">

> Search <input name="search" size=30>

> <input type="submit" value="Go!">

> </form>

> <hr>

> 

> <%

> search=Trim(Request.form("search"))

> if search <> "" then

> 	search=replace(search,"'","")

> 	Set Con = Server.CreateObject("ADODB.Connection")

> 	Con.ConnectionString =  "provider=msidxs"

> 	Con.Open

> 	Set AdoCommand = Server.CreateObject("ADODB.Command")

> 	set AdoCommand.ActiveConnection = Con

> 	Set RS = Server.CreateObject("ADODB.RecordSet")

> 	AdoCommand.Properties("Bookmarkable") = True

> 	AdoCommand.CommandText = "select characterization,"&"docTitle,VPATH

> " & " from scope('Deep traversal of ""/Uploads""') where

> FreeText(Contents,'" & search & "')>0 order by Rank DESC"

> 	RS.open AdoCommand

> 	SearchString = AdoCommand.Properties("Query Restriction")

> 	If RS.EOF then

> 		Response.Write("no matches found")

> 	else

> 		while not RS.EOF

> 		%>

> 		<p><a href="<%=RS("VPath")%>"><%=RS("DocTitle")%></a>

> 		<blockquote>

> 		<%=server.HTMLEncode(RS("Characterization"))%>

> 		</blockquote>

> 		

> 		<%RS.Movenext

> 		wend

> 	end if

> end if%>

> 

> </BODY>

> </HTML>

> 

> ***********************************************

> Can anyone help me in rectifying the prob.

> I'll also like to know the pointers to know about hit highlighting...

> TIA

> Anurag

> 

> ---

> Wrox Professional Wireless Developer Conference, Amsterdam, July 10-12. Covering application of WAP, XML, ASP, Java and C++ to
wireless computing, choose from 40+ technical sessions delivered by industry experts:
http://www.wroxconferences.com/ConferenceHome.asp?ConfID=9

> ---

> You are currently subscribed to asp_databases 


>

Message #3 by "Cory Koski" <ckoski@w...> on Thu, 22 Jun 2000 12:10:51 -0400

are you using Win2k?



----- Original Message -----

From: "ANURAGG" <ANURAGG@i...>

To: "ASP Databases" <asp_databases@p...>

Sent: Thursday, June 22, 2000 11:05 AM

Subject: [asp_databases] help neede on Index server search





> Hi,

> I am trying to use Microsoft index server for text search.But it is giving

> me the ff error

>

>

> ADODB.Connection error '800a0e7a'

> ADO could not find the specified provider.

> /search1.asp, line 21

>

>

> This is the code i am using for it

> ********************************************************

> <%@ Language=VBScript %>

> <HTML>

> <HEAD>

> <META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">

> </HEAD>

> <BODY>

> <form method="post" action="search1.asp">

> Search <input name="search" size=30>

> <input type="submit" value="Go!">

> </form>

> <hr>

>

> <%

> search=Trim(Request.form("search"))

> if search <> "" then

> search=replace(search,"'","")

> Set Con = Server.CreateObject("ADODB.Connection")

> Con.ConnectionString =  "provider=msidxs"

> Con.Open

> Set AdoCommand = Server.CreateObject("ADODB.Command")

> set AdoCommand.ActiveConnection = Con

> Set RS = Server.CreateObject("ADODB.RecordSet")

> AdoCommand.Properties("Bookmarkable") = True

> AdoCommand.CommandText = "select characterization,"&"docTitle,VPATH

> " & " from scope('Deep traversal of ""/Uploads""') where

> FreeText(Contents,'" & search & "')>0 order by Rank DESC"

> RS.open AdoCommand

> SearchString = AdoCommand.Properties("Query Restriction")

> If RS.EOF then

> Response.Write("no matches found")

> else

> while not RS.EOF

> %>

> <p><a href="<%=RS("VPath")%>"><%=RS("DocTitle")%></a>

> <blockquote>

> <%=server.HTMLEncode(RS("Characterization"))%>

> </blockquote>

>

> <%RS.Movenext

> wend

> end if

> end if%>

>

> </BODY>

> </HTML>

>

> ***********************************************

> Can anyone help me in rectifying the prob.

> I'll also like to know the pointers to know about hit highlighting...

> TIA

> Anurag

>

> ---

> Wrox Professional Wireless Developer Conference, Amsterdam, July 10-12.

Covering application of WAP, XML, ASP, Java and C++ to wireless computing,

choose from 40+ technical sessions delivered by industry experts:

http://www.wroxconferences.com/ConferenceHome.asp?ConfID=9

> ---

> You are currently subscribed to asp_databases


$subst('Email.Unsub')

>

>

Return to Index

P2P Archives