Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating remote automation object

Status
Not open for further replies.

HewruH

Programmer
Dec 29, 2000
1
UA
I'm just learning DCOM. So, I begun to learn with scratch.
I found such example in MS VBScript reference:

Dim ExcelApp
Set ExcelApp =
CreateObject("Excel.Application", "host_name")
ExcelApp.Visible = True
ExcelApp.Quit
Set ExcelApp = Nothing

When I run this code with my machine name at "host_name" place, it works perfect, but when I specify another host name instead, script fails at second line with error:
ActiveX component can't create object: 'Excel.Application'
But when I run it from that another host it also works fine.

I've install dcom98 v1.3 on both machines. Hosts belong to the same domain and have no problems with connection to each other. With DCOMCNFG I enabled remote connection on both. It seems the problem is in an application type of "Excel Application" (remote/local server) wich I also tried to change in various values, but I'm not strong in DCOM configuration.
Could anyone help me to solve this problem?
 
With dcom permissions the way to go is to start broad and then narrow down. Run dcomcnfg on your dcom server and under the default security tab add Everyone to the launch and access lists. If you are logging in to either the client or server with a domain account, add that account as well. If you are using iis, add the Iusr account. In some cases you may have to create a duplicate Iusr_dcomclient account on your dcom server and snych the pw's.

Also, check microsoft.com/com and search the knowledge base. There are several articles on configuring dcom.

hth - j
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top