500 internal server error

[[Chris F]]

Hi all,

Just wondering if you could possibly check this site for me - [url]www.gtfasteners.co.uk[/url] . I am getting a 500
Internal Server Error message every time I try to log in, however I have set all file permissions related to
the login as read,write and execute.

Username = user
Password = fasteners2003

I don't know all that much about ASP yet as I am learning, but I have managed to get the site working fine on
my localhost using IIS. But when the site is uploaded to the remote server, 1&1 Microsoft package, I get the
errors.

Any help is much appreciated.

--
Regards,
Chris.

[url]http://www.chrisf.has.it[/url]
[url]http://www.lascoronas10.has.it[/url]
[url]http://www.boro.rules.it[/url]

[[Chris F]]

Hi all,

Just wondering if you could possibly check this site for me - [url]www.gtfasteners.co.uk[/url] . I am getting a 500
Internal Server Error message every time I try to log in, however I have set all file permissions related to
the login as read,write and execute.

Username = user
Password = fasteners2003

I don't know all that much about ASP yet as I am learning, but I have managed to get the site working fine on
my localhost using IIS. But when the site is uploaded to the remote server, 1&1 Microsoft package, I get the
errors.

Any help is much appreciated.

--
Regards,
Chris.

[url]http://www.chrisf.has.it[/url]
[url]http://www.lascoronas10.has.it[/url]
[url]http://www.boro.rules.it[/url]
[url]http://www.chrisfuni.has.it[/url]

[[Chris F]]

Julian,

Thanks for your reply, will take a look and try to sort it.
--
Regards,
Chris.

[url]http://www.chrisf.has.it[/url]
[url]http://www.lascoronas10.has.it[/url]
[url]http://www.boro.rules.it[/url]

[Pappas Mike]

You probably have invalid connection string to your database or you did not
declare a system dsn on server, so the machine can not find your database.

[Bob Barrows]

John Toop wrote:

>
> MM_GTFasteners_STRING = "Driver={Microsoft Access Driver
> (*.mdb)};DBQ=gtfasteners.mdb"
>
>

Aargh - don't use ODBC - you're creating an extra software layer. Use the
native Jet OLEDB provider instead! [url]www.connectionstrings.com[/url]

Bob Barrows

[[Chris F]]

Thanks for all replies,

I have taken the advice you have given me and I am going to try to figure out how to get it set up and
running.
It is a bit hard when your a novice at ASP.
A question - John, you suggested that my database shouldn't be in the root folder of the site - where abouts
should I place it, in a folder of its own?

--
Regards,
Chris.

[url]http://www.chrisf.has.it[/url]
[url]http://www.lascoronas10.has.it[/url]
[url]http://www.boro.rules.it[/url]

[John Toop]

Hi Chris,

If it's your server put the file somewhere completely out of the tree like
C:\InetPub or really anywhere you like. If it's an ISP, then FrontPage
suggests a fpdb directory under the root directory you are using now.
FrontPage will install files to prevent the file from being loaded
directly - I'm guessing that you are not using it though. Not many people
use it these days.

Try a "for i=1 to 1000" on the creation of the connection object and see if
it's faster using the OLEDB than using ODBC connection strings.

JT

"[Chris F]" <c.fegan@ntlworldANTISPAM.com> wrote in message
news:uD9McB6TDHA.2460@TK2MSFTNGP10.phx.gbl...

> Thanks for all replies,

<snip>

> A question - John, you suggested that my database shouldn't be in the root

folder of the site - where abouts

> should I place it, in a folder of its own?
>

[LusanInc]

I just recently began to use coldfusion and I have some basic problems for your
programming skills. I was trying to use databases but everytime I use a search
with a simple textbox with the criteria to look for on the db (and substitute
the value on the where of the select) I get the 500 internal server error.

Also I made this simple code... it seems to be right:
test1.cfm
<form action="test2.cfm" method="post">
<p>
<input name="cb1" type="checkbox" value="1" checked>
</p>
<p>
<input type="checkbox" name="cb2" value="2">
</p>
<p>
<input name="Submit" type="submit" value="Aceptar">
</p>
</form>

test2.cfm
<cfif #form.cb1#>
Checkbox 1 checked
<cfelse>
Checkbox 1 unchecked
</cfif>
<cfif #form.cb2#>
Checkbox 2 checked
<cfelse>
Checkbox 2 unchecked
</cfif>

But everytime the I leave a checkbox unchecked (any of both), I get the 500
internal server error. Can anyone help me with this?

[doug777]

Unfortunately the checkbox only gets passed to the next page if it is
checked, so you need to change your code on test2 something like this:

<cfif IsDefined("form.cb1")>
Checkbox 1 checked
<cfelse>
Checkbox 1 unchecked
</cfif>

Of course if the checkbox is used more than once on the action page, it
is better to set cfparam.

Doug

[kyle969]

Doug is correct, either use cfparam or radio buttons.

[LusanInc]

thanx a lot ppl!!
really appreciate it

[spartacustriumvirate]

I have installed CF 7 on 6 new Win 2003 servers. Each server has the exact
same problem.

It appears the first visit to a .cfm page returns the 500 Internal Server
Error. Refreshing the same page will return the actual page.

This test page can be substituted with launching the CF Administrator. The
same thing happens. The first visit is a 500 error, the second gets the
Administrator login page.

All 6 servers have the same behavior and all 6 were installed the same way.
The only change to the default install was placing CFusion in a custom path
instead of the default C:\CFUSIONMX7. The web root, etc. are all the default
IIS settings.

[spartacustriumvirate]

This is for MX 6.1, but it applies to 7.0 as well.


[url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=950218dc&pss=rss_jr[/url]
un_950218dc

I followed the solution and the web servers now server CF properly.

Solution:

To fix this issue, grant the Network Service user in the IIS Worker Process
Group (IIS_WPG) read and write access to the jrun_root\lib\wsconfig directory,
including the sub-folders and files. Restart the IIS Admin Service and the JRun
services after making the permissions change.