Difference between revisions of "ASP Errors"
| (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== | |
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
Contents
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"/>