Tuesday December 15, 2009 ODBCdL4 for Windows Driver 1.5.2 Maintenance Release All Rights Reserved. Copyright (c) 2005 - 2009 by: Dynamic Concepts, Inc. Aliso Viejo, CA 92656 USA Email address: techsupport@dynamic.com Information: www.dynamic.com Downloads: www.dynamic.com or ftp.dynamic.com Pre-installation instructions ============================= o Due to network protocol changes, this version of the ODBCdL4 Driver for Windows cannot be used with older beta versions of the ODBCdL4 server. All servers must be upgraded to version 1.1 or later of the ODBCdL4 for Unix server. o ODBCdL4 Driver for Windows must be used with the ODBCdL4 Server. o This release requires that the ODBCdL4 server have an SSN authorized for release 1 of ODBCdL4 and the expected number of users. Without such an SSN, ODBCdL4 cannot be used. o Problem reports should be emailed to techsupport@dynamic.com. All problem reports should contain a description of the problem, the operating system name/revision, and, if at all possible, a reproducible sequence Installation instructions ========================= To install the ODBCdL4 driver for Windows, perform the following steps: 1. Remove any previous ODBCdL4 driver for Windows release. 2. Run the ODBCdL4 installation program 1B_odbcdl4_1.5.2.exe and follow the displayed instructions. The installation should be performed on an administrator account. When making or creating ODBC connections, specify the DNS name or IP address of the ODBCdL4 server as the "host" and use 9635 as the port number (or, if the server uses a different port, use that port number). On 64-bit versions of Windows, the ODBCdL4 driver, which is 32-bit, will not appear in the Control Panel ODBC administrator driver list. The driver can be selected in Microsoft Office or by using the "Wow64" version of odbcad32.exe. File list ========= readme.txt This file license.txt Runtime license terms and conditions odbcdl4.dll ODBC Runtime library Highlights of This Release ========================== o Improved performance for queries using the IN or BETWEEN operators. New in This Release ================================================================= Dec 15 2009 (Maintenance Release 1.5.2) o Fix problem with the ODBC Administrator on Windows 7: the administrator utility (odbcad32.exe) crashed when creating a file DSN. May 27 2009 (Maintenance Release 1.5.1) o Improve compatibility with the "Preview" button of the Excel ODBC connection setup wizard. Nov 20 2008 (Production Release 1.5) o Improve performance for queries using the IN or BETWEEN operators. This feature requires release 1.5 or later of the ODBCdL4 server. o Increase compatibility with the Excel Data Wizard and some other ODBC configuration utilities. Jun 10 2008 (Production Release 1.4) o Improve performance for queries using OR conditions. This feature requires release 1.5 or later of the ODBCdL4 server. o Improve performance for some Microsoft Access applications. This feature requires release 1.5 or later of the ODBCdL4 server. Apr 27 2007 (Maintenance Release 1.3.1) o Increase query timeout period to support lengthy table scans that return very few records. Jan 26 2007 (Production Release 1.3) o Simplify use of ODBCdL4 as a "linked server" under Microsoft SQL Server by treating character fields as VARCHAR or LONGVARCHAR columns. Previous releases treated character fields as CHAR columns. o Support installation on 64-bit (x64) Windows systems. o Support JOIN syntax required by Crystal Reports. o A brief description of the SQL syntax supported by ODBCdL4 has been added to this document (see "SQL syntax" below). Dec 16 2005 (Production Release 1.2) o Support the access control feature of release 1.2 of the ODBCDl4 server. o Fix bug: the odbcdL4 driver DLL was not always installed successfully. Sep 14 2005 (Production Release 1.1) o First production release of ODBCdL4. o The ODBCdL4 server now requires an SSN authorized for release 1 of ODBCdL4 and for the number of expected users. o The IS and NOT options are now supported on RecordNum fields. Aug 19 2005 (Beta Release 1.1.1.4) o Support has been added for packed data in keys and CONV format numeric fields in records. For details, see the readme.txt file for the ODBCdL4 server. May 6 2005 (Beta Release 1.1.1.3) o Support contiguous files, date conversions, record selection, and NULL values. For details, see the readme.txt file for the ODBCdL4 server. o Due to network protocol changes, this version of ODBCdL4 for Windows cannot be used with older versions of the ODBCdL4 for Unix server. All servers must be upgraded to version 1.1.1.5 or later of the ODBCdL4 for Unix server. Feb 1 2005 (Beta Release 1.1.1.2) o First public release. Jan 17 2005 (Beta Release 1.1.1.1) o First release. SQL syntax supported by the ODBCdL4 server and driver ===================================================== In the following syntax definitions, the character "|" indicates alternate selections. Enclosing braces ("{ x x x }") surround items that are optional. An ellipsis ("...") indicates that the previous term can be repeated one or more times. Words and symbols used in the syntax are enclosed in double quotes (the double quotes themselves are NOT part of the syntax unless otherwise specified). ::= ::= "SELECT" ::= } ::= { "ALL" | "DISTINCT" } "*" | { "ALL" | "DISTINCT" } ::= } ... ::= ">" | ">=" | "<" | "<=" | "=" | "<>" ::= | "?" | "USER" ::= "+" | "-" | ::= "*" | "/" | ::= { "+" | "-" } ::= ( ) | | | | ::= | ::= "FN" ")*--" ::= "--*(VENDOR(MICROSOFT),PRODUCT(ODBC)" ::= "{" "FN" "}" ::= "(" ")" | "(" ")" | "POSITION" "(" "IN" ")" | "EXTRACT" "(" "FROM" ")" ::= "COUNT" "(" "*" ")" | "AVG" "(" ")" | "MAX" "(" ")" | "MIN" "(" ")" | "SUM" "(" ")" | "COUNT" "(" ")" ::= | | "?" | "USER" | |