473,388 Members | 1,207 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

Excel Interop "No printers are installed" error

I have a VB.NET console application that uses the Excel PIA. I set it up to
run on a W2K box through Task Scheduler, under a domain account that has
rights to all of the resources the app uses. I can run this application on
my local XP machine with no problem. However, on the W2K machine I received a
"No printers are installed" error:

System.Runtime.InteropServices.COMException (0x800A03EC): No printers are
installed.

The app sets the workbook's LeftFooter attribute, which of course requires
that a printer be set up on the machine. There are not one, but six printers
set up on the W2K box, with a network printer set as the default. The
Everyone group has rights to this printer. Why can my application not see
this? What can I do to correct this error?

TIA,

--
Phil Hegedusich
Senior P/A
IIMAK
----
A skeleton walks into a bar and says, "I need a beer and a mop."
Jul 18 '06 #1
1 16639
Solved, and it wasn't a problem with the interop; it was a context and
permissions situation. The account running the AT didn't have a printer in
its profile. I ran the job under the user with the printer assigned, which
corrected that problem. I also had to give it rights to the data involved,
but that's a story for another day.
Jul 19 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Raquel | last post by:
Have installed UDB PE V8.0 on Win XP and wrote a JDBC program using driver com.ibm.db2.jcc.DB2Driver. At run time, it throws error "No Suitable Driver". Why is it? When I use JDBC-ODBC bridge...
4
by: amywolfie | last post by:
I would like to put code behind a Find button on a form which: 1) Performs a find based on a field on the form 2) If NO RECORDS ARE FOUND, then displays a custom "No Records Found" message box. ...
0
by: feng | last post by:
Hi, I am having a strange problem right now and I don't even know how to go about it. Someone please help me! Any inputs will be highly appreciated. We have an application that has a VB.Net...
1
by: Amedee Van Gasse | last post by:
I have written a small vb.net app that creates a Word and an Excel file. I referenced Word, Excel and Office as COM-components. The app does not work on a pc where Word or Excel are not...
1
by: scottmachado | last post by:
I am currently running a marco that run a query and emails the results as an attachment in excel format. If the query has no records, I would like to email "no records found" in the first cell in...
0
by: JymBoe | last post by:
I have built a Web Service with a multi-table dataset. When I attempt to discover the Web Service, I get an error saying "ItemsRow has no parameterless constructor" where ItemsRow is a row in the...
2
by: emallove | last post by:
I'm running into the below "No modules named _sha256" issue, with a python installed in a non-standard location. $ python Python 2.5.2 (r252:60911, May 20 2008, 09:46:50) on linux2 Type...
1
by: indikamaligaspe | last post by:
Hi all, I am trying to get a PL/TCL trigger to update an audit table working. The problem is when I create the trigger on an exiting table, I get the following error "ERROR: can't read...
1
by: mitica grigore | last post by:
hello i use an access 2002-2003 database under an access 2007 environment and win xp sp3 i have about 24'000 records so far sometimes, when i try to use "back-up database" or "compact & repair...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.