Solved

MTS

Posted on 2002-03-22
6
236 Views
Last Modified: 2010-05-02
Hi,

I am getting a "Permission Denied" (error No: 70) error within my MTS app.

I use a VB client; MTS middle layer (including business & database objects) with a SQL-Server backend

Within the client layer, I have a grid containing employee details, and when the user selects a row from the grid, I make a call to the Business layer - passing the ‘empId’ as a collection used as a parameter.

There seems to be a problem with the collection that is passed in as a parameter. As soon as you try to do something with the collection - i.e. set something to it or try to access say the count, then the error occurs.

I know that we need to keep the MTS objects stateless, though I don't know where VB collections fit in within the scheme of objects. Obviously we don't define them in MTS in any way. Is it part of "Interface Implemented by an MTS Component".

I urgently need a resolution to this problem, so any ideas would be greatly appreciated.

Thanks, Andy
0
Comment
Question by:amtate
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 

Author Comment

by:amtate
ID: 6888297
I have come accross more information which seems to suggest that this error is linked to whether the MTS Server package is running as a service or as the currently logged on user on the server.

(If I run the app against MTS on my own local machine - I don't get the errors).

However, this package does need to run as a service so I guess I need to know how to enable this for other users?

Andy
0
 

Author Comment

by:amtate
ID: 6888299
I have come accross more information which seems to suggest that this error is linked to whether the MTS Server package is running as a service or as the currently logged on user on the server.

(If I run the app against MTS on my own local machine - I don't get the errors).

However, this package does need to run as a service so I guess I need to know how to enable this for other users?

Andy
0
 
LVL 6

Expert Comment

by:anthony_glenwright
ID: 6890174
If you are running as the "currently logged on user", you will find that things dont work very well if there is no console user (i.e. you are not logged into the server).

Try running as a library application.
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:amtate
ID: 6893711
Do I do this through DCOMCNFG to set DCOM permissions?

0
 
LVL 49

Expert Comment

by:DanRollins
ID: 7634255
Hi amtate,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Refund points and save as a 0-pt PAQ.

amtate, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
 
LVL 1

Accepted Solution

by:
kodiakbear earned 0 total points
ID: 7666128
Moving to the Paq

kb
Experts Exchange Moderator
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question