Difference between revisions of "ASP Errors"

From Hostek.com Wiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
__FORCETOC__
 +
 +
==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: <br/>
 +
MyConnection_STRING = "dsn=MyDSN;uid=;pwd=;"
 +
 +
Without a DSN:<br/>
 +
"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.<br/> 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==
 
==Assembly does not allow partially trusted callers==
  
Line 28: Line 47:
 
Once the directive has been added, you will need to recompile the DLL and upload it to your /bin folder.
 
Once the directive has been added, you will need to recompile the DLL and upload it to your /bin folder.
  
===800a01fb error===
+
==800a01fb error==
 
Generally, the recordset was not closed properly. Try the following,
 
Generally, the recordset was not closed properly. Try the following,
 
making the needed changes for your variable names:
 
making the needed changes for your variable names:
Line 42: Line 61:
 
</pre>
 
</pre>
  
 +
==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.
 +
 +
<pre>
 +
connectionString="Data Source=myInternalServerIP;
 +
Initial Catalog=myDatabseName;
 +
Integrated Security=True;
 +
User ID=myUserName;
 +
Password=myPassword;
 +
Trusted_Connection=False"/>
 +
</pre>
  
 
[[Category:Tutorials]]
 
[[Category:Tutorials]]

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