10/5/2024 2:47:36 PM
slxdeveloper.com
Now Live!
|
|
|
.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
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 |
|
|
|
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]
|
|
|
| doesn't Work Posted: 1/17/2003 1:23:20 PM | fiogf49gjkf0d when I run the app, it can't find the SLGXAPI.dll | |
|
| 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 | |
|
| 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? | |
|
| 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 | |
|
| 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. | |
|
| 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 | |
|
| 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 | |
|
| 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
| |
|
| 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 | |
|
| 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? | |
|
| 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. | |
|
| 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). | |
|
| 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...
|
|
|
|
|
|