Last post Jun 10, 2009 10:12 AM by Thomas Sun – MSFT
Jun 05, 2009 09:56 AM|satishreddy|LINK
I Have a situation in project where i need to use a VB6 program which will process some excel sheets and insert data into my database.. when i run the exe of the VB6 application it is running fine without any errors. But in my situation i need to call this
exe from my ASP.NET application. when i run this exe throught asp.net application i am getting some errors. The same VB6 exe and the same ASP.NET application is working good in my development machine but after deploying into the production it started giving
The following are the errors that i am getting..
Error Number = -2147023170 Error Description = Automation error
The remote procedure call failed.
Error Number = 462 Error Description = The remote server machine does not exist or is unavailable
Open Actual Files D:\BSC\PNL\actual\Celcom_PNL_BSC_Jan 2009.xls
1004 Failed to open source files.
Can anyone please guide me where i am going wrong..
Thanks in advance,
Visual Studio 2008
.net framework 3.5
Jun 05, 2009 09:54 PM|Bruce L|LINK
Oh boy.. a lot of things can cause this problem.
The first thing I would try is to either change your app pool identity to a user account w/ more permission than the Network service account. I suspect the Network service account do not have adequte permission.
Jun 06, 2009 08:36 AM|satishreddy|LINK
First of all Thanks for replying... I have tried using the adminstrator also, but still i am having same error.. [:(]
Jun 10, 2009 10:12 AM|Thomas Sun – MSFT|LINK
To narrow down the issue, please try to deploy it on iis of your development machine. If it also has same issue, please make sure your ASP.NET process identity has permission on "D:\BSC\PNL\actual\Celcom_PNL_BSC_Jan 2009.xls". When project is running from
Visual Studio, its identity is the account that logs in your system, and it is IIS account while running from IIS. The later one has low permission by default.
If this doesn't help you, please clarify what function of EXE is. Does it need to access remote resource? If so, the identity also needs permission to access it.
I look forward to receiving your test results.