As a proof of concept, give this user sysadmin permission to check that everything works. Click “Advanced system settings” on the left. I tried on https: If you want only a limited number of servers within your environment to be accessible in this way, you can create a Notes. I have a requirement to pull some legacy data from Lotus Notes and at the moment I am working through a 32 bit Lotus Notes Client. You’ll just need set some passwords and you can use the defaults for everything else. Just click next until the last step.

Uploader: Doulrajas
Date Added: 16 April 2010
File Size: 15.58 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 89988
Price: Free* [*Free Regsitration Required]

Views are my own. Select “New Linked Server” and fill in the form as shown in the screenshot below. You may louts to login and accept the legal agreement again.

How to access legacy data from Lotus Notes / Domino applications

Configure Lotus Domino Server Even though you will not actually use the server. Configure authentication for NotesSQL.

Create one if you don’t have it. When asked choose to configure it as a “Domino Utility Server”.

HOWTO: Connecting to a Lotus Notes / Domino application using ODBC and Linked Server – OutSystems

If at first you don’t succeed, try, and try, and try, and try, and try, and try again! You can use the defaults for everything. But the driver still will not work.


I want to lotuus a Domino database on a server as a potential SQL source for other oltus. How digital farming is revolutionizing the future of food. It is not available on the regular NotesSQL page. Delivered Daily Subscribe Best of the Week Our editors highlight the TechRepublic articles, galleries, and videos that you absolutely cannot miss to stay current on the latest IT news, innovations, and tips.

When you create the 32 bit application pool you must set its pipeline mode to “Classic”. Now we can spend many hours trawling google again for error and ‘Setup cannot locate a supported version’ errors, before finally giving up until the next release.

In “System variables” double click “Path”. The steps for bit Lootus Server are different. I have worked through this solution on my end and have everything in place to extract data in MS Excel using a 32 bit ODBC driver as a nogessql. Thanks for this useful article. All the steps below are to be performed on the machine where the Database server is running.

Click the only option that shows on the page and, in the following page, click Continue.

We currently do not know what are the exact permissions needed. Disable the Lotus Domino services to make sure they don’t start when you restart the machine. I’ve actually tested them from start to finish in clean environment to make sure they worked just fine.


Actually if I recall correctly you can use the exact same mechanism to connect to remote databases. Your first step is to register the Notes. I’ve researched a number of instructions available on the web and I’ve tested the steps to created a linked server but none of tutorials we I found seemed explain well nptessql what you need to do. Install the downloaded file. Change the permissions of the OSRuntime database user For the OutSystems applications to be able to access the data of the linked server in runtime you need to change the permissions of the OSRuntime database user.

Hope this helps someone out there in the community! You’ll just need set some passwords and you can use the defaults for everything else. How IoT, robotics, and AI are tackling one of the biggest problems of the century.

Below you can find the steps I’ve learned through these experiments. Figure B Notes ID.