[Webinar] Streamline your web hosting managementRegister Today

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

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?

1 Solution
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!
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.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now