Internal Server Error

[Rich R]

I have just brought up a web site using an MDB file on a
Win 2003 system and I am getting the message:
HTTP 500 - Internal server error
Internet Explorer
I know it's the access data base giving me the problem as
I will wait a while and then try the page again and the
information displays. I have check the permissions
assigned to the file and Modified is available for the
IUSR account.

I am unable to get the actual error message to show
although I have set all of the debugging options checked.

I have a feeling that I haven't installed some MS software
to allow me to see the errors and possibly some MS Access
software to manage the data base. I have installed SQL
server 2000 SP3a.

Does anyone have a suggesstion?

[Aaron Bertrand - MVP]

> I am unable to get the actual error message to show

> although I have set all of the debugging options checked.

This has nothing to do with debugging.
[url]http://www.aspfaq.com/2109[/url]

[Aaron Bertrand - MVP]

Try using an OLEDB connection string, and making sure you have the most
recent version of MDAC and the JET drivers. See the following articles:

[url]http://www.aspfaq.com/2126[/url]
[url]http://www.aspfaq.com/2342[/url]

[url]http://www.aspfaq.com/2009[/url]






"Rich R" <rich@richware.net> wrote in message
news:02d101c347d4$6a3b35d0$a101280a@phx.gbl...

> Thanks Aaron,
>
> After making that adjustment, I am now getting the
> following error:
>
> Provider error '80004005'
>
> Unspecified error
>
> /includes/config.asp, line 11
>
> Line 11 is:
> dbc.open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="
> & server.MapPath("\mdb\oms2000.mdb"))
>
> Am I missing a driver or something? If I am able to open
> and access the data base and get the proper results and
> then make another request to the data base and get the
> above message I have a hard time beliving a driver is
> missing.
>

> >-----Original Message-----

> >> I am unable to get the actual error message to show
> >> although I have set all of the debugging options

> checked.

> >
> >This has nothing to do with debugging.
> >[url]http://www.aspfaq.com/2109[/url]
> >
> >
> >.
> >

[Aaron Bertrand - MVP]

> dbc.open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="

> & server.MapPath("\mdb\oms2000.mdb"))

Once again, try using an OLEDB connection string. See the articles I
pointed out earlier. Also, when using Server.Mappath, the slashes should be
FORWARD slashes.

> Set rsMember=Server.CreateObject ("ADODB.Recordset")
> Set rsBug=Server.CreateObject ("ADODB.Recordset")
> Set rsDownload=Server.CreateObject ("ADODB.Recordset")
> Set rsSuggestion=Server.CreateObject ("ADODB.Recordset")

UGH! Why do you think you need four separate, explicit recordset objects?

[silesius]

Hi all,
I'm new to asp.net and are just working on a few examples to get some
practice. The following is a simple webservice with two web methods. The
HowMuchWillItCost method works fine the GetProductInfo method returns http
500 internal server error. Maybe someone could tell me what am I doing
wrong?
I suspect it has something to do with connecting to the DB but can't figure
out what exactly is causing the error.
TIA
Rich

[WebMethod]
public decimal HowMuchWillItCost(string productName, int howMany)
{
try
{
OleDbConnection oleDbConn = new OleDbConnection ("Jet OLEDB:Global Partial
Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data
Source=C:\\Documents and Settings\\Richard\\Desktop\\db2.mdb;Jet
OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:System
database=;Jet OLEDB:SFP=False;persist security info=False;Extended
Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet
OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on
Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User
ID=Admin;Jet OLEDB:Global Bulk Transactions=1");
OleDbCommand oleDbCmd = new OleDbCommand();
oleDbCmd.CommandText = "SELECT UnitPrice FROM Products WHERE ProductName =
'" + productName + "'";
oleDbCmd.Connection = oleDbConn;
oleDbConn.Open ();
decimal price = (decimal)oleDbCmd.ExecuteScalar();
oleDbConn.Close ();
return price * howMany;
}
catch(Exception e)
{
throw new Exception ("Error calculating cost: " + e.Message );
}
}
[WebMethod]
public Product GetProductInfo(string productName)
{
Product product = new Product ();
try
{
OleDbConnection oleDbConn2 = new OleDbConnection ("Jet OLEDB:Global Partial
Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Data
Source=C:\\Documents and Settings\\Richard\\Desktop\\db2.mdb;Jet
OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:System
database=;Jet OLEDB:SFP=False;persist security info=False;Extended
Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet
OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on
Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User
ID=Admin;Jet OLEDB:Global Bulk Transactions=1");
OleDbCommand oleDbCmd = new OleDbCommand ();
oleDbCmd.CommandText = "SELECT * FROM Products WHERE ProductName = '" +
productName + "'";
oleDbCmd.Connection = oleDbConn2;
oleDbConn2.Open ();
OleDbDataReader productData = oleDbCmd.ExecuteReader ();
if (productData.Read ())
{
product.ProductID = productData.GetInt32(0);
product.ProductName = productData.GetString(1);
product.SupplierID = productData.GetInt32(2);
product.CategoryID = productData.GetInt32(3);
product.QuantityPerUnit = productData.GetString(4);
product.UnitPrice = productData.GetDecimal(5);
product.UnitsInStock = productData.GetInt16(6);
product.UnitsOnOrder = productData.GetInt16(7);
product.ReorderLevel = productData.GetInt16(8);
product.Discontinued = productData.GetBoolean(9);
}
else
{
throw new Exception ("Product " + productName + " not found");
}
productData.Close ();
oleDbConn2.Close ();
return product;
}
catch(Exception e)
{
throw new Exception ("Error finding product: " + e.Message );
}

[illufox]

I've created a record insertion form with the help of the Application 'Insert'
options. The record set test normally, so does the database connection. The
form contains several menus which are supposed to list data from other tables
than the one in recordset 1. However after creating a second redordset and
testing the page I get the following error: Error Type: Microsoft OLE DB
Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access
Driver] Could not use '(unknown)'; file already in use.
/spaces/events/Test.asp, line 144 I've tried this several times but everytime
I get the same error. I tested the connection, and both recordsets, everything
is fine. What am I doing wrong?

[Kindler Chase]

illufox wrote:

> I've created a record insertion form with the help of the Application
> 'Insert' options. The record set test normally, so does the database
> connection. The form contains several menus which are supposed to
> list data from other tables than the one in recordset 1. However
> after creating a second redordset and testing the page I get the
> following error: Error Type: Microsoft OLE DB Provider for ODBC
> Drivers (0x80004005) [Microsoft][ODBC Microsoft Access Driver] Could
> not use '(unknown)'; file already in use. /spaces/events/Test.asp,
> line 144 I've tried this several times but everytime I get the same
> error. I tested the connection, and both recordsets, everything is
> fine. What am I doing wrong?

Sounds like you are testing locally and have the database in your defined
site of DreamWeaver (DreamWeaver locks up your database if it's within your
defined site). Move the database outside your defined site, re-create the
connection, close and restart DreamWeaver and try again.

--
kindler chase
[url]http://www.ncubed.com[/url]
Home of SuperInvoice's Fortress of Solitude

[url]news://news.ncubed.com/support[/url]
n3 Support Group

[illufox]

The database is in the same folder as all the web files and the Connection
folder. I have to work within this folder that has been assigned to me on the
server. Should I just move all the webfiles into a new folder withing the main
folder? This is strange because last year I built a web application the same
way and that one works just fine. I'm really confused....

[illufox]

Ok, I moved all the files into a new folder and left the database in the main
folder. I recreated the connection and restarted Dreamweaver. Now when I test
the application I get the following error (example of one page): Error Type:
Provider (0x80004005) Unspecified error /spaces/events/Database/login.asp, line
8 This is the line it's referring to: Recordset1.ActiveConnection =
MM_EventsDB_STRING I get the same error when adding a new recordset to the
insert record form page and it also points to the same line of code.... This
has been bugging me since two days and it keeps me awake at night.... :(

[illufox]

Also, the database is password protected. Could this be the problem for those
errors? Displaying data in a dynamic table and the search function work great.
Just when I add more than one recordset I get the error below. Thanks for your
help!

[illufox]

Just tried to add a second recordset to a record insertion form page in order
to create a dynamic form menu. When I refresh the page I get the same error as
before I moved the files into its own folder: Error Type: Microsoft OLE DB
Provider for ODBC Drivers (0x80004005) [Microsoft][ODBC Microsoft Access
Driver] Could not use '(unknown)'; file already in use.
/spaces/events/Database/insert2.asp, line 144 Line 144:
Recordset2.ActiveConnection = MM_EventsDB_STRING This is driving me nuts!!!!
I will be falling off my chair if somebody knows a solution for this...

[Kindler Chase]

illufox wrote:

> Just tried to add a second recordset to a record insertion form page
> in order to create a dynamic form menu. When I refresh the page I get
> the same error as before I moved the files into its own folder:
> Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
> file already in use. /spaces/events/Database/insert2.asp, line 144
> Line 144: Recordset2.ActiveConnection = MM_EventsDB_STRING This is
> driving me nuts!!!! I will be falling off my chair if somebody knows
> a solution for this...

Are you testing locally or on a live server?

--
kindler chase
[url]http://www.ncubed.com[/url]
Home of SuperInvoice: The Online Invoicing Application.
Organize your billing process and impress your clients.

[url]news://news.ncubed.com/support[/url]
n3 Support Group

[illufox]

I access all files directly on the local network, that's the only location of
the files I'm working on. Once I make changes to the files, the changes can be
seen immediatley online. What is interesting is that I did the same last
year with a different application. Same network, same Dreawmeaver version. I
expected this to be easy as everything worked so well last time. I compared
this application to the one from last year and couldn't find any differences.
Also, the recordsets and database connection test fine, and records display
normally. Just when I try to add more recordsets it goes bad.... I just wished
I knew what 'Could not use '(unknown)'; file already in use.' means...

[Kindler Chase]

illufox wrote:

> I access all files directly on the local network, that's the only
> location of the files I'm working on. Once I make changes to the
> files, the changes can be seen immediatley online. What is
> interesting is that I did the same last year with a different
> application. Same network, same Dreawmeaver version. I expected this
> to be easy as everything worked so well last time. I compared this
> application to the one from last year and couldn't find any
> differences. Also, the recordsets and database connection test fine,
> and records display normally. Just when I try to add more recordsets
> it goes bad.... I just wished I knew what 'Could not use
> '(unknown)'; file already in use.' means...

The file in use is because DW *is* using the db and has locked it up...

OK, Grab a cup of coffee and read this a few times - it'll help you in the
long
run, although it isn't exactly what you were asking, it will get you going.

To move you more into a proper testing environment, this is how I always
recommend setting up your system:

All your sites should be under one common folder, but never within the
Inetpub folder - just leave that area alone:

c:\sites (folder that contains everything)
\site 1
\site 1 files
\site 2
\site 2 files
\site 3
\site 3 files

So, a sample path to site 2 would be:
c:\sites\site 2\<files are here>

When using databases, do not keep them in the parent directory of the site,
rather, just plop them all into one common directory in the sites directory.
Why? Because DW will lock up the DB if you keep it within the defined site.
Read this thread for more info:
[url]http://tinyurl.com/68wc8[/url]

Your final directory strucutre will look something like this:

c:\sites (folder that contains everything)
\databases
\all db's are here
\site 1
\site 1 files
\site 2
\site 2 files
\site 3
\site 3 files


Now, when creating virtual sites in IIS, keep this in mind: you can not use
root relative path's for any of your links, images, etc... Why? Because the
root of the site is actually one directory above the virtual site.

So, the advantage of creating a virtual site is: a. you can easily access
the site with: [url]http://localhost/virtualSite/[/url]

The disadvantage of using virtual sites: a. you can not use root relative
links.

What to do? Easy enough:

When testing locally, you should change the IIS default home to the root of
the site you are currently working in, especially when using root
relative/virtual includes, root relative links, images, etc.... You already
know why (hint: virtual sites can not use root relativity). Here's how to
change the root for your site (this is for Win2k Pro, but should be similar
for XP):

1. Control Panel
2. Administrative Tools
3. Internet Services Manager
4. Expand to see 'default web site' and right click on 'default web site'
5. Properties
6. Home Directory Tab and then 'Browse' to the site's root folder.

In the above example, if you wanted to work on site 2, you'd simply browse
to c:\sites\site 1\ as the home directory and you can then test by simply
calling:
[url]http://localhost/[/url]

Everytime I work a different site, I just automatically go into IIS and
change the Home directory to the site I'm working on.

IMO, you shouldn't use virtual sites in IIS because they limit your ability
to work with root relativity... and to clarify, this would be for IIS on
win2k pro, winXP pro, but not win2k/3k Server which is designed to work with
virtual sites/root relativity.

--
kindler chase
[url]http://www.ncubed.com[/url]
Home of SuperInvoice's Fortress of BeanCounters

[url]news://news.ncubed.com/support[/url]
n3 Support Group

[griffeymac]

Hi folks! I just did a fresh install of RedHat ES 4.0 with Apache 2.0.52 and
MySQL.

Next I installed CFMX 7.

I was able to get to the administrator, and view a test .cfm page that I had
created.

Then it got goofy.... The machine has two NICs. At the time I was doing this
only one of them was active. After making the second one active as well, and
rebooting the machine, now I can't get to any ColdFusion page.

"Internal Server Error
The server encountered an internal error...."

Clicking refresh several times gets me these three lines in the error log:
[Tue Jul 11 15:34:04 2006] [notice] jrApache[2544: 24778] jrConnect: POLLHUP
so ECONNREFUSED
[Tue Jul 11 15:34:04 2006] [notice] jrApache[2544: 24778] 127.0.0.1:51011
connect failed: 111 111 Connection refused, no sock added to pool
[Tue Jul 11 15:34:04 2006] [notice] jrApache[2544: 24778] Couldn't initialize
from remote server, JRun server(s) probably down.

I shut down eth0 and rebooted but it is still giving me the same old grief.

(I guess my next step is to make eth0 live, like it will be in production, and
then reinstall CFMX??)

Thanks in advance for any advice!

G.--

[dlasley]

Two quick ones before we move on to the hard stuff:

Did you do a netstat -an | grep 51011 to make sure JRun was listening?

Are you by any chance using IPv6 modules, either intentionally or
unintentionally?

&laz;

[griffeymac]

Good morning (well, it's morning here...).

Thank you for the quick reply! I did netstat -an | grep 51011 and got nothing
back (just to make sure I did the correct thing I did it on the server that
CFusion is working on and it spit me back all sorts of stuff).

I'm afraid I don't know what IPv6 modules are (and I googled but still don't
exactly understand what they are or why I would be running them). I didn't
know how to check for them much more than "locate IPv6" and that turned up
nothing (on either machine in question).

So if I understand your line of thinking (and I guess the error message leads
us to this as well), it means that JRun isn't running.

And now we're approaching the limits of my understand of how all of this stuff
works. ;)

Mike

[griffeymac]

As this was a new installation of Apache and everything else, I decided to just
take 5 minutes and start over.

With both of my NICs running I just reinstalled:

rm -rf /opt/coldfusionmx7
rm -rf /web/CFIDE
rm /web/cfide

./coldfusion-70-lin.bin

Thanks again, dlasley, for the reply, but reinstalling only took a few
minutes, so I just figured I'd do that!

Thanks!

Mike

[dlasley]

Hey, that's cool - I've been known to solve things with a re-install myself :-)

&laz;