Difference between revisions of "ASP Errors"

Latest revision as of 17:37, 22 November 2012

ASP 80004005 Error

You should change the connection string so that it includes the user ID and password even if no user ID or password is required.

Example:

If using a DSN:
MyConnection_STRING = "dsn=MyDSN;uid=;pwd=;"

Without a DSN:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\your_path\mydb.mdb;User Id=admin;Password=;"

ASP 80040e57 Error

Make sure you are inserting numeric values into a numeric column, and that it doesn't exceed the capacity of the column.
For example, 3,000,000,000 won't fit in a standard Access numeric (or SQL Server INT) column.

Assembly does not allow partially trusted callers

Problem: You receive the following error when your application attempts to use method, class, etc. from a DLL assembly in your /bin folder -

"SecurityException: That assembly does not allow partially trusted callers

Cause: We run .Net 2.0/3.5 with a modified medium trust policy for security. This requires that assemblies must specify that they allow partially trusted callers to be called from your code."

Solution -

You must add an assembly directive to your application so that it allows partially trusted callers.

If you are using C#.Net, the following line must be added to your assembly(generally in the AssemblyInfo.cs file) -

[assembly:System.Security.AllowPartiallyTrustedCallers]

If you are using VB.Net, the following line must be added to your assembly(generally in the AssemblyInfo.vb file) -

Assembly: AllowPartiallyTrustedCallers() Surrounded by "<>" without quotes.

Once the directive has been added, you will need to recompile the DLL and upload it to your /bin folder.

800a01fb error

Generally, the recordset was not closed properly. Try the following, making the needed changes for your variable names:

if not isObject("objRS") then
set objRS=Server.CreateObject("ADODB.RecordSet")
end if
if objRS.state <> 0 then
objRS.close
end if
objRS.Open strTableNameOrSQL,objConnection

Login failed for user -null- Reason: Not associated with a trusted SQL

The resolution is to add "Trusted_Connection=False to the web.config as shown below. At this point it works fine and uses the integrated security from SQL 2005 in a SQL 2000 database.

connectionString="Data Source=myInternalServerIP;
Initial Catalog=myDatabseName;
Integrated Security=True;
User ID=myUserName;
Password=myPassword;
Trusted_Connection=False"/>