Odbc Driver Lotus Notes Windows 7

NotesSQL expects to find Notes.ini in the Lotus Notes directory. If the file is not in this directory, the driver may crash when you use the ODBC Data Source Administrator to create a DSN, or the NotesSQL Authentication List Manager may report that it is unable to find a valid version of Notes.

I am trying to use IBM ODBC Driver for Notes/Domino 9.0 with Lotus Notes 9 to access distribution lists. I have successfully added a datasource (referencing a server) in ODBC Manager like so: I have added the. IBM Notes location to my PATH, as well as the driver's location. NotesSQL as suggested elsewhere. However when testing the connection using ODBCTest (or other software), the following error occurs: I suspect this has something to do with not finding the correct notes.ini file (which is mentioned ). I see there are multiple notes.ini files on my filesystem, so I attempted to test each one. I tried appending the location of each of these files to the beginning of PATH in turn, but none of these changes fixed the issue.

I also noticed none of the existing notes.ini files are in the. IBM Notes folder with notes.exe where IBM suggests notes.ini lives by default. How do I: 1) determine which is the correct notes.ini 2) get Notes SQL to recognize that notes.ini, assuming that's the underlying issue. Try running regedit and searching your registry for entries containing 'notes.ini'. With luck, all the entries that you find will point to the same one. And in general, all programs that use the Notes API should respect the command-line syntax that specifies the notes.ini location using the same equals sign syntax shown above.

I'm not sure if that applies to using the ODBC drivers or not, but once you've located the correct path you can try using that syntax in the command line that starts your program. – Aug 4 '16 at 15:33.

Let's first deal with the widespread misconception about Lotus Notes: in short, it is not a mail server. In fact, it is much more: the server (Lotus Domino) is a distributed database server with many functions. It can replicate databases to other servers, keeping both ends up to date. It allows clients (Lotus Notes) a secure access to the server and the databases. One type of database is a mail database, and the Domino server supports sending and receiving mail, where mails are stored in or fetched from a database. It allows mail clients based on POP3 and IMAP. It has connectors to legacy systems (SAP, Oracle, ODBC).

And finally: every database is programmable to a great extent, where the code and design elements are stored inside the database, and both Notes and Domino have a COM API accessible from VB. Java can also be used. Very often, a database IS an application, and databases are portable between various Operating Systems like Windows, Linux, AIX, Solaris, AS/400, etc.

> The concept of having applications installed on an email server is a foreign one to me. In other words: it's the other way around. A Domino server is an application server that services mail as well. Now, about your question. If I understand you correctly you want an external application to connect to the Domino server or a Notes client to open a database and get some data.