Hi, I've a security permission issue with SLX com object and I couldn't get it resolved and wondering if someone could help me out in this situation. This is what I'm doing:

I've added a reference Interop.SLXSystem' and accessing slx's BasicFunctions, everything is working flawlessly on localhost however when a remote user uses the portal, I end up with the Access is denied exception. I'm using active directory for user management. I created a user and give permissions to SLX DCOM object, SLX exe, Interop.SLXSystem, portal directory, IIS's Application Pool, etc yet I'm keep getting following exception.

Retrieving the COM class factory for component with CLSID {GUID} failed due to the following error: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).

SLX Client is always running. Some code:

Type slxType = Type.GetTypeFromProgID("SalesLogix.SLXApplication");

SalesLogix.SlxApplication slxApp = Activator.CreateInstance(slxType) as SalesLogix.SlxApplication; // exception occured for users not on localhost

Slx Version: 7.5.4.7048

IIS: 7.5

I've managed to fix the issue using process delegation that was initiated with domain user. Now, there is one more exception. Whenever I try to BasicFunctions.GetPrettyKeyPrefix(string) function, it returns following exception even though SLX client is running.

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I'm not sure why is that?

Furthermore, I receive aforementioned exception only when the request comes from the IIS and user isn 't on localhost.

Hi Umer,

Completely a bad idea to use SLX COM from a web app. What exactly are you using it for so I can suggest alternative routes? 

As for getting a table ID, the recommended route is to use the SLX OLEDB Provider and call SLX_DBIDS as described here http://www.slxdeveloper.com/page.aspx?action=viewarticle&articleid=87

Ryan

Thank you Ryan,

I need to create SLX Tickets using web-app so I need AlternateKeyPrefix & Suffix and for that I'm calling following functions.

BasicFunctions.GetPrettyKeyPrefix(_TicketID)
BasicFunctions.GetPrettyKeySuffix(_TicketID)

I know using COM objects from web-app is generally pretty bad idea. However, I've tried to make it right, kind of, by creating a console app that does the job and returns the results to web-app.

I do, however, using SLX OLEDB Provider in my integration project but I'm not sure how to go about with AlternateKeyPrefix/Suffix with Provider only approach.

Is the web app a .NET application? If so, you could use Sublogix, even if only to create the pretty key prefix & suffix. To do this, you'll need to get the Sublogix DLL via NuGet - see the "How to get Sublogix via NuGet on this page http://customerfx.com/pages/crmdeveloper/2010/10/21/sublogix-simple-repository-for-saleslogix-now-available.aspx

Then you'll have a reference to the Sublogix DLL and you can use the following helper functions:

var prettyKeyPrefix = Sublogix.Helpers.SalesLogixHelper.GetPrettyPrefix(myId);
var prettyKeySuffix = Sublogix.Helpers.SalesLogixHelper.GetPrettySuffix(myId);
var prettyKey = prettyKeyPrefix + prettyKeySuffix;

Make sense? Sublogix doesn't use COM or any SalesLogix components at all to do this so there is no extra overhead or concern with loading the SLX application into memory in the web process & app pools.

Ryan

Thank you Ryan,

I wasn't aware of the SubLogix API. It should help in my project. Let me try and I'll reply with the results. Thanks.

Hi Ryan,

It worked beautifully. API is cool too. Thank you.