Accessing SQL Server Index
I'm working on creating a search functionality. I have keywords of articles in one column of a SQL server table, and the search terms of the user is hitting that column.
It works but I'm stuck on how to determine relevancy. I know you can create indexes in SQL server, and if it works anything lik Index Server, I was thinking that I could connect via ADO and determine relevancy.
View Replies
ADVERTISEMENT
I am uploading to a server for the first time. I believe that my server will not point to .asp pages as the start page, only .htm is this correct?
I wanted my index.asp page displayed first from the web-site by default, but have been told that I need say, an index.htm which then points to my index.asp page.
Is there a way that I can use my index.asp page as my start page?
View Replies
View Related
I'm just about to start a project that needs to combine the results of a SQL
Server query with the results of an Index Server query. The basic idea is
that the user enters/selects a bunch of search criteria on a form.
Most of
the criteria selected by the user will be used to select records from the
database - standard WHERE clause stuff - but the user can also enter
free-text that should be searched for in associated uploaded documents.
The
documents are sitting in the file-system with file-name pointers only stored
in the database (not the document). Only records where the associated
free-text is found in the documents should be returned. I'm new to Index
Server and am wondering how is this done. Any good references/tutes?
View Replies
View Related
I fire the following code on Index Server (different obj) and it returns a PDFs no problem, but when I change the object to use the MSSearch for Site Server I don't get any PDFs. Anything in the code that would cause this? I can see the PDFs getting crawled in Site Server, but when I try and search I don't get any pdfs .....
View Replies
View Related
This is partly an ASP question and partly not an ASP question.
I'm trying to implement an ASP page that will use Index Server to provide search capability for a document repository folder. I've gotten this working on my server fine, but I'm now trying to implement it on a laptop (running Windows 2000 Pro) so that a salesman can show it to a prospective client. I was wondering if anyone knew if accessing Index Server through a web page would work on Win2kPro and the PWS it has?
Also, my working version is currently using the old style idq and htx pages and I've been having a hard time finding a good resource to show me how to do this in ASP...
View Replies
View Related
I have to place a search the site text box in my .net site .I have installed MS indexing service and it has indexed my completed folder and if i query it it only shows the fields Rank,filename,Vpath,write ,size its not showing me the description and title which my headache.
I am making the query to server :
"select description,Contents,DocTitle, Filename, Vpath, Size, Write, Characterization, Rank from scope() where FREETEXT(Contents, 'market') order by rank desc"
View Replies
View Related
I have index server running and happily cataloging one site and dishing up search results via and asp page. Having created a new catalogue for another site and putting the same asp code in I don't seem to have any info in the "characterization" field! Any idea why this is? Is there something about the way the pages are built that would allow that to work or not?
View Replies
View Related
While reading a article i came accross this word "index server"?
what does this all about?
View Replies
View Related
I've been playing around with MS Index Server 3.0 (well, the one that comes with Windows 2000 Professional!) and my client has a website that generates dynamic content based on ASP code. I unfortunately require the use of Index Server because the IFilter allows support for searching within PDF files.My problem is that while all of the static content pages and PDF files are detected, indexed and catalogued fine, none of any dynamic pages are. I can clearly see why this is, since I assume Index Server doesn't have a webcrawler of any sort!I was wondering then, how people generally get around this problem, working with it? What is a quick way to get dynamic content integrated into the search? Should I find/write a webcrawler then put it into my search program or is there something better out there that will let me do all of this
View Replies
View Related
I have a custom search engine for our website that uses MS Index Server and it works great but it doesn't find any results for searches that contain french accented characters.If I'm searching for "élément"...it doesn't find anything because the page uses html codes for accents and this word would be written like
"élément" in my source code. My page uses charset utf-8 but the Index server uses 2 separate files(.htx and .idq files) and there doesn't seem to be any settings in there for this problem.
View Replies
View Related
I'm having trouble getting my head around the query language for an Index Server Search w/ASP.I have some dummy content pages that have text like "this file contains things" and "this file contains stuff".I've tried these two queries:
PHP Code:
SELECT DocTitle, VPath, Path, Filename, Rank FROM SCOPE('DEEP TRAVERSAL OF "c:inetpubwwwroot"')
WHERE ((CONTAINS(' "file contains" ') >0)
AND ((Path NOT LIKE '%\_vti%') AND (Path NOT LIKE '%\_private%') AND (Filename NOT LIKE 'search.asp')))
ORDER BY Rank DESC
View Replies
View Related
I have written a search logic for my website using microsoft indexing
service. I designed it on Windows XP. It works great.
Then i copied that to our Windows NT webserver and it is giving me the
following error
Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object
/search.asp, line 25
Line 25 is
Set QueryObj = Server.CreateObject("IXSSO.Query")
View Replies
View Related
Does anyone know anything abot Index Server ... The Documentation is Terrible and I am trying to find out if you can query the DocTitle.
View Replies
View Related
We've had Index Server 2.0 running on an NT4/IIS4 server for several months now. It generates document abstracts and we retreive and display them using ASP/VBScript and ADO, using the SQL-querying method rather than the proprietary Index Server objects.
We're now trying to set up a replacement server based on Index Server 3.0 and Win2000/IIS5. We have the system up and running as before, with the exception of the abstracts.
Nothing is being returned for the abstracts - no data, no error message. "Generate Abstracts" is ticked in the Catalog Properties and we've ordered any number of re-scans and Stop/Starts of the service, but we're still not seeing any abstracts.
View Replies
View Related
I need a search engine for my web. The service Index Server (for web) is started (win 2K) but i don't know how to make an ASP page for that. I can make a form like this:
<form ACTION="/asp/search_v2/query2.asp" METHOD="POST">
<table WIDTH="500" bordercolor="#FFFFFF">
<td>Give what you want to search:</td>
</tr>
<td><input TYPE="TEXT" NAME="SearchString" SIZE="65" MAXLENGTH="100"
VALUE=""></td>
<td><input TYPE="SUBMIT" NAME="Action" VALUE="Go"></td>
</form>
but then .
View Replies
View Related
I am currently in the process of moving my website from an NT Server/IIS 3.0 to a Win 2003 Server/IIS 6.0. I am trying to set up the index server for my site search. I have added the catalog and stored it in the same directory as my current website. I am using the exactly the same code and the same catalog name.
When I use the "Query Catalog" option within the Index Server I get results when I run a search. However, when I run a search through the website I get nothing returned.
View Replies
View Related
We've been using Index Server and IIS4 and the corresponding objects to
search our sites. Everything fine.
Now we have set up a new server running IIS6 and the search results always
return "null" for Characterization, DocSubject and some other properties. I
found out that they were not cached. But turning caching on and initiating a
reindex didn't help either. Code runs fine on IIS4.
View Replies
View Related
I've not used Index Server since I set it up about 4 years ago on a Windows NT 4 machine.
I now have to move the site to a Windows 2000 machine. I've hunted high and low and have yet to find anything on the subject. Anyone point me in the right direction?
View Replies
View Related
I am using the Index search server that comes with MS IIS 3.0. The search works ok but how do I limit the search to only HTML/ASP files and not include MS Office files in the search results?
View Replies
View Related
I was excited to use Microsoft Index Server, built into IIS, to set-up a site-search function, but it doesn't, by default, parse the ASP code of the pages it indexes. This makes it sort of a weak option for a site that uses variables to populate content in a templated site.
For example, I use variables to fill in the meta tags, and every page shows up in the search results as "UNTITLED." The problems go much deeper than that, but that's just an example.
if there's a trick to make it parse the code before it indexes? I mean, it's IIS, right? It should be able to parse ASP code. (You would think.) It seems to know not to index the ASP code, or else the contents of the variables would still be indexed, so it seems like it has the potential to parse the code before indexing.
View Replies
View Related
I am having a problem with the following search results code. The first page of results looks normal, but on the second page (records 26+), no results are displayed and the following error message is shown:
“The catalog directory can not be found in the location specified by 'CiCatalog=' in file indexServer.idq.”
I do not understand how the catalog could have changed in between the first and second pages of results. Can anyone tell me what may be wrong? I have attached the search page (search.htm), the query file (indexserver.idq) and the query results template (indexserver.htx).
View Replies
View Related
I have set up Index Server in IIS to search my intranet. I've installed the Adobe PDF filter so that words from PDF files are included.
I can get results from PDFs when querying the catalogue in the Windows console. However, I have tried various ASP Search pages and they all ignore PDF files from a browser (even though the scripts include the pdf extension).
View Replies
View Related
Development environment: Windows 2003 Server running IIS6 and the same
server running as a domain controller, DNS and DHCP servers.
Production environment: Windows 2000 Server SP4 running IIS5 and not used
to provide domain control or name services.
The two environments are on different networks with no trust relationship
between them. In both environments the web server is set up to disallow
anonymous access and to use integrated Windows authentication. The
application is vanilla ASP (i.e. not .NET) VBScript.
In the development environment, the following code runs flawlessly no
matter whether "myUNCPath" points to a share on the web server or a share
on another server in the same domain.
Set objFilesys = Server.CreateObject("Scripting.FileSystemObject")
If Not objFileSys.FolderExists(myUNCPath) Then
Set objFolder = objFileSys.CreateFolder(myUNCPath)
End If
However, in the production environment it falls over with a permission
denied error when "myUNCPath" is on another server and further testing
shows that the FolderExists method is returning false even when
"myUNCPath" exists. The network share is configured to give full control
to the Everyone group.
I've found http://support.microsoft.com/kb/207671 which although
referring to IIS4 suggests that the issue could be the authentication
method (I'm assuming that integrated Windows authentication is close
enough to NT Challenge/Response and so might generate a token that cannot
access network resources). I'm not sure of this is the problem because if
it were then the code shouldn't work in my development environment.
Any ideas on what's going wrong and how to access the network resources
in the production environemt?
View Replies
View Related
I am trying to access a LDAP server with ASP with no sucess. I can do it with ColdFusion but not ASP. All the examples I have seen so far do not use passwords or userid's. My LDAP server requires password and user credentials. Can anyone point me in the right direction.
View Replies
View Related
I am trying to execute some code from an ASP page which connects to the database.I am getting the error message from SQL Server.The error message is:
Microsoft OLE DB Provider for SQL Server error '80040e14'
The specified schema name "aspSchema" either does not exist or you do not have permission to use it.Can someone please tell me why I am getting this error and how to solve it?
View Replies
View Related
I have developed a fairly simple CMS for my intranet at work - I would like to have a "Request a photographer form" that e-mails me the posted data by utilizing our intranet exchange server, if possible.
I'm not really looking to code this but I will if I absolutely have to =) Anyone know how to do it or where I can find a simple form script that does? I have found lots that work with sendmail and other types of servers but none for exchange.
View Replies
View Related
I have implemented a Web Service on an IIS 5.0 platform using the ASP listener
I can access the Web Service just fine from a VB 6 App and classic ASP using the SOAP 3.0 toolkit and its "MSSOAP.SoapClient30" object
However, one of the servers that I'd like to call the Web Service from is a shared hosting platform that does not offer the "MSSOAP.SoapClient30" object
It only has the MS XMLDOM. I have located an example of Accessing a Web Service via the MSXML DOM from an Active Server Page where the Web Service is on a .NET platform (http://home.att.net/~codeLibrary/ASP/ws.htm
But I need to know how to access a Web Service from an Active Server Page with the MS XMLDOM where the Web Service is implemented using classic ASP.
View Replies
View Related
I want to be able to client process of the ASP page to get the value
populated in Request("rssFeed"), how can I do this because the Request
object is not available to the Client-side.
View Replies
View Related
My ISP provides some scripts that allow control of the server by using scripts that are accessed via http. I want to be able to access these scripts from an ASP/Jscript application but I don't want the command displayed in the address bar of the browser. Adds a mail alias fred to user@domain.dom . I think that this can be done with fopen in PHP but I don't know how it is done with ASP.
View Replies
View Related
I have read that there can be a periodic problem when reading large varchar or text fields from SQL server (or memo fields from Access)--they can sometimes come up as empty strings.
What I have been unable to find out is whether this problem is still around in recent versions of MDAC (>= 2.8). Does anyone know whether this problem still occurs--is it still necessary to follow the steps in that aspfaq article?
View Replies
View Related
I've been browsing this and a few other related newsgroups trying to get my head around this problem, and so far all the trails seem to go cold, without an acceptable solution being reached. I'm posting here because there seems to be a few MVP's knocking around, and if they dont know, then it's a safe bet nobody does.
I'm beginning to think that what I want to do is simply not possible - but i'll put it out there once more.
Here goes: I'm writing a content managaement system - and i'm making use of dynamic includes via the "read a text file" technique, and then substitiuting values into markers in the template. Code:
View Replies
View Related
I am trying to access a webservice to post some values via MSXML2.ServerXMLHttp The OS used is win2003 on both machines.
When I access the local machine (A) which has the same service the call works great. When I access the other machine (B) that is on the same subnet, I get a Status of 500. Code:
View Replies
View Related
Following is a vbscript code extract triggered by a combobox OnChange event. arrVendorA and arrdefpack are server side arrays and i need the intCounter parameter to be the array index. Code:
<script>
sub getstdPackByVendor(strPartNo, intCounter)
dim selVendor
selvendor= colSelect("cboVendor", intCounter).value
if selvendor= "<%=arrvendorA(intCounter)%>" then
if "<%=arrdefpack(intCounter)%>" = 2 then
colTD("txtStdPack" & intcounter+1 ).innertext = cstr("<%=arrVAStdPAckL2(intCounter)%>")
end if
end if
end sub
</script>
View Replies
View Related