NotesSQL ODBC Driver

======================================================================= NotesSQL 8.0 an ODBC Driver for Domino Important: User should add the directory containing the Notes DLL to the PATH enviroment variable before using this release. ======================================================================= Licensed Materials - Property of IBM C15MPEN (c) Copyright IBM Corporation 1996, 2007 All rights reserved. Domino, IBM, Lotus, Lotus Notes, Notes, and WebSphere are trademarks or registered trademarks of Lotus Development Corporation and/or IBM Corporation in the United States, other countries, or both. Microsoft, Windows, and Windows NT are trademarks or registered trademarks of Microsoft Corporation in the United States, other countries, or both. Other company, product, and service names may be trademarks or service marks of others. For up-to-date product information, see http://www.ibm.com/developerworks/lotus. -------- Contents -------- 1. Installation Requirements and Details 2. Files Installed 3. Changes since Release 3.02j 4. Changes since Release 3.02i 5. Changes since Release 3.02h 6. Changes since Release 3.02g 7. Changes since Release 3.02f 8. Changes since Release 3.02e 9. Changes since Release 3.02c 10. Changes since Release 3.02b 11. Changes since Release 3.02 12. Changes Since Release 3.01 13. Known Issues ---------------------------------------- 1. Installation Requirements and Details ---------------------------------------- To install and use NotesSQL, you need: - 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, with a full user license: - Lotus Notes Client release 6.0 or later - Lotus Domino release 6.0 or later - Lotus Notes Designer release 6.0 or later - Lotus Domino Off-Line Services release 1.01 or later For client-based third-party applications, NotesSQL and the Designer or Desktop software must be installed on your local machine. For server-based applications (for example, Microsoft Internet Information Server), NotesSQL and any one of the versions above must be installed on the server. Installation details: This version of NotesSQL should have been installed automatically when you ran the self-executing installation file for your platform from the NotesSQL Web page. If you need to reinstall NotesSQL, see "Installing NotesSQL" in the documentation. The installation program checks for previous versions of the NotesSQL driver and gives those DLLs file name extensions corresponding to their driver version number; for example, "nsql32.301". In the unlikely event that you need to use an earlier version of NotesSQL after installing version 3.02b, simply back up your 3.02b files and rename the earlier driver DLLs to "*.dll". Your machine Data Sources will now use the old version of NotesSQL. ------------------ 2. Files Installed ------------------ <Installation directory> // These files (including the DOCS directory index.htm // and its contents) may be in an earlier notessql.nsf // NotesSQL installation directory. nsql302.log NSQL32.dll NSQL32.map NSQLC32.dll NSQLC32.map NSQLV32.dll NSQLV32.map NSQLE32.exe NSQLE32.map license.txt Nsql_ALM.exe nsql_alm.GID nsql_alm.hlp nsql_alm.map Readme.txt UninDrv.dll <Docs> HTML and GIF files <License> Multilingual license files <\Windows\system> CTL3D32.DLL // If not already installed DS16GT.DLL DS32GT.DLL MSCPXL32.DLL MTXDM.DLL ODBC16GT.DLL ODBC32GT.DLL ODBC32.DLL ODBCAD32.EXE ODBCCP32.CPL ODBCCP32.DLL ODBCCR32.DLL ODBCINT.DLL ODBCTRAC.DLL MSVCRT40.DLL ------------------------------ 3. Changes since release 3.02j ------------------------------ - Add Notes/Domino 8.0 32-bit support. - Integrate LAP Tool into NotesSQL installation package. - This version does not support silent installation. ------------------------------ 4. Changes since release 3.02i ------------------------------ - Important: User should add the directory containing the Notes DLL to the PATH enviroment variable before using this release. - Resolve NotesSQL crash issue when a xp-non admin user updates system/user DSN - Resolve "Driver's SQLAllocHandle on SQL_HANDLE_DBC failed" issue when a xp-non admin user extracts Notes data - Resolve ACL issue: If the server db is "enforce consistent ACL", and the user is in a group of the ACL but not in the root ACL, the user cannot access the locale replica although he can access the server db. - Resolve computed multivalue issue: A computed multivalue text field loses values if the document is updated - Resolve Notes crash issue when executing some special sql statement ------------------------------ 5. Changes since release 3.02h ------------------------------ - Add Microsoft Windows 2003 Server support - Resolve issue of memory leak on repeated ODBC environment handle alloc/frees ------------------------------ 6. Changes since release 3.02g ------------------------------ - Enhanced locale support. You can now change your Windows regional options (for example, from English to French). Note that regardless of your regional settings, SQL statements must always use '.' as the decimal delimiter. However, results will use your preferred decimal delimiter. ------------------------------ 7. Changes since release 3.02f ------------------------------ - Updated registry support for Domino 7 - Resolved an issue in subforms where fields would not be returned if the subform had an alias. ------------------------------ 8. Changes since release 3.02e ------------------------------ - Many memory leaks have been fixed. - Problems with NSQLE32.EXE not exiting have been resolved. - NotesSQL should now work when updating records using a WHERE clause where the NoteUNID is used for locating the record. - NotesSQL should now work when the table being referenced in the FROM clause is named 'Server'. - Appforge issues have been resolved. If you still have problems, upgrade to Appforge 5.1 or greater. - Issues with linking NotesSQL tables from SQL Server have been resolved. - Issues with importing data into SQL Server using DTS have been resolved. - Fixed a potential issue when working with ASP.NET. Found most customer ASP.NET issues to be configuration-related. Read the section 'Microsoft Internet Information Server' in 'Tips for using third-party applications with NotesSQL' in the documentation for information about configuration issues. Also, check the Software section of the Windows Event Viewer for more detailed information about connection issues. ------------------------------ 9. Changes since release 3.02c ------------------------------ - NotesSQL should now work with Microsoft Internet Information Server on Windows 2000 with Service Pack 4 (SP4). SP4 included security updates that removed certain rights NotesSQL required. - MAP files are now included with NotesSQL to provide Technical Support with more information if NotesSQL crashes. ------------------------------ 10. Changes since release 3.02b ------------------------------ - NotesSQL no longer retrieves Field Label information. When performing queries, some products (including Microsoft Internet Information Server and Microsoft SQL Server's DTS) use the Field Label (if available) instead of the Field Name. Since NotesSQL used to map the