Friday April 27, 2007 ODBCdL4 for Windows Driver 1.3.1 Release All Rights Reserved. Copyright (c) 2005 - 2007 by: Dynamic Concepts, Inc. Aliso Viejo, CA 92656 USA Email address: techsupport@dynamic.com Information: www.unibasic.com Downloads: ftp.dynamic.com Pre-installation instructions ============================= o Due to network protocol changes, this version of ODBCdL4 for Windows cannot be used with older beta versions of the ODBCdL4 for Unix server. All servers must be upgraded to version 1.1 or later of the ODBCdL4 for Unix server. o ODBCdL4 for Windows must be used with the ODBCdL4 Server for Unix. 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 ODBCdL4 for Windows, perform the following steps: 1. Remove any previous ODBCdL4 for Windows release. 2. Run the ODBCdL4 installation program 1B_odbcdl4_1.3.1.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 Supports installation on 64-bit versions of Windows. o Supports JOIN syntax required by Crystal Reports. o Simplifies use of ODBCdL4 as a "linked server" under Microsoft SQL. o Supports the access control feature of the ODBCdL4 server. o Supports reading string, numeric, and date data from indexed contiguous and contiguous files. o Supports files containing multiple record types by allowing selection of records based on record, fields, key fields, or record numbers. o Supports reading packed data or using packed data in keys. o Supports conversion of specified values in records to SQL NULL values. New in This Release ================================================================= 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" | |