Totally new to this so forgive me if this is a stupid question. Do you need to have DECS installed on the client to have LSX connect? Also do I need to have the ODBC Installed on the client to have the LSX work. What I need to do is get a list of customer names or Numbers from a db2/as400 table.I am trying to see if it is possible to do that through LC LSX.
Thank you
PJG
Subject: LC LSX
I am doing exactly the same thing as you. We are not using DECS. But are using LSX to write the code to grab information from the AS400. You will need an odbc connection to it. We used db2connect to access it.
Subject: RE: LC LSX
Is the ODBC on your Client or server? Please say Server. 
And…
Can you tell me where I can find some references or ca you share what your doing?
Subject: RE: LC LSX
ODBC is a client-side product. If you are running this as a server-side agent and your Domino server is running on a Windows platform, you need to have ODBC installed and configured on the Domino server. If it is a client-side agent, you need ODBC installed on the Notes client running the agent. I use the ODBC driver included with iSeries Access, also known as Client Access.
If you are running this as a server agent and Domino is on the iSeries, it’s a bit more complicated. Unless you have the DB2 Connect software for Windows you can’t use the “db2” connector with LC LSX for testing/debugging. And if you use the “odbc2” connector for testing during development you’ll have to change it to “db2” before you put deploy the agent to the iSeries because using the “odbc2” connector will crash the Domino server.
And finally, you probably want to check the Enterprise Integration forum for more information. Just be sure you’re clear that you are not using LEI, because everyone there seems to assume that’s the only way to interface Domino to an RDBMS.
HTH,
Charles
Subject: RE: LC LSX
The funny thing is I have LEI running on the server and working. I to am using the Client access given driver. But I am told that we would be better off using LSX.
Subject: RE: LC LSX
Since you’re already using LEI, why are you considering switching, and what do you do with LEI today? LEI does make some things a lot easier, and you have to weigh your decision against the fact that you have to do absolutely everything in code yourself versus letting LEI handle it, and that can be quite tedious.
Subject: Question for you then…
Like I stated before I need to be able to be in a DB a do a lookup of all customer names based on a location number. So Would I be better off using LEI, DECS, or LCLSX? All connections need to be based on the server.
Subject: RE: Question for you then…
If you already have LEI in production for other applications I would say use that. I use LCLSX exclusively because that’s what I know, and we don’t have LEI.