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