PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 1.00 average.

ComException 0x80410257 logging into DB from ASP

 
 
Forester1
Guest
Posts: n/a
 
      5th Aug 2008
Hi! I am upgrading a system from Win2k, IIS5, ApplicationXtender 5.25, and
ASP.Net 1.1.4 to W2k3, IIS6, AX5.4Sp1, and ASP.Net 2.0.5 by building a new
server. The server this is on connects to a remote SQL2000 server. Everything
works great except a piece of third party code that parses an xml request
from some proprietary software and uses it to query the AX database on the
SQL Server for an image. When it tries to log into the DB it gets the
following error on the web page:

[COMException (0x80410257): Unknown error 0x80004005
Unknown error 0x80004005]
Interop.AexDB.DBConnectionClass.Login(Object UserName, Object Password,
Object Provider, Object DSN, Object DbUserName, Object DbPassword) +0
AXDB.AXNetConnect.GetAXDocuments(String FieldValue) in
C:\dev\aspnet35\workspace\IndusAXProject\AXInterfaceLibrary\AXDB.cs:30
EDMSforIndus._Default.Page_Load(Object sender, EventArgs e) in
C:\dev\aspnet35\workspace\IndusAXProject\EDMSforIndus\Default.aspx.cs:22
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o,
Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

In addition, the following shows up as an application Event Warning (IP
address removed):

Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 8/4/2008
Time: 2:23:57 PM
User: N/A
Computer: HALOIDTEST
Description:
Event code: 3005 Event message: An unhandled exception has occurred. Event
time: 8/4/2008 2:23:57 PM Event time (UTC): 8/4/2008 8:23:57 PM Event ID:
b7e12afd7279497686ac473ff172a6b6 Event sequence: 3 Event occurrence: 1
Event detail code: 0 Application information: Application domain:
/LM/W3SVC/1/Root/Indus-1-128623550369347515 Trust level: Full
Application Virtual Path: /Indus Application Path:
c:\inetpub\wwwroot\Indus\ Machine name: HALOIDTEST Process
information: Process ID: 2928 Process name: w3wp.exe Account
name: NT AUTHORITY\SYSTEM Exception information: Exception type:
COMException Exception message: Unknown error 0x80004005
Unknown error 0x80004005 Request information: Request URL:
http://haloidtest/indus/default.aspx Request path: /indus/default.aspx
User host address: xxx.xxx.xxx.xxx User: Is authenticated:
False Authentication Type: Thread account name: NT
AUTHORITY\SYSTEM Thread information: Thread ID: 1 Thread account
name: NT AUTHORITY\SYSTEM Is impersonating: False Stack trace:
at Interop.AexDB.DBConnectionClass.Login(Object UserName, Object Password,
Object Provider, Object DSN, Object DbUserName, Object DbPassword)
at AXDB.AXNetConnect.GetAXDocuments(String FieldValue) in
C:\dev\aspnet35\workspace\IndusAXProject\AXInterfaceLibrary\AXDB.cs:line 30
at EDMSforIndus._Default.Page_Load(Object sender, EventArgs e) in
C:\dev\aspnet35\workspace\IndusAXProject\EDMSforIndus\Default.aspx.cs:line 22
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object
o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender,
EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

I have tried to permission this every way from Sunday, including web
permissions, directory permissions, registry permissions, etc etc for every
conceivable service from aspnet to iusr to system to network service to no
avail. The third party programmer is trying to blame it on our baseline
security group policies, but the server has been removed from the baseline,
and should be restored to normal. It works on his test system, so he is at a
loss to figure it out. It works on our old system just fine, but he has
reprogrammed some of the code for the new server. He gets the UserName and
UserPassword from web.config. The connection in the application is set to
connect via OLE DB. Below are the lines that seem to be failing (AXDB.cs:30):

DBConnection oAEXDB = new DBConnectionClass();

//oAEXDB.RegistryKey =
@"\HKEY_CURRENT_USER\SOFTWARE\XtenderSolutions\ApplicationXtender\Database";
oAEXDB.Login(ConfigurationSettings.AppSettings["AXUser"],
ConfigurationSettings.AppSettings["AXPass"], Type.Missing, Type.Missing,
Type.Missing, Type.Missing);

Here are the settings from web.config (password removed):

<appSettings>
<add key="appname" value="AP_INVOICES"/>
<add key="fieldcolumn" value="8"/>
<add key="fieldvalue" value="*"/>
<add key="AXUser" value="sysop"/>
<add key="AXPass" value="xxxxxxxx"/>
</appSettings>


ApplicationXtender itself works fine on this server, as does the sysop
login. The code from the old server copied over to this server gets the same
error, making me believe it is a difference of IIS6 and /or APS.Net 2.0.5.
Would "Is authenticated: False" or "Is impersonating: False" have anything to
do with it, and if so, how would i fix that? Does anybody have a clue? Thanks
in advance!

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
COMException Jennifer Microsoft Outlook VBA Programming 11 23rd Apr 2007 04:46 PM
COMException =?Utf-8?B?SnVsaWE=?= Microsoft ASP .NET 0 17th Jan 2006 08:57 PM
ComException -- Please help =?Utf-8?B?SmFrZQ==?= Microsoft Dot NET Compact Framework 2 10th May 2005 12:26 AM
Re: ComException !! Nick Malik Microsoft Dot NET Framework 1 21st Jul 2004 06:27 PM
COMException is Raised =?Utf-8?B?U2FiaQ==?= Microsoft ASP .NET 2 9th Jul 2004 02:01 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:39 PM.