Question about VB.net to access
I currently have a VB.Net program that connects to a excel workbook.
Works great locally but when I run a time triggered scheduled job through report manager on the server; I get an error. The error is:
ComException (0x800A03EC) "FilePath\File" Could not open excel or File path not found.
I also get a similar issue with Win automation and a triggered task.
I understand that this is a common exception for running the
Interop.Excel. I believe this has something to do with the security permissions that the program receives in running under a scheduled tasks instead of an actual user id.
My questions are:
1. Can this error be fixed? I have not found any research that
supports this. If so, How?
Thank you in advance for your comments. I apologized if this is the wrong forum for this question, I didn't know where else to put this topic.
How are you starting it? Is it from a Scheduled Task or service?
It is running as a scheduled task in Report manager of SQL server 2005.
Is it possible to run is as a windows scheduled task?
Last Post: 04-25-2008, 11:40 AM
By Gliff in forum VB Classic
Last Post: 12-16-2007, 03:03 PM
By trains58554 in forum Database
Last Post: 10-27-2007, 06:00 AM
By alaska_eric in forum VB Classic
Last Post: 03-15-2005, 04:31 PM
By thomas555 in forum VB Classic
Last Post: 08-31-2002, 06:15 AM
Tags for this Thread
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL