• • • • • • > > > IBM Lotus Notes/Domino 8.5 Forum (includes Lotus Notes Traveler) Subject: Notes SQL 8.5 ODBC and Windows 7 Feedback Type: Problem Product Area: Other Technical Area: Accessibility Platform: Windows Release: 8.5 Reproducible: Always Due to compatiability issue I have to run Windows 7 on my machine. I use kview which communicates to my Domino server via ODBC. I have managed to install the ODBC links. It is when I get to use them that I get the problem - with the following e message: SQL Error:Specified driver could not be loaded due to system error 998:Invalid access to memory location. [Lotus notes SQL Driver (*.nsf) C: NotesSQL nsql32.dll) SQL State:IM003 SQL SELECT * 'From Telstra_Local_ExportALLGRA' Note that this is perfectly functional in a Window XP environment - though the Notes SQL used would be an earlier version. Feedback number WEBB8FN7S9 created by Brian E Ming on Status: Open Comments.

The NotesSQL ODBC driver is available for download from the Notes SQL part of the Lotus Web site. There, you'll also find a Samples Kit with examples and detailed developer information.

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. Huawei b593 driver firmware download 2016 word.

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. The good news: that's possible. The not-so-good news: it'll take some study and development, because you have to get acquainted with the Domino Object Model. There are lots of examples on the Internet, too many actually, but if you can give us a description of what your goals are, we could pick a few appropriate ones.

Most of @Sjef's suggestions are spot-on, but in this case his suggestion is a little overkill.;) You can access the Lotus Notes data from SQL Server via ODBC using the tool. NotesSQL must be installed on the Domino server, and a Notes client must be installed (and configured, IIRC) on the SQL Server.

Your ODBC code will then use the ID and Password of the Notes user/account that was installed on the SQL Server. We use this process to pull Lotus Notes data into our BI (Business Integration) server. I believe I got the ODBC driver after what seemed like a great many clicks on the IBM site. I have no idea if I downloaded the right thing. I try to set up a 32 bit ODBC connection I get 'The setup routines for the Lotus Notes SQL Driver (*.nsf) ODBC driver could not be loaded due to system error code 193'. I try 64 bit and I get 'The setup routines for the Lotus Notes SQL Driver (*.nsf) ODBC driver could not be loaded due to system error code 126: The specified module could not be found.