Welcome to HostingForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Launch Office Applications From ASP

  
   Web Hosting Problem Solving Community! (Home) -> IIS RSS
Next:  ASP Intermittently stops on IIS6 / Windows 2003 S..  
Author Message
user980

External


Since: Oct 17, 2003
Posts: 1



(Msg. 1) Posted: Fri Oct 17, 2003 11:21 am
Post subject: Launch Office Applications From ASP
Archived from groups: microsoft>public>inetserver>iis (more info?)
I am unable to launch any MS Office applications from an ASP. Two errors occur: The first one is:

Microsoft VBScript runtime (0x800A0046)
Permission denied: 'createobject'

However all the permissions for the IUSR account are set correctly.

The second result are five entries in the App Event Log. All are from the msiinstaller, two are 1004 events and three are 1015 events. The 1015 are "failed to connect to server" and the other is "HKCU/....../userdata" key does not exist. The key does exist. If I change the security in IIS 5 for the ASP page from Anonymous to Basic, run the page and enter my credentials the page runs fine.

It seems to be acting like the Internet Guest account can not initialize the office application. A process starts for the application (Excel for example) and runs until it is stoped in task manager.

Any thoughts on this will help greatly

Thanks

Russ G.

 >> Stay informed about: Launch Office Applications From ASP 
Back to top
Login to vote
user641

External


Since: Aug 22, 2003
Posts: 1637



(Msg. 2) Posted: Fri Oct 17, 2003 2:31 pm
Post subject: Re: Launch Office Applications From ASP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Russ" <russell.gerttula.DeleteThis@oit.nh.gov> wrote in message
news:8D18E158-F2F7-42A1-8708-083199CDB150@microsoft.com...
 > I am unable to launch any MS Office applications from an ASP. Two errors
occur: The first one is:
 >
 > Microsoft VBScript runtime (0x800A0046)
 > Permission denied: 'createobject'
 >
 > However all the permissions for the IUSR account are set correctly.
 >
 > The second result are five entries in the App Event Log. All are from the
msiinstaller, two are 1004 events and three are 1015 events. The 1015 are
"failed to connect to server" and the other is "HKCU/....../userdata" key
does not exist. The key does exist. If I change the security in IIS 5 for
the ASP page from Anonymous to Basic, run the page and enter my credentials
the page runs fine.
 >
 > It seems to be acting like the Internet Guest account can not initialize
the office application. A process starts for the application (Excel for
example) and runs until it is stoped in task manager.
 >
 > Any thoughts on this will help greatly

It's actually a bad idea for these reasons:
<a style='text-decoration: underline;' href="http://support.microsoft.com/?kbid=257757" target="_blank">http://support.microsoft.com/?kbid=257757</a>

What is it that you're trying to do? Perhaps there's another way ...

--
Tom Kaminski IIS MVP
<a style='text-decoration: underline;' href="http://www.iistoolshed.com/" target="_blank">http://www.iistoolshed.com/</a> - tools, scripts, and utilities for running IIS
<a style='text-decoration: underline;' href="http://mvp.support.microsoft.com/" target="_blank">http://mvp.support.microsoft.com/</a>
<a style='text-decoration: underline;' href="http://www.microsoft.com/windowsserver2003/community/centers/iis/" target="_blank">http://www.microsoft.com/windowsserver2003/community/centers/iis/</a><!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Launch Office Applications From ASP 
Back to top
Login to vote
user981

External


Since: Oct 17, 2003
Posts: 1



(Msg. 3) Posted: Fri Oct 17, 2003 2:31 pm
Post subject: Re: Launch Office Applications From ASP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Here is the code we are using to launch Excel from the page.

<%
Dim strFilePath
DIM strFileSize
Dim strFileName
Dim myFSO
Dim conn
Dim rs
Dim Sql
Dim RowCtr

Dim BuildPathName
Dim BuildFileName

Const adTypeBinary = 1

BuildPathName = "e:/inetpub/internet/cgi-bin/WMB/"
'BuildPathName = "c:/temp/"

BuildFileName = "Responses " & Year(Now()) & Month(Now()) & Day(Now()) &
Hour(Now()) & Minute(Now()) & Second(Now()) & ".xls"

set cnn = server.createobject("ADODB.Connection")

cnn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"Dbq=e:\inetpub\internet\cgi-bin\WMB\WASSurvey.mdb;"

sSQL = "SELECT * FROM Input"
Set Rs = cnn.Execute(sSQL)


  Set ExcelApp = CreateObject("Excel.Application")

  ExcelApp.Application.Visible = False

  Set ExcelBook = ExcelApp.Workbooks.Add

  RowCtr = 0
 
  Do While NOT rs.EOF


The Set ExcelApp= CreateObject("Excel.Application) is the line that is
the catlyst for the problem.




*** Sent via Developersdex <a style='text-decoration: underline;' href="http://www.developersdex.com" target="_blank">http://www.developersdex.com</a> ***
Don't just participate in USENET...get rewarded for it!<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Launch Office Applications From ASP 
Back to top
Login to vote
timcof

External


Since: Sep 02, 2003
Posts: 912



(Msg. 4) Posted: Thu Nov 06, 2003 1:17 pm
Post subject: Re: Launch Office Applications From ASP [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Grab filemon and regmon from www.sysinternals.com. Run both and reproduce the error. Search for access denied. Turn off virus scanning while running
the test; it will fill up the logs quickly.

Thank you. I hope this information is helpful.

Tim Coffey [MSFT]

This posting is provided “AS IS” with no warranties, and confers no rights. You assume all risk for your use. © 2001 Microsoft Corporation. All rights reserved.
--------------------
| From: Russ Gerttula <russell.gerttula.RemoveThis@oit.nh.gov>
| References: <bmp1rr$gte23@kcweb01.netnews.att.com>
| X-Newsreader: AspNNTP 1.50 (ActionJackson.com)
| Subject: Re: Launch Office Applications From ASP
| Mime-Version: 1.0
| Content-Type: text/plain; charset="us-ascii"
| Content-Transfer-Encoding: 7bit
| Message-ID: <e$HXluNlDHA.2652@TK2MSFTNGP09.phx.gbl>
| Newsgroups: microsoft.public.inetserver.iis
| Date: Fri, 17 Oct 2003 11:22:37 -0700
| NNTP-Posting-Host: actionjackson133.dsl.frii.net 216.17.147.133
| Lines: 1
| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP09.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.inetserver.iis:280109
| X-Tomcat-NG: microsoft.public.inetserver.iis
|
|
| Here is the code we are using to launch Excel from the page.
|
| <%
| Dim strFilePath
| DIM strFileSize
| Dim strFileName
| Dim myFSO
| Dim conn
| Dim rs
| Dim Sql
| Dim RowCtr
|
| Dim BuildPathName
| Dim BuildFileName
|
| Const adTypeBinary = 1
|
| BuildPathName = "e:/inetpub/internet/cgi-bin/WMB/"
| 'BuildPathName = "c:/temp/"
|
| BuildFileName = "Responses " & Year(Now()) & Month(Now()) & Day(Now()) &
| Hour(Now()) & Minute(Now()) & Second(Now()) & ".xls"
|
| set cnn = server.createobject("ADODB.Connection")
|
| cnn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
| "Dbq=e:\inetpub\internet\cgi-bin\WMB\WASSurvey.mdb;"
|
| sSQL = "SELECT * FROM Input"
| Set Rs = cnn.Execute(sSQL)
|
|
| Set ExcelApp = CreateObject("Excel.Application")
|
| ExcelApp.Application.Visible = False
|
| Set ExcelBook = ExcelApp.Workbooks.Add
|
| RowCtr = 0
|
| Do While NOT rs.EOF
|
|
| The Set ExcelApp= CreateObject("Excel.Application) is the line that is
| the catlyst for the problem.
|
|
|
|
| *** Sent via Developersdex http://www.developersdex.com ***
| Don't just participate in USENET...get rewarded for it!
|
 >> Stay informed about: Launch Office Applications From ASP 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Controlling how absolute paths are evaluated in ASP applic.. - hi, I have an ASP website at: http://www.mysite.com I want to have a subsite off the main site like so: http://www.mysite.com/subsite Within the subsite, I have a page: http://www.mysite.com/subsite/index.asp Within the page, I have a SSI: <!-...

IIS did not launch - I have IIS 4.0 on Windows NT, When I launch the IIS I receive this message from Windows: "Unable to open the file", then I noticed that I could not open the TEMP folder (C:/TEMP) and I deleted this folder and restarted my server and the IIS run...

IIS does not launch - I have IIS (probably 5.0) on Windows XP. When I launch Internet Services Manager (from Control Panel -> Administrative Tools), it launches fine. Then, I run my ASP page which tries to connect to Oracle database and fails (don't know why). Then, I try ...

Remote application launch in the IIS - Dear all, I would to remotely launch an application via a Visual Basic script. I have arranged the following piece of code, that launches the wscript.exe, bat it doesn't work applaunch.asp: <HTML> &lt;BODY&gt; &lt;% Dim obj...

How do I launch non Microsoft Applications - I have a requirement to launch non microsoft applications from intranet web pages. The applications are pre-installed, just would like to place a link on the web page? any thoughts.
   Web Hosting Problem Solving Community! (Home) -> IIS All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]