Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Saturday, October 5, 2024 
 
.NET SlgxApi.dll Managed Wrapper  
Description:  This post contains a .NET Managed Wrapper for the SalesLogix API, written in VB.NET

Category:  Code Samples
Author:  Ryan Farley
Submitted:  11/2/2002
   
Stats: 
Article has been read 19252 times

Rating: - 5.0 out of 5 by 6 users
 

fiogf49gjkf0d
.NET SlgxApi.dll Managed Wrapper

This post contains a .NET Managed Wrapper for the SalesLogix API, written in VB.NET. Also included is a small sample to demonstrate using the managed wrapper from a VB.NET application.

 Click here to download the files

Stay tuned for more articles discussing using .NET languages with SalesLogix. Watch the related articles below.

-Ryan Farley
 

About the Author

  Ryan Farley
(SalesLogix Business Partner)
Customer FX Corporation

fiogf49gjkf0d

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix since 2001 and believes in sharing with the community. He loves C#, Javascript, Python, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

View Ryan's SalesLogix Mobile Seveloper Series
View Ryan's SalesLogix SData Developer Series
View Ryan's Git for the SalesLogix Developer series



View online profile for Ryan Farley
 

[ back to top] [ send to a friend]  

Rate This Article you must log-in to rate articles. [login here] 
 
Please log in to rate article.
 

Comments & Discussion you must log-in to add comments. [login here] 
 
Author Article Comments and Discussion
RJ Samp

slxdeveloper.com Forum Top 10 Poster!

doesn't Work
Posted: 1/17/2003 1:23:20 PM
fiogf49gjkf0d
when I run the app, it can't find the SLGXAPI.dll
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Differences in v6 install...
Posted: 1/17/2003 2:39:16 PM
fiogf49gjkf0d
With version 6, the install does *not* add the location of the SlgxApi.DLL to the path. In order to be able to use this (or any application that uses SlgxApi.DLL) with version 6 you'll need to add "C:\Program Files\SalesLogix" to the system's PATH as the SLX installer does not do that with v6 as it did in previous versions.

However, the v5 install does add it to the path so the DLL can be accessed from anywhere by other applications.

One thing to note, is that this assembly was written long before v6 came out so it was not tested with v6 (and I still have not tested it with v6 either)

Once you add the location of SlgxApi.DLL to your path it should work fine.

-Ryan
 
JM
 

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 11/16/2004 10:55:09 PM
fiogf49gjkf0d
I have been using asp.net c# since beta 1, and slx 6.2 for only a few months. I am confused out the concept of using .net within slx. To me, it seems that you are not leveraging the natural environment of slx for development. Using .net, now you have extra code to deploy to clients, multiple environments to maintain, etc. Can you give me some justifications/bennefits of using .net within slx, and how it outweighs the issues mentioned above?
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 11/16/2004 11:06:09 PM
fiogf49gjkf0d
JM,

The main benefit you get using .NET for building SLX addons, is that you are able to use current development practices in a real development environment, using object oriented techniques, current tools etc etc etc. The list is limitless. And compare that to the alternative to using VBScript plugins in SLX and there's little comparison. The downside as you mentioned is that you are not able use have the ease of synching customizations and a simpler model for developing customizations. I don't argue that there is no benefit to using Architect to develop customizations. However, I don't rule out the "best tool for the job". When building the customizations outside using C# is the best fit for the job then that is what I use. If that route is overkill and using Architect makes most sense then that is what I use. But as my C# code library grows for building SLX addons, I find that is what I use more. Deployment has never been an issue for me. It just becomes a normal part of the SLX installation.

-Ryan
 
JM
 

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 11/16/2004 11:41:10 PM
fiogf49gjkf0d
Can you give me a few examples of when you chose to use .net over a vbscript plugin? maybe a couple different examples so i can get an idea of the types of development you do in .net. thanks.
 
Chris Fleetwood
 

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 8/18/2006 2:09:08 PM
fiogf49gjkf0d
Exactly how do you "add the location of SlgxApi.DLL to your path" ? Are you referring to adding a system variable called "Saleslogix" in the Advanced/Environment Variables area under My Computer and setting its value to "C:\Program Files\Saleslogix"? If so, I've already got this set up (and my PC has been rebooted just in case) and I'm still getting the "unable to load DLL (SlgxAPI.dll)" message. I checked and the DLL is there in that location. What can I do next?

Chris
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 8/22/2006 10:36:16 AM
fiogf49gjkf0d
Chris,

You can go the route of adding the SalesLogix directory to the path, that does work, or just place the SlgxApi.DLL into a location already in the path (such as the system32 dir - which is where I would put it). As long as you see the path where the DLL is located when you type "PATH" at a command prompt (this will list the contents of the path environment variable) then it should work fine. The wrapper does not specify location, so it does rely on the DLL to be found in the path.

-Ryan
 
Tim Willard
 

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 4/17/2007 11:38:10 AM
fiogf49gjkf0d
Hi Ryan,

I appreciate the wrapper. It looks like what I need, but I am having a few issues. I am trying to insert records into SalesLogix's database Account, Contact, and a Custom Table. I writing an asp.net 2.0 web page for SLX 6.2.3.

1) The SlgxApi.dll version states 6.2.0 .1287. The SlgxApi.Version states 620. The saleslogix client, architect, and administrator all state that it is version 6.2.3. Do you know of any a discrepancy between this dll and the actual version of running. I do not want to work with the db id issues found prior to 6.2.3.

2) How do you insert records using this wrapper? Let me go into more detail... The first thing my code does, after logging into the SlgxApi, is create a new id using SlgxApi.DBCreateIDFor. I then use SlgxApi.DBOpenSQL and pass in a sql insert statement with the newly created slx table id. This runs with success in my web page. No errors are generated. I can even query the database directly and see that the record was inserted into the account table. However, if I go to SalesLogix Client Application and search for the record, it is not found. Is this how I should be inserted? Do you have any sample code with insert statements? Do you have any advice or other method of constructing this?

Thanks and Regards!

Tim




 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 4/17/2007 11:49:29 AM
fiogf49gjkf0d
Hi Tim,

First of all, if you're on 6.2.3, *DON'T* use the SlgxApi. The SlgxApi is only still there for backwards compatibility. Not only that, it doesn't work well from a web app.

What you should be using is the SLX OLEDB Provider. You'll use the standard ADO.NET classes to work with the SLX data. Reading via SELECT queries and writing via INSERT/UPDATE statements. As long as you're doing it via the SLX provider then all is good. You'll find articles in the OLEDB section of this site (See http://www.slxdeveloper.com/page.aspx?id=15) that will give you the info you'll need, such as he connection string to use, how to create table ID values for new inserts, etc.

Make sense?

-Ryan
 
Alan Young



Re: .NET SlgxApi.dll Managed Wrapper
Posted: 11/21/2007 2:43:24 PM
fiogf49gjkf0d
regarding
If SlgxApi.LogInto("saleslogix", "admin", "xxx") <> 0

and the parameter saleslogix which in intellisense is the data base

I created a SQL Server DSN using native sql driver but no joy

how does the login work?
 
Ravi
 

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 3/31/2010 7:17:42 AM
fiogf49gjkf0d
Hi,
Any one know how we can retrieve data from SalesLogix CRM. I tried with SLGXAPI but it seems that it need some installation which will authenticate with database. Any body know what exactly we needed to configure this? Please send me reply ASAP.
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 3/31/2010 11:43:21 AM
fiogf49gjkf0d
Ravi,

To read/write to the SLX database use the SLX OLEDB Provider. This is installed with SLX or can be installed separately from the SLX installation CD.

The SlgxApi.dll was meant for older SLX versions (v5 and prior).
 
Ravi
 

Re: .NET SlgxApi.dll Managed Wrapper
Posted: 4/1/2010 1:32:27 AM
fiogf49gjkf0d
Is there is any trial version available for SalesLogix? If yes then will you please provide me some links?
 
 

       Visit the slxdeveloper.com Community Forums!
Not finding the information you need here? Try the forums! Get help from others in the community, share your expertise, get what you need from the slxdeveloper.com community. Go to the forums...
 



 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 10/5/2024 2:48:46 PM