- Syntax for Populating a Lotus Notes Database. Recent Entries Exciting News: Max Number of Subqueries Notessql odbc Length of Text Fields I am trying out notessql odbc dxl ocbc seem to be having a problem with notes servers been version 5 and the dxl created not very good for importing into sql.
- It's very good for real-time measurement, the use of this software is very professional.
Lotus notes client version is 5.11 (I know.super old. We are in process of dumping notes.thus my desire to get data from notes via odbc) I can create other datasources from ODBC data source administrator using different odbc drivers (sql server, access, etc). It's only when I select the lotus notes driver and click add that I have a problem.
IBM Lotus® NotesSQL is an ODBC (Open Database Connectivity) driver for IBM Lotus Notes® and IBM Lotus Domino® software. 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).
With Lotus NotesSQL, users and application developers can integrate Domino data with their applications using tools such as Crystal Decisions Crystal Reports, Microsoft® Visual Basic, Microsoft Access, Brio, and IBM Lotus Approach. Even Internet application development tools that support ODBC can access Domino data. IT professionals can enable their existing ODBC-enabled applications to access data stored in a Domino database.
A Domino database is not relational, but with Lotus NotesSQL a Domino database looks like a relational data source to an OBDC-enabled tool. This allows relational database management systems (RDBMS) such as Oracle and IBM DB2 to issue SQL (Structured Query Language) statements to Lotus Domino.
System requirements
To use Notes data through ODBC, you must have:
- NotesSQL, the Lotus Notes ODBC driver
- An ODBC Driver Manager version 3.5 or later
- One of the following:
- Microsoft Windows 2000 or XP
- Microsoft Windows 2003 Server Standard Edition or Enterprise Edition
- One of the following:
- Lotus Notes Client release 6.0 or later
- Lotus Domino release 6.0 or later
- IBM Lotus Domino Designer release 6.0 or later
- IBM Lotus Domino Off-Line Services release 1.01 or later
Lotus Notes Sign In
To download Lotus NotesSQL, go to the IBM Software Downloads site.