473,237 Members | 1,388 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,237 software developers and data experts.

Microsoft Does Not Support Automation?


I came across this article while researching a VB6 430 error:

INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/default...;EN-US;q257757

"Microsoft does not currently recommend, and does not support,
Automation of Microsoft Office applications from any unattended,
non-interactive client application or component (including ASP, DCOM,
and NT Services), because Office may exhibit unstable behavior and/or
deadlock when run in this environment."

Huh?

This is entirely the reason I would want to use interop and one of the
main selling points of MS Office would be to automate processes in a
batch mode.

Can someone tell me how I can write an automated email handler without
doing Outlook automation?
Jul 21 '05 #1
4 2426
On Mon, 20 Jun 2005 09:24:48 -0700, "ja*****@texeme.com" <ja*****@texeme.com> wrote:

¤
¤ I came across this article while researching a VB6 430 error:
¤
¤ INFO: Considerations for Server-Side Automation of Office
¤ http://support.microsoft.com/default...;EN-US;q257757
¤
¤ "Microsoft does not currently recommend, and does not support,
¤ Automation of Microsoft Office applications from any unattended,
¤ non-interactive client application or component (including ASP, DCOM,
¤ and NT Services), because Office may exhibit unstable behavior and/or
¤ deadlock when run in this environment."
¤
¤ Huh?
¤
¤ This is entirely the reason I would want to use interop and one of the
¤ main selling points of MS Office would be to automate processes in a
¤ batch mode.
¤
¤ Can someone tell me how I can write an automated email handler without
¤ doing Outlook automation?

The Office applications were not designed with server-side automation in mind - just client side or
desktop automation. The threading model does not adequately support concurrent access.

Not sure what the functionality is of your automated email handler but there are probably other ways
to handle this.
Paul
~~~~
Microsoft MVP (Visual Basic)
Jul 21 '05 #2
John,

I cant answer your specific question as emails not my thing, but the problem
you alude to is very related to running Office on web servers, which is a
very tricky thing to do as you need to control the instantiation of it,
given its single threaded and web apps are by their very nature multi
threaded. The instance of office gets itself deadlocked very easy with
rogue processes left open and its often quite unstable.

What I have done in the past is to to make all jobs queue, so you only have
a sinle instance of office (word/excel/ppt) running and a single thread
passing it work and readin the queue, passing jobs one after the other.
With this thinking when you design your app you should be able to create
your handler without any issues.

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

<ja*****@texeme.com> wrote in message
news:kr********************@speakeasy.net...

I came across this article while researching a VB6 430 error:

INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/default...;EN-US;q257757

"Microsoft does not currently recommend, and does not support, Automation
of Microsoft Office applications from any unattended, non-interactive
client application or component (including ASP, DCOM, and NT Services),
because Office may exhibit unstable behavior and/or deadlock when run in
this environment."

Huh?

This is entirely the reason I would want to use interop and one of the
main selling points of MS Office would be to automate processes in a batch
mode.

Can someone tell me how I can write an automated email handler without
doing Outlook automation?

Jul 21 '05 #3
I would also throttle requests through to a single instance. I actually go
so far as to communicate through a SQL server database, having tables stand
in for message queues, leaving COM out of the mix completely. It works fine.
Be careful, though, for the usual assortment of dialog boxes, alerts, other
processes trying to open within your Office session, etc.
--
-cellbert
"John Timney (ASP.NET MVP)" wrote:
John,

I cant answer your specific question as emails not my thing, but the problem
you alude to is very related to running Office on web servers, which is a
very tricky thing to do as you need to control the instantiation of it,
given its single threaded and web apps are by their very nature multi
threaded. The instance of office gets itself deadlocked very easy with
rogue processes left open and its often quite unstable.

What I have done in the past is to to make all jobs queue, so you only have
a sinle instance of office (word/excel/ppt) running and a single thread
passing it work and readin the queue, passing jobs one after the other.
With this thinking when you design your app you should be able to create
your handler without any issues.

--
Regards

John Timney
ASP.NET MVP
Microsoft Regional Director

<ja*****@texeme.com> wrote in message
news:kr********************@speakeasy.net...

I came across this article while researching a VB6 430 error:

INFO: Considerations for Server-Side Automation of Office
http://support.microsoft.com/default...;EN-US;q257757

"Microsoft does not currently recommend, and does not support, Automation
of Microsoft Office applications from any unattended, non-interactive
client application or component (including ASP, DCOM, and NT Services),
because Office may exhibit unstable behavior and/or deadlock when run in
this environment."

Huh?

This is entirely the reason I would want to use interop and one of the
main selling points of MS Office would be to automate processes in a batch
mode.

Can someone tell me how I can write an automated email handler without
doing Outlook automation?


Jul 21 '05 #4
In message <ee**************@TK2MSFTNGP15.phx.gbl>, "John Timney
(ASP.NET MVP)" <ti*****@despammed.com> writes
John,

I cant answer your specific question as emails not my thing, but the problem
you alude to is very related to running Office on web servers, which is a
very tricky thing to do as you need to control the instantiation of it,
given its single threaded and web apps are by their very nature multi
threaded. The instance of office gets itself deadlocked very easy with
rogue processes left open and its often quite unstable.


<Snip>

In addition, you should NEVER install Outlook on a server running
Exchange server ... very bad things can happen.

Depending on what your email requirements are:

1. You could use CDO to do most email type things.
2. You could use ADO to hook directly into your Exchange servers to
manipulate email and public folder content.
--
Andrew D. Newbould E-Mail: ne********@NOSPAMzadsoft.com

ZAD Software Systems Web : www.zadsoft.com
Jul 22 '05 #5

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

Similar topics

3
by: Michael | last post by:
Hi All, I am using win2k advance sever, IIS + ASP + Office 2000 +SQL server 2000 I have a internal web site, running on IIS. it is for internal reporting purpose. All the ASP web pages are...
8
by: frankvfox | last post by:
I am struggling to export Excel spreadsheets to the client machine in an ASP.Net application. Everything was great until exporting Excel got into the act. Documentation on MSDN is so poor regarding...
4
by: Matt Howard | last post by:
I was wondering if anyone had any code samples on how to call functions within a Microsoft Access module using ASP.NET. I found a posting on how to do it with C#, but does anyone know how to do it...
2
by: JP SIngh | last post by:
HI All I just wonder if anyone has created a word document using ASP. I am able to create a work document with ASP without any problem but what I want to do is slightly more than I know. I am...
3
by: Robert | last post by:
---EN--- This message has been crossposted in a french speaking newsgroup, english version is at the end. Thanks a lot for your help... --/EN--- Bonjour, Je développe une application...
3
by: Robin Tucker | last post by:
It seems that all of the interfaces, such as IDataObject etc. from basic OLE are no longer supported in .NET, although they are implemented (differently). I have an OLE object type and am having...
8
by: | last post by:
Hi All, I'm tring to write an application which open .xls files and get information from them ( using .xls file as a database ). According to the MSDN (...
7
by: jabailo | last post by:
I came across this article while researching a VB6 430 error: INFO: Considerations for Server-Side Automation of Office http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757 ...
9
by: wendell_lucas | last post by:
Hi, I have an ASP.NET application that creates reports in Excel. It works fine in development but not on our production Windows 2003 server running IIS 6.0 Excel does not show up. I had a DCOM...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

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.