Database Results Error

[Alittleconfused]

I hate to bug you guys again, but I've done everything I can think of to try
and resolve my problem on my own, without much success. So here's the deal:
I connected my access database to my website, and everything seems to be
alright. I've added a web component search box, and the "start search" and
"reset" buttons work just fine. But the database results region appears with
yellow text on my published site as: "Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."
And when I put in a search just for the sake of it, I get a new page that
says:
Cannot run the FrontPage Server Extensions on this page:
"http://www.thomsonequipment.com/Searchpg.asp"
Is there something I'm missing about making that page part of the group??
My host supports FP extensions, and so far they've been working. And my
search page is .asp I read that sometimes default values have to be set in
numeric and autonumber fields, so I did that, and it's still not working.
ANY suggestions would be GREATLY appreciated. Thanks so much.

 

[Thomas A. Rowe]

You can not use the FP Search Component with ASP or any server-side script.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Kathleen Anderson [MVP - FrontPage]]

According to NetCraft, your site is running on an Apache server:
http://uptime.netcraft.com/up/graph?site=http://www.thomsonequipment.com/

DNS Wizard says the same thing - it also says that your site in not running
the FrontPage Server Extensions, but I'm not sure that's true -
http://www.thomsonequipment.com/_vti_inf.html says FPVersion="5.0.2.2623"

You need to be running your site on a Windows server that supports ASP and
Access databases.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Alittleconfused]

ok. When I go to Tools- Site settings, it says my Frontpage server extensions
version is 6.0.2.5516
What should my first step to correction be? Do I need to contact my host
again and verify whether I have extensions installed? And if you cant use FP
search components with ASP how should I connect my database to my website?
As well, are you saying that my Apache server (if thats what I have) won't
support my ASP or Access database? I'm completely at a loss now.

 

[Kathleen Anderson [MVP - FrontPage]]

According to http://httpd.apache.org/docs/1.3/misc/FAQ.html

Does Apache support any sort of database integration?
No. Apache is a Web (HTTP) server, not an application server. The base
package does not include any such functionality. See the PHP project and the
mod_perl project for examples of modules that allow you to work with
databases from within the Apache environment.

Can I use Active Server Pages (ASP) with Apache?

The base Apache Web Server package does not include ASP support. However, a
number of projects provide ASP or ASP-like functionality for Apache. Some of
these are:

a.. Apache::ASP
b.. mod_mono
c.. Chilisoft ASP
Chilisoft will get you some ASP support, but not the kind necessary for
using databases. Can your host move you to a Windows server?


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[Andrew Murray]

Any component using the server extensions must have an *.htm or *.html
extension - not asp or anything else.

eg search form, feedback form using the form handler FPSE.

 

[Alittleconfused]

I really appreciate all the input thus far. Would you all agree that the best
idea at this point is to switch to a windows webhosting service that supports
ASP? I think using any of the Apache::ASP partnerships would just cause more
headaches. Does anyone know if ixwebhosting.com or godaddy.com are good
choices? These are the two I've heard the best things about. I havent had
much luck with integra.net to begin with, so switching hosts seems like the
best idea.

 

[Thomas A. Rowe]

Yes, you need to switch to a Windows IIS Web Host, if you want to use Access as your data source, as
it is not support under any version of ASP running under Unix/Linux Operating System.

If you want to stay with Unix/Linux, then you would need to learn PHP and MySQL.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

 

[Alittleconfused]

Yeah, then that's what I'll do. I'm just going to switch hosts. Thanks so
much for all of the info, you guys are great. ...But here's hoping I'll
never have to talk to you again. Haha :O) Take care.