5 David Clover 19:04:38 Using the new IBM ODBC Driver for Notes-Domino 9.0 (formerly Lotus Notes SQL) I want to be able to use a Domino NSF database as an ODBC source on a Domino 9 server. However, the example above seems to refer to a Windows 8 client machine running a Notes client. So I'm slightly confused! Can this be clarified? I want to use a Domino database on a server as a potential SQL source for other systems. Is this the correct installation pack for that purpose? Cheers David Clover IT Development Manager MCT Faculty The Open University Milton Keynes, UK.

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. Using the new IBM ODBC Driver for Notes-Domino 9.0 (formerly Lotus Notes SQL) I want to be able to use a Domino NSF database as an ODBC source on a Domino 9 server. However, the example above seems to refer to a Windows 8 client machine running a Notes client.

8 Richard Hogan 2:23:24 Using the new IBM ODBC Driver for Notes-Domino 9.0 (formerly Lotus Notes SQL) When trying to create a new data source if you get 'The setup routines for the Lotus Notes SQL Driver (*.nsf) ODBC driver could not be loaded due to system error code 126' one thing to check is that you didn't put a space in the Path env variable before the path to your notes.ini file, so. 'c: utilities;C: Program Files lotus notes; C: NotesSQL' = GOOD. Even if there is a space before the c: NotesSQL. However 'c: utilities; C: Program Files lotus notes; C: NotesSQL' = BAD =. Error code 126 (space after 'utilities;') Hope it saves someone the hour it took me to nail it:-). 18 Jerry 4:18:56 Using the new IBM ODBC Driver for Notes-Domino 9.0 (formerly Lotus Notes SQL) not sure if this thread is dead but. From above: c: utilities;C: Program Files lotus notes; C: NotesSQL' re - interpret: Remove all spaces between IBM entries Copy notes.ini to C: Program Files (x86) IBM Lotus Notes And finally run: LOTUS_NOTES_SQL_853_W32_CIC6PEN variant And away it went on my machine!

So to try and explain: On my machine, this is what suddenly worked! Data folder below has Notes.ini and my mail id file, but I placed a copy of Notes.ini into C: Program Files (x86) IBM Lotus Notes (ini has paths in it anyway so in some ways its location doesn't matter. 1: Path seeting (reboot doesn't seem to be required, Windows 7 64bit Enterprise) Add this to path variable (or equivalent for your machine. NO SPACES after semi colon. C: IBM Lotus Notes Data;C: Program Files (x86) IBM Lotus Notes;C: NotesSQL 2: Copy Notes.ini into;C: Program Files (x86) IBM Lotus Notes 3: Run setup.exe in the unzipped download of LOTUS_NOTES_SQL_853_W32_CIC6PEN.zip from IBM.

4: Run C: Windows SysWOW64 odbcad32.exe And for me adding a new System data source worked finally! Final words: We use Lotus Notes version 8.5.2FP4 It is possible that other version of the ODBC file installer are needed for different Notes versions. If at first you don't succeed, try, and try, and try, and try, and try, and try again! (if it is Notes that is!;-) ).

Accessing ODBC Databases from Lotus Notes/Domino Contents • • • • • Introduction Domino Enterprise Connection Services (DECS) lets Lotus Domino applications access data in non-Domino databases. The external data is then available to Lotus Notes client applications. By using DECS with an Easysoft driver, your Notes/Domino applications can access data in databases such as SQL Server, Access,, DB2, InterBase and Sybase ASE. For example, access SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016, SQL Server 2017 and SQL Server Express databases from Notes/Domino applications on Linux by using DECS with our. Use DECS with our,,,,, drivers to access those databases. To access other databases for which an driver is available, for example MS Access, use the (). For relational access to Domino databases from Linux and UNIX platforms, use the.