ODBC from Domino server rather than Client


Im new to Notes trying to setup a Domino server that can access data on a mainframe (DB2).

Im using ODBC to connect from my machine(client), but I cant seem to access the data set names on the server.

Im using Notes 4.5.4 and Domino 4.6.5a

What Im tring to do is grab data to fill out a form from an online database (DB2) through ODBC. I can make the calls ok from the client, but I dont want to configure thousands of clients to hit the mainframe. I need to route the calls through the server somehow.

Is it possible to do this? Or will I have to configure an ODBC driver for every client to access the data?

If it is possible...what do I need to do?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Came across the same problem before.  The only way is to use DECS.  DECS - Domino Enterprise Connection Service by Lotus allows clients to use the DECS connection, which is from the notes server to the DB2 database.  Server to server connectivity.  So however many clients hit the domino server they use the connection between the  domino server and the db2 data.  I can explain further if you'd like, or go to www.lotus.com Enterprise connectivity to download an evaluation copy.  DECS also runs on the AS/400 if you are using it for your server.

Good Luck!

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AFAIK, DECS is not the only way. You can create the ODBC DSN in the server ONLY. Then create an agent that does data processing as you want. From the client, you can write some code in the apropriate event. From within the code call the agent as


where theAgent is a NotesAgent variable.

Using this technique, you won't have to set up an ODBC DSN in every client.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.