I need a web interface to search a table that has various articles stored in
it running on SQL Server 2000. I have been doing some research and trying
to determine the best way to do this. I was hoping I could get some expert
advice, opinions or links to some good articles to help me in my research. I
am under the impression that SQL server 2000 is supposed to make this kind
of task pretty simple, but I have yet to find that trvial solution. What I
have come up with so far:
1. You can use index server to index static pages that are generated by
stored procedures and triggers in the database. (the problem is the static
pages, I would like to keep all the content within the database and generate
the page on the fly)
2. Access SQL server through HTTP by building a SQL compliant URL which
returns data in XML format. This apparently requires some SQL Server set up,
possibly even a plug in. (Any known links on this technique would be
helpful, I only found 1 article on this)
3.Use basic HTML input objects to collect search criteria, web server
recieves parameters and calls a stored procedure that contains most of the
logic. It will return a recordset that is formated by the web server.
4. Just create a DLL that does the search on the database and call that.
Am I missing something? Any help would be appreciated.