Using DECS in Lotus  Domino server 5.0.12

Posted on 2006-03-23
Medium Priority
Last Modified: 2013-12-18
I have a form where the user will enter his employee id. With this employee id I have to fetch his accessId from  a table called "EmpaccessId" and for that corresponding AccessId I have to fetch his AccessCode which is a Blob data from another table called Empaccesscode and display it in my Form. The external database is SQL SERVER 2000. I have only DECS service available on my server.

Please help me with this..
Question by:priyapurushoth
  • 2
  • 2
  • 2
LVL 63

Accepted Solution

SysExpert earned 400 total points
ID: 16271003
I think that there are sample DB's and info as part of the the DECS help and Eval. Have you looked at them ?

Have you checked the IBM Redbooks and other docs ?


I hope this helps !
LVL 18

Expert Comment

ID: 16276879
Hi priyapurushoth,
You can retrieve using DECS or LotusScript, either way you need to configure on your server (if using DECS) DSN for the database, including a username and password.  Then you have to on SQL server configure that username and password to access the tables and fields.  Since you're using Windows 2000, then then windows 2000 permissions come into play for accessing the server.  But offhand, I think you'll have problems collecting the BLOB values, since R5 doesn't have the streaming method

See: http://www-10.lotus.com/ldd/46dom.nsf/55c38d716d632d9b8525689b005ba1c0/fcbb883fdd6eef9e85256ac600659211?OpenDocument

Also see this for some nice examples:

See this for DECS Installation and set up:


1- configure SQL server access for the users (you can let them authenticate using NT server permissions)
2-configure SERVER access for the users
3 - configure SERVER access for the Domino server
4. Set up DSN (ODBC) on DOMINO to link to your SQL server table.

Depending on your database, when a user enters an ID and clicks a button, then it's assumed that the LOOKUP is running on the user permissions,

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 16392449
Thanks all I some how made a connection to the SQL server using DECS and I am able to get data. I have one problem I have a field which is BLOB in SQL and it stores jpeg image. Now I get a binary value in my lotus notes form.. Can anyone help me in displaying the image in my Notes Form.

Thanks in Advance!

Author Comment

ID: 16497111
Hey guys some how  I am able to download the jpeg image to a folder. I have saved the image as "empId.jpeg".Now within my lotus form i have to display that image based on the empId. How can I do this?

Say whenever I open the Notes Doc for a particular empid that image has to be loaded in the form. Please help me with this

LVL 18

Expert Comment

ID: 16503711
If you know the file or folder location and depending on your version of notes, you can simply add computed text to the form and make it pass through html:

server := @If(@Subset(@DbName;1) = ""; "localhost"; @Subset(@DbName;1));
"<img src=\"http://" + server + "/" + @WebDbName + "/" + @Text(@DocumentUniqueID) + "/$File/" + @URLEncode( "Domino" ; @AttachmentNames) + "\"></img><br>"

With the image source either being a document in the database, or a folder/filename... standard html, should work for both client and webside.

However, I haven't tried this with an external image file.. so try first in your folder, then try in the html folder on the domino server.

so, you would replace the @Webdbname part forward with your path/filename.

See if that helps.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question