Just click next until the last step. However, I still got an issue: 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 installation is too complex so that we can use Lotus NotesSQL for our clients, but for developing and testing purposes it is also a good candidate. To make the system itself more friendly to 3rd applications, Lotus also provides a driver — Lotus NotesSQL — so that 3rd applications can query data from Domino server. It is not available on the regular NotesSQL page. In “System variables” double click “Path”.

Uploader: Darn
Date Added: 20 March 2006
File Size: 62.82 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 16290
Price: Free* [*Free Regsitration Required]

But i have some problem.

C# – Lotus NotesSQL Driver install, configure and connect to server through ODBC

To make the controladlr itself more friendly to 3rd applications, Lotus also provides a driver — Lotus NotesSQL — so that 3rd applications can query data from Domino server. You can find in attachment the sample Lotus application I’m using in this tutorial. Do you have any suggestions on converting NotesSQL noteessql column to date? I think you have to configure something to read data out correctly.


I tried with German and it works.

You can check if the user which you nnotessql in NoteSQL connection string, has permission to see views in Lotus Notes database. It is also FAST http: You’ll just need set some passwords and you can use the defaults for everything else.

You can use the defaults for everything. As a lotuz of concept, give this user sysadmin permission to check that everything works.

Even though you will not actually use the server.

Installing NotesSQL

Then check step 5 again, you have to add paths of notes. I have tried several databases including names.

It allows ODBC-enabled data reporting tools, database tools, and application development tools to read, report, and update information that is stored in Domino databases NSF files. Choose to configure it as a “Domino Utility Server” when asked. Remove all spaces between IBM entries Copy notes.

You may have to login and accept the legal agreement again. Click “Save List” and then “Close”. Without NotesSQL, all data is locked. 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 site uses Akismet to reduce spam.

In your example of. When asked choose to configure it as a “Domino Utility Server”. Actually if I recall correctly you can use the exact same mechanism to connect to remote databases. Since there isn’t a 64 bit Notes lootus available we have tried installing the 64 bit Domino server. Thanks for this useful article. Path seeting reboot doesn’t seem to be required, Windows 7 64bit Enterprise Add this to path variable or equivalent for your machine Report is designed in crystal report 9 and i have window nottessql on my system.


For getting the download link, you have to register for IBM ID and fill out tons of formula until you get what you need. If you’re using 32bit the steps will be oltus. Can someone point us in the right direction please? Hi, I have problem with NotesSQl 8.

IBM Lotus NotesSQL

Configure authentication for NotesSQL. 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 bridge.

Let us know by taking this 2-minute survey.