IBM Improves ODBC/SQL Access to Domino Data -- The NotesSQL driver lets relational database management systems such as Oracle or DB2 issue SQL statements to Domino. Version 3.02 offers better performance in server applications. ++ Tags: Application Devel

Comment on this topic

IBM has updated the NotesSQL driver. The driver makes Domino databases, which aren't relational, look like a relational data source to an ODBC-enabled tool. Relational database management systems (RDBMS) such as Oracle or DB2 can issue SQL statements to Domino.

NotesSQL is an ODBC driver for Notes and Domino that lets ODBC-enabled data reporting tools, database tools, and application development tools read, report, and update information stored in Domino .NSF files. Users and application developers can use the driver to integrate Domino data with their applications using tools such as Crystal Decisions Crystal Reports, Microsoft Visual Basic, Access, Brio, and Lotus Approach.

The driver lets Internet application development tools that support ODBC access Domino data. Developers can also enable existing ODBC-capable applications to access data stored in a Domino database.

NotesSQL 3.02 includes improvements for maintaining connections for multiple users while respecting the access rights of each, IBM says. The updated version also offers better performance in server applications. It's been certified to operate with Domino 6 databases.

To use the driver, you need one of the following, with a full user license (minimum requirements):

Lotus Notes Client release 4.6.4
Lotus Domino release 4.6.4
Lotus Notes Designer release 4.6.4
Lotus Domino Off-Line Services release 1.01

You can get more information and download the latest version of the driver at http://www.lotus.com/products/rnext.nsf/873769A79D9C5B2285256A0800720B96/F8BA31E9F7BDEC3A85256C4700667625?OpenDocument

TECH NEWS

IBM Improves ODBC/SQL Access to Domino Data

The NotesSQL driver lets relational database management systems such as Oracle or DB2 issue SQL statements to Domino. Version 3.02 offers better performance in server applications.

IBM Improves ODBC/SQL Access to Domino Data

No reader comments ... yet.

What do YOU think about this topic? Share your advice and thoughts using this form.

Your Name

REQUIRED : PUBLIC

Your E-Mail

REQUIRED : PRIVATE

Job, Company

OPTIONAL : PUBLIC

City, State, Country

OPTIONAL : PUBLIC

Your Web Site

OPTIONAL : PUBLIC

Your Comment

Please help everyone by keeping your comments on-topic, using clean language, and not defaming or making personal attacks.

Your e-mail address is required, but it will not be displayed to the public or given to anyone. See our Privacy Policy. Comments become visible after they pass our spam filter, and spammers and abusers are permanently blocked. Please report spam or abuse.

ARTICLE INFO

Web Edition: 2002.12.04, Doc #11554

FREE ACCESS

MORE ADVISOR