?
Solved

MTS

Posted on 2002-03-22
6
Medium Priority
?
240 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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 need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…
Suggested Courses

615 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