500.100 internal server error

[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

[Rob Greene]

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
|
|

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

[Rob Greene]

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
|
|

[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

[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
|