By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,569 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,569 IT Pros & Developers. It's quick & easy.

500.100 internal server error

P: n/a
Ben
hi

when I try to excecute an ASP (either JS or VB) script to
say, access a database record, I get an Internal Server
Error HTTP 500.100

Why? and HOW CAN I FIX THIS?

Thanks

Ben

Jul 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
500 errors basically mean: Something is wrong.

In your browser, clear the "Show Friendly Error" option and then what error do you received (In IE's Menu, Tools->Internet Options->
Advanced tab. Find "Show Friendly HTTP error message, and uncheck it. Apply and OK changes, then close your browser.) Is this does
not tell you the true problem, then I have a couple of questions, what version of IIS or Windows are you running on? Are there error
messages being logged in the Event logs? Does html work?
-rwg
This is what I think, not necessarily what is accurate!

--------------------
| Content-Class: urn:content-classes:message
| From: "Ben" <an*******@discussions.microsoft.com>
| Sender: "Ben" <an*******@discussions.microsoft.com>
| Subject: 500.100 internal server error
| Date: Sat, 6 Mar 2004 23:05:03 -0800
| Lines: 12
| Message-ID: <84****************************@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQEEoPFyT1EUUdQR32fATlEkWZtlA==
| Newsgroups: microsoft.public.inetserver.asp.general
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.asp.general:267686
| NNTP-Posting-Host: tk2msftngxa08.phx.gbl 10.40.1.160
| X-Tomcat-NG: microsoft.public.inetserver.asp.general
|
| hi
|
| when I try to excecute an ASP (either JS or VB) script to
| say, access a database record, I get an Internal Server
| Error HTTP 500.100
|
| Why? and HOW CAN I FIX THIS?
|
| Thanks
|
| Ben
|
|
Jul 19 '05 #2

P: n/a
Hi Rob

Nothing -- I still get the same 500.100 Internal Server
Error - ASP Error.

HTML works fine

I am using Windows XP Professional with IIS

Thanks

Jul 19 '05 #3

P: n/a
Hello Ben:

| Nothing -- I still get the same 500.100 Internal Server
| Error - ASP Error.

That's odd. Normally with the 500.100 ASP error, turning off Show Friendly Error results in you seeing the line of code that ASP failed on.
Then you would see something like this:

ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/Nwind.asp, line 10
< from "HTTP 500.100 - Internal Server Error" When You Try to Access a Provider http://support.microsoft.com/?id=278604 >

This is the information needed to isolate the problem. Maybe this information is being logged in the IIS web log. Recreate this failure, wait
a couple of minutes for the logs to flush, and check the IIS web log for detailed information. ( log files are normally here: %systemroot%
\system32\logfiles\w3svc1\* , the most recent dated file is the one with the latest errors )

-rwg
This is what I think, not necessarily what is accurate!

--------------------
| Content-Class: urn:content-classes:message
| From: <an*******@discussions.microsoft.com>
| Sender: <an*******@discussions.microsoft.com>
| References: <84****************************@phx.gbl>
| Subject: 500.100 internal server error
| Date: Sun, 7 Mar 2004 19:09:37 -0800
| Lines: 11
| Message-ID: <5c****************************@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQEuspSnWwxiJ6BTOC7k2Nxji9m7Q==
| Newsgroups: microsoft.public.inetserver.asp.general
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.asp.general:267712
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.inetserver.asp.general
|
| Hi Rob
|
| Nothing -- I still get the same 500.100 Internal Server
| Error - ASP Error.
|
| HTML works fine
|
| I am using Windows XP Professional with IIS
|
| Thanks
|
|
Jul 19 '05 #4

P: n/a
Ben
Hi Rob!

Here's what I've got
<!--ERROR CODE-->
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed
/records.asp, line 12
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)

Page:
GET /records.asp

and this is line 12 of "records.asp"

<!--LINE 12 RECORDS.ASP-->

record.ActiveConnection = MM_record_STRING;

so....what can we come up with?

Thanks

Ben
Jul 19 '05 #5

P: n/a
rwg
Hello Ben:

At this point, we know that IIS and ASP are working and the issue is in the open of the Connection to the database. ODBC is setting the Internal Error
status.

Things that can cause this are invalid database filename (if you are using a database such as Access), invalid server name (if you are using a database
such as SQL), invalid password, or not having the NTFS rights to access the file. I suppose this could also be from a corrupt database file. I have read
that someone got this message because their Access database was open and locked by another application.

You could use Filemon from www.sysinternals.com to see if it's a NTFS permission issue. Restart IIS, start filemon recording, recreate your error, review
Filemon log for Access Denied. If it's a permission issue, you wioll want to authorize IUSR_machinename and IWAM_machinename account to have
access to the file.

A problem isolation helper would be to print the connection string before the failure point.

Depending on your software levels, you may need to update your MDAC, see FIX: Setting of Connection Attribute Fails When You Use Connection
http://support.microsoft.com/?id=822841

-rwg
This is what I think, not necessarily what is accurate!

--------------------
| Content-Class: urn:content-classes:message
| From: "Ben" <be********@inspire.net.nz>
| Sender: "Ben" <be********@inspire.net.nz>
| References: <84****************************@phx.gbl> <5c****************************@phx.gbl> <TJj7v0QBEHA.660
@cpmsftngxa06.phx.gbl>
| Subject: RE: 500.100 internal server error
| Date: Thu, 11 Mar 2004 16:40:18 -0800
| Lines: 28
| Message-ID: <88****************************@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcQHypeGr6hxBkUjS6aZBtaDXAff1A==
| Newsgroups: microsoft.public.inetserver.asp.general
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.asp.general:268159
| NNTP-Posting-Host: tk2msftngxa14.phx.gbl 10.40.1.166
| X-Tomcat-NG: microsoft.public.inetserver.asp.general
|
| Hi Rob!
|
| Here's what I've got
| <!--ERROR CODE-->
| Error Type:
| Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
| [Microsoft][ODBC Driver Manager] Driver's
| SQLSetConnectAttr failed
| /records.asp, line 12
|
|
| Browser Type:
| Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
|
| Page:
| GET /records.asp
|
| and this is line 12 of "records.asp"
|
| <!--LINE 12 RECORDS.ASP-->
|
| record.ActiveConnection = MM_record_STRING;
|
| so....what can we come up with?
|
| Thanks
|
| Ben
|
Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.