FP 2002 forms, dbases, extensions

[QMom]

Please, I need help with all of them!! They may all be related to installing the FP2002 extensions, which I can't find detailed help on. Here's what I want to do: On our intranet page, we want to set up user support request forms. The data collected from the forms will go via email to one of two departments, depending on a field choice. At the same time, the collected data will be saved in one of two databases to develop a knowledge base and collect various metrics. The site is stored on and accessed from our webserver, so there's no publishing required (or is there??). When I test one of the forms, I get a run-time component error when I try to submit the form, and/or a save results component error when it comes up in IE.

My biggest issue/question is whether I have properly installed the extensions. They are installed on the webserver, administered from the root web as opposed to the web page I'm working on. Should the new web page be removed as a subweb into its own web? What should be entered as the SMTP server when configuring the extensions - the Exchange server name or something else, with or without the domain name, with or without the whacks ( \\ )? What else should be configured to get the email and database operational? (There are valid email addresses and a database file created.) Maybe someone can outline the necessary steps in installing the extensions, or point me to the correct site to help me out.

We're using a Windows 2000 server, FrontPage 2002 and 2002 extensions, IE6, I'm working from a PC using Windows XP (if that matters), and an Access database (as opposed to SQL).

 

[CoreyBryant]

how are you e-mailing the forms & sending the info to a database? The FP e-mail component will not work on an ASP page & you need to save the form as an ASP page to make it work with the database. Check with the tech people - do they support CDONTs or JMail?

__________________________
Corey

http://www.merchantaccounts4less.com

 

[QMom]

Poop. So you're saying I can have one or the other - have the form send data to an email OR to a database? I can work with that. I'd rather have the email setup. However, when I remove any reference to the database in the form properties, the form still won't send an email. I have a personal web page hosted elsewhere that does this, and it works, and I have the web page set up with the same basic properties. That's why I suspect I haven't configured the SMTP settings properly.

 

[AMysticWeb]

Hi QMom,

Corey is right about this.

Although I have never worked with this myself, you could send to database and email using Cdonts. Your server would need to be compatible with this. The following link can help with this.

http://support.microsoft.com/default.aspx?scid=kb;en-us;275251

It is possible the mail transport isn't set up properly as you suspect. Also you might have overlooked something in form properties. You might include you form HTML here so we could look at it.


Hope I have been of some help,
Micheal

FrontPage Form Tutorials & Form Script Examples
Temporarily @

http://FrontPag.Bizland.com

while resolving host issue

 

[CoreyBryant]

Ah give me a chance to repsond Michael I was on a call. I hope your Thanksgiving was great!

Just curious - when you removed the DB info, did you chnage the page from ASP to HTML? Check with the hosting company to see if they support CDONTs, JMail, etc.

__________________________
Corey

http://www.merchantaccounts4less.com

 

[QMom]

Thanks for your help, guys. I don't know how far behind I am with creating a web page, but I'll take a look at the Cdonts white paper you directed me to. I can look into setting that up on the webserver. (We're hosting the intranet page in-house on its own server.) I'm sure the mail transport isn't configured right, I just wasn't sure what the syntax of the SMTP server name is supposed to be. And when I connected a database and got the pop-up to create an ASP document, I created it as a second document in case it didn't work. I'm working with the HTML document to try to configure the email.

 

[CoreyBryant]

Check out

http://FrontPag.Bizland.com

for help on creating the HTML e-mail form. Usually FP pulls the SMTP info from the IIS set-up. Is that configured properly?

__________________________
Corey

http://www.merchantaccounts4less.com

 

[QMom]

Dude! I can see why you haven't worked with CDONTS. I spent all day yesterday trying to figure out what it is and where to stick it, and determined that I would have to be a VB expert to figure out how to write the code for it. So I'm back to where I was before. Well, maybe not, because I tried reinstalling and reconfiguring the FP extensions, and now nothing works at all. I'm going to try working with them some more and try to get the email working before playing with the database. Someone did finally tell me that when changes are made to the configuration, the IIS service has to be stopped and restarted. If you think of any other suggestions, feel free.

 

[CoreyBryant]

Well Jmail is just about as complicated but I have worked with it enough to almost completely understand it. So it would seem which is better for you - having the form emailed or dumped into the db? Now you said it was being dumped into the DB at one point right? And that form was created by FP? Then FP extensions would have been installed properly.

__________________________
Corey

http://www.merchantaccounts4less.com

 

[QMom]

No, I never got the database to work. I (and everyone involved) will settle for getting the form to send an email to the appropriate mailbox and we can work with something else for tracking purposes.

Thanks for all your help so far. As an update, between this post and the last one, I somehow managed to completely ruin the web page (and all its links), and I have to go retrieve a copy from last night's backup. I think I'll leave it all alone for the rest of today....

 

[QMom]

No, I never got the database to work. I (and everyone involved) will settle for getting the form to send an email to the appropriate mailbox and we can work with something else for tracking purposes.

Thanks for all your help so far. As an update, between this post and the last one, I somehow managed to completely ruin the web page (and all its links), and I have to go retrieve a copy from last night's backup. I think I'll leave it all alone for the rest of today....