Traveler 9. 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. Disable the Lotus Domino services to make sure they don’t start when you restart the machine. Expand “Server Objects” and right click “Linked Servers”. The steps for bit SQL Server are different. Just click next until the last step.

Uploader: Dailkis
Date Added: 20 May 2008
File Size: 46.82 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 70097
Price: Free* [*Free Regsitration Required]

As an alternative to linked servers and for option 1 I also have an example Platform 9 only. We currently do not know what are the exact permissions needed. Fill in details as shown in the screen below in this scenario I’m connecting to a local file on the same location as the DB server. You may have to login and accept the notdssql agreement again.

When asked choose to configure it as a “Domino Utility Server”. 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.

Could it be that I have a 64 notesssql OS and the driver is 32 bit I believe? Click “Advanced system settings” on the left. Let us know by taking this 2-minute survey. Is this the correct installation pack for that purpose?


By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. I don’t have much experience with making updates via NotesSQL, but you might see if you can connect to a “Notes Form” instead and make a change. Even though you will not actually use the server. 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 enough what you need to do.

Email Required, but never shown. Configure Lotus Domino Server Even though you will not actually use the server.

Lotus Notes NotesSQL ODBC driver read-only – Stack Overflow

Below you can find the steps I’ve learned through these experiments. Create one if you don’t have it. I tried on https: Expand “Server Objects” and right click “Linked Servers”. As a proof of concept, give this user sysadmin permission to check that everything works. Thanks for this useful article. The environment uses this user to access data for the running applications. Choose to configure it as a “Domino Utility Server” when asked. I haven’t been able to figure out the exact permissions needed but, for a proof of concept phase, you can just give this user sysadmin permission and it will work fine.


The steps for bit SQL Server are different. Other than that, I’d make sure the Notes account you’re using to connect has the appropriate access to the database.

However, the example above seems to refer to a Windows 8 client machine running a Notes client. Click “Save List” and then “Close”.

IBM Notes SQL ODBC drivers and Lotus Notes – United States

You need to configure it as if it was a real server. Sign up using Email and Password. Post as a guest Name. Stack Overflow works best with JavaScript enabled. You can use the defaults for everything.

Mat Newman

Click the only option that shows on the page and, in the following page, click Continue. Thank you very, very much.

It appears the trick is to know what items are views and what items are documents.