<div>
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 <br />
<br />
theAgent.RunOnServer<br />
<br />
where theAgent is a NotesAgent variable.<br />
<br />
Using this technique, you won't have to set up an ODBC DSN in every client.<br />

</div>


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

theAgent.RunOnServer

where theAgent is a NotesAgent variable.

Using this technique, you won't have to set up an ODBC DSN in every client.


<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
Im new to Notes trying to setup a Domino server that can access data on a mainframe (DB2). <br />
<br />
Im using ODBC to connect from my machine(client), but I cant seem to access the data set names on the server. <br />
<br />
Im using Notes 4.5.4 and Domino 4.6.5a<br />
<br />
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. <br />
<br />
Is it possible to do this? Or will I have to configure an ODBC driver for every client to access the data?<br />
<br />
If it is possible...what do I need to do?<br />
<br />
-mat-
</div>
</div>


Hi!

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?

-mat-

ODBC from Domino server rather than Client

Lotus Software produced the Lotus 1-2-3 spreadsheet program, and later developed Lotus Notes, a groupware and email system. Following its acquisition by IBM, the Notes and Domino client/server collaborative platform were expanded to include functions such as email, calendars, to-do lists, contacts management, teamrooms, discussion forums, file sharing, microblogging, instant messaging, blogs, and user directories. IBM also release SmartSuite, a comprehensive office suite, and followed that with Symphony, unrelated to the Lotus suite of the same name.