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
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center