Manage Learn to apply best practices and optimize your operations.

Connecting To External Database And Passing Data From Lotus Client

A lot programmers(R4.6.3) has got the difficulty to find a solution for
connecting to external database like Oracle and passing data from lotus client
without creating Data Source Name in each client. The easiest way of doing that

Step 1: Have flag field in Document and have value as "0"
Step 2: Create a view with formula flag=0
Step 3: Write the code to connect to External database in agent.
Step 4: To make the agent run in the server use RunOnServer method instead of
Run method of notesAgent class.
Step 5: Whenever the agent is run, get the first document from view and change
the value of lfag to 1. Now that the handle to the docucment is got in Agent
and the document is removed from the view.

The first five steps are used to pass the value to the server agent from the
lotus notes client. The same handle can be used to populate values from the
external database..

Dig Deeper on Lotus Notes Domino Administration Tools

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...