---------------------------------------------------------------------- ELOQUENCE B.07.10 - patch PE71-0804110 ---------------------------------------------------------------------- This patch provides enhancements and/or defect fixes for the Odbc.DLL program as released with Eloquence B.07.10. This patch will be integrated in the Eloquence B.07.10 release. Eloquence B.07.10 must be installed before applying this patch. Severity: PE71-0804110: ENHANCEMENT, BUX FIX Superseded patches: PE71-0802280: BUX FIX PE71-0710250: BUX FIX PE71-0710160: BUX FIX PE71-0701090: BUX FIX Patch PE71-0804110 ------------------ Platforms: All * Added the SetTextColumnSize procedure to specify the default and maximum size for text columns. CALL DLL Odbc("SetTextColumnSize",DefaultSize,MaxSize) DefaultSize specifies the size the Odbc.DLL should use for text columns when the ODBC driver does not specify a column size. MaxSize specifies the maximum size for text columns the Odbc.DLL should use. Both must be between 1 and 32767. DefaultSize must not be greater than MaxSize. By default, both DefaultSize and MaxSize are set to 1024. * The Prepare or ExecDirect procedures could return ERROR 2 due to a memory allocation failure if the ODBC driver specified a huge size for a text column. For example, the SQL Server ODBC driver may return a column size of 2.147.483.647 bytes for a LONGVARCHAR column, which is the theoretical LONGVARCHAR column size limit. The Odbc.DLL then tries to allocate a buffer big enough to hold this column size, causing a memory allocation failure. The size of the allocated buffer is now limited to the maximum size for a text column, which is 1024 by default but may be configured with the SetTextColumnSize procedure. * Changed the Windows file version to "7.1.0.11" Patch PE71-0802280 ------------------ Platforms: All * The GetError procedure now traverses up the error stack in the ODBC driver manager and the ODBC driver. Previously, only the error information from the current context was retrieved. For example, in a connection context the connection related error information and in a statement context the statement related error information was retrieved. This way, in rare cases an error message could be missed, for example if the ODBC driver generates a connection related error message in a statement context. * Changed the Windows file version to "7.1.0.10" Patch PE71-0710250 ------------------ Platforms: All * Using the Fetch procedure with an XPACK buffer could result in a wrong XPACK encoding, causing ERROR 204 on XUNPACK. String variable names derived from column titles could become one character too long. * Changed the Windows file version to "7.1.0.9" Patch PE71-0710160 ------------------ Platforms: All * The SetParam procedure did not work as expected. * Changed the Windows file version to "7.1.0.8" Patch PE71-0701090 ------------------ Platforms: All * Worked around an incompatibility in the FreeTDS ODBC driver that does not support the SQLDescribeParam() ODBC function. If the SQLDescribeParam() ODBC function is not supported, the data type of a SQL query parameter is unknown. The Odbc.DLL now handles this by binding the parameter at a later stage when the application defines the data type. As a consequence, the application should take care to provide an appropriate parameter data type if the FreeTDS ODBC driver is used, otherwise a data type mismatch error may result. * Changed the Windows file version to "7.1.0.7" Installation: ------------- Please download the patch archive that corresponds with the installed release. The patch files follow the conventions below: PE71-0804110-hpux-ia64.tar.gz ^ ^ ^ | | Architecture / OS specific build | Operating system Patch ID HP-UX: In order to install this patch, you need to unpack it with gzip and tar. Gzip is included with HP-UX. Installation requires root privileges. cd /opt/eloquence6 gzip -dc /path/to/PE71-0804110-hpux.tar.gz | tar xf - Files: dll/Odbc.DLL share/doc/PE71-0804110-README Linux: In order to install this patch, you need to unpack it with tar. Installation requires root privileges. cd /opt/eloquence6 tar xzf /path/to/PE71-0804110-linux.tar.gz Files: dll/Odbc.DLL share/doc/PE71-0804110-README Windows: Two options are available for patch installation. The patch is available as self extracting archive for automatic installation and as a zip archive for manual installation. Both patches are equivalent. Installation requires administrative capabilities. For autmatic installation of this patch, please download the patch file PE71-0804110-win32.exe file. Before installation, please consider closing all applications and execute the patch installation program. Installation does not require a reboot unless the patched files were active. For a manual installation of the patch, please download the patch file PE71-0804110-win32.zip file and unpack its contents. Then perform the following steps: * Please copy the Odbc.DLL file into the dll subdirectory of your Eloquence installation (for example C:\Programs\Eloquence\dll). * Please copy the PE71-0804110-README.txt file into the share\doc subdirectory of your Eloquence installation (for example C:\Programs\Eloquence\share\doc). Files: Odbc.DLL PE71-0804110-README.txt