COM/MS-WORD automation printing problem

[Oracle9Guy]

I've written a number of PL/SQL procedures that successfully use the ORDCOM package to create a Word.Basic object, open a new MS-Word document, insert text into the document and then save it. Where I'm having a problem is when I go to print the document. It seems like I should just be able to call the "FilePrint" method while the document is open to get it to print on my default printer, however, I get the error message "Word cannot print. There is no printer installed." I also tried setting the "ActivePrinter" propoerty in the Word object, but this didn't make any difference.

I'm using Oracle 9.2 on my Windows 2000 desktop. I do have a printer installed and I can print docs without a problem when running MS-Word interactively. The problem seems to be that the Word object instantiated via COM automation either can't see the printer settings already defined in Windows or needs its own definitions. I've done several several searches and can't find any references to this problem.

Anyone have any ideas???????????

 

[rchandr3]

This may sound absurd:

I think it tries to print from the Oracle Server and not on your local machine... If you think in this angle, that may lead you right?

Cheers,

Ravi

 

[Oracle9Guy]

No, it is trying to print locally.

Actually, I figured out the problem. I forgot that by default, the Oracle services are run by user "LocalSystem" which of course doesn't have any printers installed. As soon as I restarted the Oracle services with my user ID the FilePrint method starting acting as expected (i.e, printing the currently open document on my default printer).