|
|
|
|
|
|
| |
A Better World
By Design |
| |
|
|
|
AaronOutpost : ASP /
FAQ and Error Message |
|
|
FAQ and Error Messages
By: Aaron B. Copyright AaronOutpost.com
First Off,
you need to Turn OFF Friendly Error Messages ASP
FAQ
DATABASE FAQ
| The page cannot be displayed. HTTP
500 - Internal server error |
| To
be able to determine what the problem is, you need
to turn off friendly error
messages. Microsoft,
being the geniuses they are, made friendly error
messages for the belayed person. Well that's not
you anymore! |
| ASP Scripts
won't Work - MOST common
problem |
| ASP
Scripts have to be run on an ASP enabled server. They
cannot be run on your PC by opening the files. If
you need more info on what ASP means read the
What
is Active Server Pages article.
Servers: If
you are unsure if your server will run the
program, look at any FAQ or
support pages that the provider may have or contact the administrator and ask them is
ASP will run on it. CGI and Pearl compatibility has nothing to do with ASP. ASP is totally
different.
Databases: Does the
script use an Access Database (.mdb) file? If the script uses a database and is not running
correctly then you may want to check the, ASP script uses an Access database
and it doesn't work right, FAQ.
|
| Will
ASP run on my web site? |
|
I don't know. If
you are unsure you need to contact your server
administrator or view any documentation they may
have listed. If you are planning on being the server
then you can setup your computer to be the server. CGI and Pearl compatibility
has nothing to do with ASP. ASP is totally
different. How to Install ISS
|
| ASP script uses an Access database
and it doesn't work right |
More then likely server
permission are not setup correctly or an invalid
database connection has been made.
Setting
up Server Permissions If you are the
server:
|
| The Graphical or Session Hit
Counter doesn't work correctly |
 If the ASP script
is not running correctly and is either not
displaying a counter number or not incrementing
the number then check that you have sufficient
permissions to allow ASP scripts write as well as
execute.
If you are running
off another server, you need to look at any FAQ or
support pages that the provider may have or contact the administrator
on how you can change permissions. If you connect
to server using FTP, many servers allow you to
change the permissions using COMMAND:> SITE CHMOD.
Many programs, this is obtained by right
clicking a directory
and clicking change
file attributes and simply checking
what permissions
you want to allow.
If you are running the
server yourself and use the
NTFS file system then read
Setting up the Correct
Permissions on the
Server.
|
| What are session cookies? |
| Session
cookies are very similar to normal cookies except
they are deleted about 20 after leaving site or
when you close your web browser. Many websites use
session cookies, especially members sites, email,
or any site requiring a username and password.
To check that you have cookies and
session cookies enabled in Internet Explorer go to
Tools
then Internet
Options
Under the Security
Settings you have a
button for Custom
Level Check to see if
you have cookies and session cookies enabled.
|
Cannot update. Database or object is read-only.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot update.
Database or object is read-only. |
Error usually occurs when trying to insert data into or update
data in an Access database. You don't have sufficient permissions
to write to the database.
You're the Web Server:
Setting up the Correct Permissions on the Server.
You're Not the Server: None of my scripts use a DSN
connection to the database. Look at any FAQ or support pages that
the provider may have or contact the administrator to see if they
support DSN-less connections. Also check what version of Access
they support.
Web space provider may need to change the
permissions on the server. If so, I would find a new server, these
permissions should already be allowed, you need a server with
maximum capabilities that you can have fun with! |
Data Type
Mismatch in criteria Line #.
|
 This
occurs when you have wrong data type set in the database for the
operation that you have chosen to run.
For example, you have it set to Text
instead of number.
|
Operation must use an updateable query
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an
updateable query. |
This error usually happens when you try to insert data into or
update data in an Access database. It means that you don't have
sufficient permissions to write to the database.
You're the Web Server:
Setting up the Correct Permissions on the Server.
You're Not the Server: None of my scripts use a DSN
connection to the database. Look at any FAQ or support pages that
the provider may have or contact the administrator to see if they
support DSN-less connections. Also check what version of Access
they support.
Web space provider may need to change the
permissions on the server. If so, I would find a new server, these
permissions should already be allowed, you need a server with
maximum capabilities that you can have fun with! |
General error Unable to open registry key
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to
open registry key 'Temporary (volatile) Jet DSN for process 0x6cc
Thread 0x78c DBC 0x144cfc4 Jet'. |
This error can happen for a number of reasons the main reason
being if the path to the database is incorrect.
You need to check that the path to the database is correct (You
must use the physical path on the server to the database and not a
virtual path).
The error is also quite common if the permissions on the server
are incorrect. Check that IIS has sufficient permissions to access
the registry and that the correct permissions, read and write, are
set on the directory containing the database and the database
itself, for the IUSR account. |
Could not find file
Microsoft JET Database Engine (0x80004005)
Could not find file 'C:\Inetpub\wwwroot\databaseName.mdb'. |
Usually when the database file can not be found. This usually
occurs if the path to the database is incorrect.
You need to check that the path to the database is correct (You
must use the physical path on the server to the database and not a
virtual path). |
Could not use '(unknown)'; file already in use
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Could not use
'(unknown)'; file already in use. |
Usually means that either incorrect permissions are set on the
server or the incorrect version of MDAC (Microsoft Data Access
Components installed on the server or the version is not correctly
installed). You need to ensure the ODBC version you have is 4 or
greater.
You're the Web Server:
Setting up the Correct Permissions on the Server
or Checking
ODBC Access Database Drivers.
You're Not the Server: None of my scripts use a DSN
connection to the database. Look at any FAQ or support pages that
the provider may have or contact the administrator to see if they
support DSN-less connections. Also check what version of Access
they support.
Web space provider may need to change the
permissions on the server. If so, I would find a new server, these
permissions should already be allowed, you need a server with
maximum capabilities that you can have fun with! |
Table 'ConfigTbl' is exclusively locked by user 'Admin' on machine
'MyMachine'
Microsoft JET Database Engine error '80004005'
Table 'ConfigTbl'
is exclusively locked by user 'Admin' on machine 'MyMachine'. |
This error means that you are either unable to open the table or
that you already have the table open in
'Design View' in Microsoft Access.
Close Access and try again. |
Too few parameters. Expected 1
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters.
Expected 1. |
This error occurs only with Microsoft Access when one of the field
names used in a select statement does not exist in the table being
queried.
Check that your SQL query is correct and that you have not
misspelled any of the field names in your select statement and
that the field name exists in the table being queried. |
Either BOF or EOF is True, or the current record has been deleted
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been
deleted.
Requested operation requires a current record. |
This is a recordset error. It means that you have tried to read
into a variable or display in a web page a record from the
recordset that has either been deleted or does not exist.
The most common occurrence of this error is if you have run a
database query that has not returned any records and you have then
tried to read in a record from the recordset that contains no
data.
You need to first check that there is a record in the recordset
before reading it in (eg. 'If NOT
rsRecordSet.EOF Then'). |
Item cannot be found in the collection corresponding to the
requested name or ordinal
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the
requested name or ordinal. |
This like the error above is a recordset error. You have tried
requesting a field from the recordset that does not exist.
Check when you are reading in the field from the recordset into a
variable or to display in a web page that you have spelt the field
name correctly and that the field exists in the database. |
The search key was not found in any record.
Microsoft JET Database Engine (0x80004005)
The search key was not found in any record. |
This error often means that the database has become corrupted.
To correct the error the database needs to be repaired. If the
database is on a remote server download the database and follow
the instructions below to repair the database.
- Open the database in Microsoft Access
- Click on the
'Tools' menu
- Select 'Database
Utilities
- Compact and Repair Database'.
|
|
|
|
AaronOutpost : ASP /
FAQ and Error Message |
|
Navigation
