ASP form to database doesn't work

[Joel@IRR]

Am using Expression Web with FrontPage extensions with a website created in
FrontPage. Because the form is using FP extensions, a person on the
Expression Web group advised I post my question here.
I created a new html form in Expression Web that works fine to send user
inputted data to an email. However, I want the information to go to a
database so
I followed the instructions in my Expressions Web book and saved the form as
an ASP file, went through the steps to create and link it
to a database and published it. Everything seemed to function fine. But
when I try to pull up the asp file on our website to test it, all I get is
an HTTP 500
Internal Server Error. What should I be telling our IT people to look for or
what might be causing this? I could never get this feature to work with
FrontPage either. All I want to do is have the info the form collects end up
in a database. Thanks for any help or suggestions.

 

[Stefan B Rusynko]

Check your DB connections in Tools Site Options Database

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Am using Expression Web with FrontPage extensions with a website created in
| FrontPage. Because the form is using FP extensions, a person on the
| Expression Web group advised I post my question here.
| I created a new html form in Expression Web that works fine to send user
| inputted data to an email. However, I want the information to go to a
| database so
| I followed the instructions in my Expressions Web book and saved the form as
| an ASP file, went through the steps to create and link it
| to a database and published it. Everything seemed to function fine. But
| when I try to pull up the asp file on our website to test it, all I get is
| an HTTP 500
| Internal Server Error. What should I be telling our IT people to look for or
| what might be causing this? I could never get this feature to work with
| FrontPage either. All I want to do is have the info the form collects end up
| in a database. Thanks for any help or suggestions.
|
|

 

[Joel@IRR]

Thanks so much for getting back to me.

The appropriately named database is there but the status is a ?
Also, I cannot even preview the asp page in the browser before publishing.
the page comes up with a http 500 internal server error.
Thanks, Joel

 

[Stefan B Rusynko]

Did you try the Verify Button there?
- If it fails your DB is not connect (or in) the site

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Thanks so much for getting back to me.
|
| The appropriately named database is there but the status is a ?
| Also, I cannot even preview the asp page in the browser before publishing.
| the page comes up with a http 500 internal server error.
| Thanks, Joel
|
| "Stefan B Rusynko" wrote:
|
| > Check your DB connections in Tools Site Options Database
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | Am using Expression Web with FrontPage extensions with a website created in
| > | FrontPage. Because the form is using FP extensions, a person on the
| > | Expression Web group advised I post my question here.
| > | I created a new html form in Expression Web that works fine to send user
| > | inputted data to an email. However, I want the information to go to a
| > | database so
| > | I followed the instructions in my Expressions Web book and saved the form as
| > | an ASP file, went through the steps to create and link it
| > | to a database and published it. Everything seemed to function fine. But
| > | when I try to pull up the asp file on our website to test it, all I get is
| > | an HTTP 500
| > | Internal Server Error. What should I be telling our IT people to look for or
| > | what might be causing this? I could never get this feature to work with
| > | FrontPage either. All I want to do is have the info the form collects end up
| > | in a database. Thanks for any help or suggestions.
| > |
| > |
| >
| >
| >