Windows Vista Forums
Vista Forums Home Join Vista Forums Tech Publications Windows 7 Forum Vista Tutorials Webcasts Tags

Welcome to Vista Forums we are your forum for Windows Vista help and discussion. Whether you need help or just want to post an idea you have on Vista, this is the forum for you.
Register at Vista forums...the world biggest Windows Vista resource Join Vista Forums Now

Go Back   Vista Forums > Vista Newsgroups > Vista security

Script Host Client launched from Windows Service

Update your Vista Drivers
Reply
 
Thread Tools Display Modes
Old 06-27-2007   #1 (permalink)
DavidRF
Guest


 

Script Host Client launched from Windows Service

Hello,

I have a client/server application that launches a Script Host application
from a Windows Service. The Script Host application launches Excel and opens
an xls file for processing.

This works on Windows 2000 and Windows XP, but on Vista we get an error from
Excel saying "cannot access the file: C:\foo.xls, there are a number of
possible reasons". The Script Host application works fine on Vista by
itself, but when launched from a Windows Service it does not have permission
to read the xls file.

Does anyone have any ideas as to what the problem may be? What extra things
do I need to do on Vista to get my Windows 2000/XP application to work?

Many thanks,
DavidRF



My System SpecsSystem Spec
Old 06-27-2007   #2 (permalink)
dmex's Avatar
ɠɛɐǨ



Join Date: May 2007
Windows Vista™ Ultimate
Fremantle, Western Australia
 
Rep Power: 118
dmex has a reputation beyond reputedmex has a reputation beyond reputedmex has a reputation beyond reputedmex has a reputation beyond reputedmex has a reputation beyond reputedmex has a reputation beyond reputedmex has a reputation beyond reputedmex has a reputation beyond reputedmex has a reputation beyond reputedmex has a reputation beyond reputedmex has a reputation beyond repute
  dmex is offline

Re: Script Host Client launched from Windows Service

You might need to change the service permissions to run under your user (careful), or you might no longer be able to run programs though a service because of the security restrictions.
My System SpecsSystem Spec
Old 06-27-2007   #3 (permalink)
Alun Jones
Guest


 

Re: Script Host Client launched from Windows Service

"DavidRF" <DavidRF@discussions.microsoft.com> wrote in message
news:204C40FC-B94F-4027-8BCC-7DBEB2574E0F@microsoft.com...
> I have a client/server application that launches a Script Host application
> from a Windows Service. The Script Host application launches Excel and
> opens
> an xls file for processing.
>
> This works on Windows 2000 and Windows XP, but on Vista we get an error
> from
> Excel saying "cannot access the file: C:\foo.xls, there are a number of
> possible reasons". The Script Host application works fine on Vista by
> itself, but when launched from a Windows Service it does not have
> permission
> to read the xls file.
>
> Does anyone have any ideas as to what the problem may be? What extra
> things
> do I need to do on Vista to get my Windows 2000/XP application to work?


I think your problem is most likely to be handled by the Microsoft Office
team by telling you that Office Automation was never designed to be run from
service applications, and must be run in an interactive session.

You may have gotten away with it in the past, simply because services shared
a lot with one of the interactive sessions - I think you will probably have
to find some other way to create your files than to use native Office
Automation.

Alun.
~~~~


My System SpecsSystem Spec
Old 06-27-2007   #4 (permalink)
DavidRF
Guest


 

Re: Script Host Client launched from Windows Service

"Alun Jones" wrote:

> "DavidRF" <DavidRF@discussions.microsoft.com> wrote in message
> news:204C40FC-B94F-4027-8BCC-7DBEB2574E0F@microsoft.com...
> > I have a client/server application that launches a Script Host application
> > from a Windows Service. The Script Host application launches Excel and
> > opens
> > an xls file for processing.
> >
> > This works on Windows 2000 and Windows XP, but on Vista we get an error
> > from
> > Excel saying "cannot access the file: C:\foo.xls, there are a number of
> > possible reasons". The Script Host application works fine on Vista by
> > itself, but when launched from a Windows Service it does not have
> > permission
> > to read the xls file.
> >
> > Does anyone have any ideas as to what the problem may be? What extra
> > things
> > do I need to do on Vista to get my Windows 2000/XP application to work?

>
> I think your problem is most likely to be handled by the Microsoft Office
> team by telling you that Office Automation was never designed to be run from
> service applications, and must be run in an interactive session.
>
> You may have gotten away with it in the past, simply because services shared
> a lot with one of the interactive sessions - I think you will probably have
> to find some other way to create your files than to use native Office
> Automation.


Thanks for the reply.

Just to clarify. The Windows Service process itself does not run
ScriptHost. The Windows Service spawns an independent ScriptHost executable
which reads the Excel file, processes it internally, and writes one or more
tab-delimited files which can be imported natively into our main application.
Its our way of integrated our application with Microsoft Excel, though we
are encountering the same ScriptHost/Automation problem with other programs
as well.

Has anyone run into the same problem? Is there some setting, flag, or
function argument than can be set so that Script Host processes launched by a
Windows Service can open files?

Thanks,
-DavidRF

My System SpecsSystem Spec
Old 06-27-2007   #5 (permalink)
Alun Jones
Guest


 

Re: Script Host Client launched from Windows Service

"DavidRF" <DavidRF@discussions.microsoft.com> wrote in message
news:1366F3F5-BB5A-47FB-B561-862D93BC5179@microsoft.com...
> Just to clarify. The Windows Service process itself does not run
> ScriptHost. The Windows Service spawns an independent ScriptHost
> executable
> which reads the Excel file, processes it internally, and writes one or
> more
> tab-delimited files which can be imported natively into our main
> application.


And ... the ScriptHost executable is running in _what_ session? The same
session as the service, with no access to an interactive user or a desktop.
Microsoft has repeatedly dictated that they do not support Office Automation
in anything other than an interactive desktop.

> Its our way of integrated our application with Microsoft Excel, though we
> are encountering the same ScriptHost/Automation problem with other
> programs
> as well.
>
> Has anyone run into the same problem? Is there some setting, flag, or
> function argument than can be set so that Script Host processes launched
> by a
> Windows Service can open files?


Every time I've tried to do Office Automation from a service in XP, it's
worked... more or less, most of the time. Every time I've asked Microsoft
for help, they've said "it was never meant to run from a service, that's
unsupported", so I've done it some other way.

That's not to say that there isn't a solution out there - just that I don't
think you'll get any officially sanctioned solutions, and unofficial
solutions have a habit of being wiped out by the next patch, the next
service pack, or the next release, so I avoid them as much as possible.

Alun.
~~~~


My System SpecsSystem Spec
Reply
Update your Vista Drivers

Thread Tools
Display Modes



Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows Host Service (Rundll32) has stopped working. Danny McCormick Vista performance & maintenance 2 06-22-2008 03:52 PM
Windows Script Host has no script engine for ".js" files Stephan G. Vista General 9 04-24-2008 04:04 PM
Windows Script Host polefroggy Vista performance & maintenance 0 10-23-2007 11:42 PM


Complimentary Industry Resources

Vista Forums has joined forces with TradePub.com to offer you a new, exciting, and entirely free professional resource. Visit http://vistax64.tradepub.com today to browse our selection of complimentary Industry magazines, white papers, webinars, podcasts, and more across 34 industry sectors. No credit cards, coupons, or promo codes required. Try it today!




Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media 2005-2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51