I’m very satisfied I think it will help, but I haven’t tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn’t help me The information is incorrect The page contains one or more broken links Suggest new content or let us know how we can improve this content: Change your system Path variable Go to the “Control Panel”. It is possible that other version of the ODBC file installer are needed for different Notes versions. I want to use a Domino database on a server as a potential SQL source for other systems. You need to configure it as if it was a real server.

Uploader: Akinosida
Date Added: 16 May 2008
File Size: 55.9 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 51398
Price: Free* [*Free Regsitration Required]

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. This demonstration utilises Microsoft Windows 644 as the Operating System and OpenOffice to test the configured connection. This will allow you to then create introspect and create a connection using Integration Studio. You can use all defaults. Change the permissions of the OSRuntime database user For the OutSystems applications to be but to access the data of the linked server in runtime you need to change the permissions of the OSRuntime database user.


Expand “Server Objects” and right click “Linked Servers”.

IBM A Guide to Getting Started with NotesSQL – United States

If you are using a bit version of Domino on a bit platform, download the bit Easysoft ODBC driver but if there is a bit version available. We tested on Linux. So I’m slightly confused! Technical resources for Notes and Domino developers are available from this web page:. However, when we ran dctest during Domino 6 testing, we did get notesssl dynamic linker error for libnotes.

The external data is then available to Lotus Notes client applications. But the driver still will not work. Create one if you don’t have it.

Click “Save List” and then “Close”. You may have to login and accept the legal agreement again.

Accessing ODBC Databases from Lotus Notes/Domino

It is possible that other version of the Ofbc file installer are needed for different Notes versions. We currently do not know what are the exact permissions needed.

It is not available on the regular NotesSQL page. The steps below are for setting up the connection for a bit SQL Server. Thank you very, very much. You can then use the application to query and update your Domino data by using SQL. Install the downloaded file.


After that dctest started successfully. What should I do? Click “Advanced system settings” on the left.

At the prompt, type “help” to display a list of tables. Click the only option that shows on the page and, in the following page, click Continue. Disable the Lotus Domino services to make sure they don’t start when you restart the machine. When asked choose to configure it as a “Domino Utility Server”.

Mat Newman

To exit, press return in an empty prompt line. Can this be clarified?

Select “New Linked Server” and fill in the form as shown in the screenshot below. Path seeting reboot doesn’t seem to be required, Windows 7 64bit Enterprise Add this to path variable or equivalent for your machine You’ll have to login with an IBM login.