Solved

MTS

Posted on 2002-03-22
6
235 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
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
Independent Software Vendors: 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
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…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

713 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