Solved

MTS

Posted on 2002-03-22
6
237 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

717 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