I'll have to search on that MSKB article again, and post a link.
On one hand I understand what you're getting at re automating Office, but on
the other hand I'm still puzzled. In the intranet scenario I described,
there's no way any of the webform apps would be run with no one logged in.
That defies the very purpose, ie, for users to view production statistics
relevant to their particular operation (or all stats for upper level
managers)-- this access is restricted by function. It would operate much
like many of the industrial web apps out there, only specifically in an
intranet environ. Log in, click a few SQL parameters, export a report.
Done. Using Winforms is problematic due to security issues here: IT is
antagonistic toward developers like myself which means odds are I will never
have the rights to install a Windows app, nor will they manage that effort.
Which means that, up until now, this sort of activity has been done in ad
hoc "cowboy" fashion and that is what I'm trying to avoid. Too many
unmanaged and unsupported Access and Excel "applicatio ns" here. I want to
do better.
To me the original premise was so simple I'm blown away by what I've
encountered. All I wanted was to enable users to log in, see their metrics,
and generate a report that could be shared in meetings (we typically use
Excel and Powerpoint for this). The work involved is right now so
cumbersome and prone to error that automating it is not only a luxury but
pretty much a necessity. When I agreed to develop this it seemed like such
a straightforward application, based on what's seen all over the Internet,
so I dived right in. Now I'm disillusioned, and perplexed by how other
developers pull off what they do in web apps. The only thing I can hope for
now is that the Aspose products work as advertised, and that the manager
here will come up with the cash for them...
Randall
"Jim Cheshire" <no*****@none.c om> wrote in message
news:Oc******** ******@TK2MSFTN GP10.phx.gbl...
Randall Arnold wrote: The suggestion to run CACLS was in the form of numerous commands that
added user rights via a batch file run on the desktop, not from the
web page per se. This was in order to allow IIS to execute aspx
pages on the desktop. I don't recall the exact error, but a google
search on it led me to (brace yourself) an MSKB article that
purported to have the fix. I dutifully performed the suggested steps
(create DOS batch file with CACLS commands) that Microsoft
delineated. Each execution was followed by a system message that
nothing happened. The other suggestion was to add the username
attribute. Visual Web developer's server says the attribute is
invalid.
Can you tell me what KB article? I'll have a look and get it updated or
pulled if it's misleading.
As for Office not being designed to be automated as I am attempting,
then what are Interops for? What's with all the advertisements
alluding to such a capability? Where is Office going next-- seeing
as how at least one (ahem) MS competitor is poised to offer this sort
of thing (and then some)?
Interop is for calling COM components from managed code. You can certainly
use interop to automate Office from a Windows app. However, Office
applications are not designed for automation in a non-interactive
environment. If a competitive product is going to offer that, I'd watch
out. It's a design nightmare and a bad decision on their part in my
opinion. Applications with a UI should not be automated via a Web
application.
One other thing you might want to keep in mind. Web applications should
ALWAYS be designed to run with no one logged in at the console. Give that
a thought and you might understand better what I'm talking about. This is
not an ASP.NET design issue. :)
--
Jim Cheshire
=============== =============== ==
Blog: http://blogs.msdn.com/jamesche
Latest entry:
Getting the PID and TID of a COM Call
Describes how to get the PID of the
dllhost process a COM call is executing
in and how to locate the thread as well.