Release Bulletin InfoMaker® 10.5.1
Document ID: DC33824-01-1051-01
Last revised: December 4, 2006
Accessing current release bulletin information
A more recent version of this release bulletin may be available on the Web. To check for critical product or document information added after the product release, use the Sybase Product Manuals Web site.Accessing release bulletins at the Technical Library Product Manuals Web site
Go to Product Manuals.
Select InfoMaker® from the list of products.
Select a language and click Go.
Select InfoMaker 10.5.1.
Select the Release Bulletin.
This product is Sybase InfoMaker® version 10.5.1, which is compatible with the following platform and operating system configurations:
Microsoft Windows 2000 with Service Pack 4
Microsoft Windows XP with Service Pack 2
Microsoft Windows XP Tablet PC Edition with Service Pack 2
Microsoft Windows Server 2003 with Service Pack 1
DataDirect database drivers
The PB DataDirect ODBC drivers and OLE DB data providers from DataDirect Technologies are delivered with this release under a limited contract. They will be removed from the final InfoMaker 10.5.x EBF download.
Special installation instructions
This section describes special installation instructions for InfoMaker.
Before you install
Before you install this release, shut down any applications running on your system. Restart your system after all the installations are complete. The executable file in this release extracts setup files to the folder specified by your TMP environment variable, or the folder specified by your TEMP environment variable if TMP is not defined or specifies a directory that does not exist. Make sure you have enough disk space on the drive containing this folder before beginning the installation.
To specify an alternative location, open the System Properties dialog box from the Windows Control Panel, select the TMP user variable (or TEMP if TMP does not exist) on the Environment tab page or Advanced tab page, and specify a location that has sufficient space.
You can download InfoMaker 10.5.1 from the InfoMaker page of the Sybase EBFs/Maintenance site. Download the files you require and extract the contents of the zip file following the instructions in the download notes that accompany the release.
To install InfoMaker version 10.5.1, you must have already installed InfoMaker version 10.5 on your computer.To update InfoMaker:
Create a backup by copying the contents of your Sybase\Shared\PowerBuilder directory to another directory.
If you use the Internet plug-ins, back up the directory where they are installed. Also, back up other files that contain information you do not want to lose, such as database files and .INI files.
Run the setup.exe file in the InfoMaker directory extracted from the InfoMaker.zip file.
Changed functionality in this version
For a description of changes in the InfoMaker 10.5.1 release, see the New Features section of the InfoMaker online Help file. To view the Help file, select Help>Welcome to InfoMaker 10.5.
See “Migration information” for more information.
Database connectivity issues
Window is a reserved word in ASA
In Adaptive Server® Anywhere 9, the word “window” is a reserved word. As a result, SELECT statements on a column with the name window do not work correctly. There are several ways to work around this issue:
Set the DelimitIdentifier database parameter to “Yes” in the ConnectString.
Set the ASA database option “SET OPTION NON_KEYWORDS = ‘WINDOW’”.
Enclose the column name in quotation marks in SQL statements.
Pipeline execution with JDBC driver fails
Executing a pipeline with the destination Adaptive Server Enterprise 12.5 when using the JDBC driver fails with the database error 2762. [CR 338371]
Table updates not handled by OLE DB provider for Adaptive Server
The PB DataDirect OLE DB data provider for Adaptive Server Enterprise does not correctly handle table updates in the Database painter. [CR 338363, CR 338366]
DataDirect ODBC XML driver issues
You cannot create an ODBC XML data source name (DSN) using the DataDirect 5.1 ODBC driver. [CR 408671]
Informix interface does not work with UTF-8
The IN9 Informix database interface cannot update and retrieve data when the Informix server uses the UTF-8 character set. The interface works correctly with ANSI and DBCS. [CR 349535]
Alter table limitations with OLE DB and Microsoft SQL Server
When you connect using OLE DB and change the name or width of a column in a Microsoft SQL Server 2000 database using Alter Table in the Database painter, the column is moved to the end of the table and all its data is lost. To prevent this from occurring, InfoMaker does not allow you to alter a table's column name and column size. You can alter the table outside the painter using ISQL scripts. [CR 348581]
PB DataDirect Oracle driver issues
If you create a table in the Database painter using the PB DataDirect 5.1 Oracle driver and give it a name that has all lowercase characters, the table columns cannot be seen in the Layout view. They display correctly after you select Tables>Refresh. [CR 348038]
The PB DataDirect OLE DB data provider for Oracle does not correctly handle inserts, updates, and display for Simplified Chinese and Traditional Chinese data. [CR 338372]
Oracle stored procedures with output parameters
An Oracle stored procedure with output parameters produces an ORA-01036 error at runtime if you connect using ODBC, OLE DB, JDBC, or ADO.NET. The stored procedure runs correctly using the Oracle native driver. [CR 343297]
OraOleDB faster than Oracle8ADOProvider
When you use an OLE DB connection to an Oracle9i database, the Table list or View list displays much more quickly in the Database painter if you use OraOleDB instead of the Oracle8ADOProvider. [CR 341835]
Connection issues with CnnPool
In the Database painter, attempting to connect to an Oracle9i or Oracle 10g database from an Oracle9i client fails after a connect and disconnect if the CnnPool database parameter is set to ‘Yes’. This is because the Oracle9i client does not support connection pooling with a Unicode environment handle. [CR 355639]
Microsecond portion of Adaptive Server times not retrieved
When you use the OLE DB interface to connect to an Adaptive Server Enterprise database and select a column with the DateTime or Time datatype, the microsecond portion of the time value is not retrieved. When you use the ODBC and JDBC interfaces, the microsecond portion of a DateTime column value is retrieved correctly, but the microsecond portion of a Time column value is not. [CR 399257]
ASE version 15 with ODBC driver
Retrieving and updating data in a DataStore with a TimeStamp datatype fails when you connect to an ASE version 15 server using the Sybase ASE ODBC driver. This is due to a bug in the ASE ODBC driver. [CR 416248]
Report painter issues
AutoSize Height issues with header band
When two reports are included one above the other in the header band of a report and the AutoSize. Height property is set to true for the header band and false for the detail band, the report displays incorrectly in preview. The lower report overlaps the upper report. The report displays correctly if the Autosize. Height property is set to true in both the header and detail bands. [CR 405033]
XSL-FOP save as PDF does not support graphic controls
Use the distill method to export the data in reports that contain graphic controls, such as lines and rectangles, to PDF. The XSL-FOP method does not work correctly for graphic controls. [CR 303829]
Limitations in default PostScript drivers
The PostScript drivers installed with InfoMaker do not support searching the generated PDF file. [CR 332365]
The PostScript drivers installed with InfoMaker do not support searching the generated PDF file, and when a report has more columns than fit on a single page, so that data is wrapped to a new page in the PDF file, sometimes the last column on each page is clipped. The workaround is to use an alternative driver. See the InfoMaker 10.5 Installation Guide on the Sybase Product Manuals Web site for how to install and use an alternative driver. [CR 324579, CR 332365]
Truncated string in saved EMF file
Sometimes a string in a text control in a report is longer than can be displayed in the control in the Design view in the Report painter. If this occurs, an EMF file saved in the painter or at runtime displays with the string truncated. [CR 342797]
Web ActiveX download fails on Windows XP
The DataWindow® Web Control for ActiveX fails to download its CAB file to a client browser running on Windows XP if the Microsoft Active Template Library (ATL) module, atl71.dll, is not present in the Windows\System32 directory. The CAB file downloads successfully if the ATL DLL is present.
AutoSize group header band distorted in print preview mode
The AutoSize group header band is formatted correctly in normal mode but it is distorted in print preview mode. The column headers at the bottom of the group header band are overlapped by the detail band. [CR 421766]
In version 10.0, Adaptive Server Anywhere and SQL Anywhere Studio have been renamed SQL Anywhere. The suite is now referred to as SQL Anywhere. The database server is referred to as SQL Anywhere server.
InfoMaker 10.5.1 has been tested with Adaptive Server Anywhere (ASA) 9.0.2 (Build 3044), ASA 9.0.2 Runtime Edition (Build 3044), and SQL Anywhere 10.0 (Build 2464).
The Save Rows As PDF feature in the Report and Form painters has been tested with AFPL Ghostscript version 8.53.
Documentation updates and clarifications
BindSPInput database parameter applies to Oracle 10g
The O10 driver for Oracle 10g is not listed as supported in the description of the BindSPInput database parameter in the Connection Reference. BindSPInput applies to the O10 interface.
List of DataDirect ODBC files incorrect
The list of InfoMaker DataDirect ODBC database drivers and files in Chapter 41, “Deploying Applications and Components,” in Application Techniques is incorrect. The following table lists the required files for each supported interface.
All PB DataDirect OEM 5.10 drivers
IVPB.LIC PBICU21.dll PBTRN21.dll
PB DataDirect OEM 5.10 Btrieve
PBBTR21.DLL PBBTR21R.DLL PBBTR21S.DLL
PB DataDirect OEM 5.10 DB2 Wire Protocol
PB DataDirect OEM 5.10 dBASE
PB DataDirect OEM 5.10 Informix
PBINF21.DLL PBINF21R.DLL PBINF21S.DLL PBINFDTC21.DLL
PB DataDirect OEM 5.10 Informix Wire Protocol
PB DataDirect OEM 5.10 Oracle
PBOR821.DLL PBOR821R.DLL PBOR821S.DLL PBOR8DTC21.DLL
PB DataDirect OEM 5.10 Oracle Wire Protocol
PB DataDirect OEM 5.10 Paradox
PBIDP21.DLL PBIDP21R.DLL PBIDP21S.DLL
PB DataDirect OEM 5.10 Progress SQL92
PBPRO921.DLL PBPRO921R.DLL PBPRO921S.DLL
PB DataDirect OEM 5.10 Progress OpenEdge
PBPRO1021.DLL PBPRO1021R.DLL PBPRO1021S.DLL
PB DataDirect OEM 5.10 SQL Server Wire Protocol
PBMSSS21.DLL PBMSSS21R.DLL DBNETLIB.DLL SQLSRV32.DLL SQLSRV32.RLL SQLUNIRL.DLL
PB DataDirect OEM 5.10 Sybase Adaptive Server Enterprise Wire Protocol
PB DataDirect OEM 5.10 Text File
PB DataDirect OEM 5.10 XML
PBXML21.DLL PBXML21R.DLL PBXML21S.DLL PBIADX09.DLL PBIADX09R.DLL PBXMLX09.DLL PBXMLX09R.DLL
Microsoft update affects DataWindow Web ActiveX
If the Cumulative Security Update for Internet Explorer (912812) or a subsequent update is installed on the computer where the DataWindow Web Control for ActiveX (Web ActiveX) is running, a browser refresh does not refresh the control correctly. This update is described in Microsoft Security Bulletin MS06-013, published in April 2006.
// HTML file <HTML> <HEAD> <TITLE>test</TITLE> </HEAD> <BODY bgColor="white" PSPARAMS=""> <P>Put your data here </P> <P> </P> <P> <div id="DivID"> <script src="createElement.js"></script> </div> </BODY> </HTML>
// createElement.js file var d = document.getElementById("DivID"); d.innerHTML = '<OBJECT id="OBJECT1" style="WIDTH: 627px; HEIGHT: 320px" codeBase="psdwc105.cab" classid="CLSID:A5A51503-A5A5-1000-8000-080009AC61A9">' +'<PARAM NAME="_Version" VALUE="65536"></PARAM>' +'<PARAM NAME="_ExtentX" VALUE="16589"></PARAM>' +'<PARAM NAME="_ExtentY" VALUE="8467"></PARAM>' +'<PARAM NAME="_StockProps" VALUE="2"></PARAM>' +'<PARAM NAME="Caption" VALUE=""></PARAM>' +'<PARAM NAME="SourceFileName" VALUE="test.psr"></PARAM>' +'<PARAM NAME="DataWindowObject" VALUE="test.psr"></PARAM>' +'<PARAM NAME="LogId" VALUE=""></PARAM>' +'<PARAM NAME="LogPass" VALUE=""></PARAM>' +'<PARAM NAME="dbParm" VALUE=""></PARAM>' +'<PARAM NAME="SuppressEvents" VALUE="0"></PARAM>' +'<PARAM NAME="VScrollBar" VALUE="0"></PARAM>' +'<PARAM NAME="HScrollBar" VALUE="0"></PARAM>' +'<PARAM NAME="HSplitScroll" VALUE="0"></PARAM>' +'<PARAM NAME="LiveScroll" VALUE="0"></PARAM>' +'</OBJECT>';
You can migrate an InfoMaker application from any version of InfoMaker directly to any later version. Before you migrate to a later version, read the following Technical Document to learn about changes in InfoMaker that might affect your application: Migrating PowerBuilder Applications. Topics with IM in parentheses after their titles apply to InfoMaker.
Icon changes in InfoMaker 10.5
In InforMaker 10.5, many of the icons used in the PowerBuilder and InfoMaker user interfaces were changed. When you migrate an application to InfoMaker 10.5 or later, any stock icons used in the application are updated automatically. For users who prefer to use the existing icons, a zip file that contains 24 icon files and more than 500 bitmap files used in previous versions of the products is available on the CodeXchange Web site.
OLE DB performance with Microsoft SQL Server
In InfoMaker 10.5.1, when you use the OLE DB database interface with a Microsoft SQL Server database and retrieve data into a report or use an embedded SQL cursor in a SELECT statement, server-side cursors are used to support multiple command execution. If this has a negative impact on performance, try increasing the size of the Block database parameter to 500 or more, or adding the following line to the [Microsoft SQL Server] section in the PBODB105.ini file to turn off server-side cursors:
ServerCursor = 'NO'
Each Sybase installation that has purchased a support contract has one or more designated people who are authorized to contact Sybase Technical Support. If you have any questions about this installation or if you need assistance during the installation process, ask the designated person to contact Sybase Technical Support or the Sybase subsidiary in your area.
Other sources of information
Use the Sybase Getting Started CD, the SyBooks CD, and the Sybase Product Manuals Web site to learn more about your product:
The Getting Started CD contains release bulletins and installation guides in PDF format, and may also contain other documents or updated information not included on the SyBooks CD. It is included with your InfoMaker 10.5 software. To read or print documents on the Getting Started CD, you need Adobe Acrobat Reader, which you can download at no charge from the Adobe Web site using a link provided on the CD.
The SyBooks CD contains product manuals and is included with your InfoMaker 10.5 software. The Eclipse-based SyBooks browser allows you to access the manuals in an easy-to-use, HTML-based format.
Some documentation may be provided in PDF format, which you can access through the PDF directory on the SyBooks CD. To read or print the PDF files, you need Adobe Acrobat Reader.
Refer to the SyBooks Installation Guide on the Getting Started CD, or the README.txt file on the SyBooks CD for instructions on installing and starting SyBooks.
The Sybase Product Manuals Web site is an online version of the SyBooks CD that you can access using a standard Web browser. In addition to product manuals, you will find links to EBFs/Maintenance, Technical Documents, Case Management, Solved Cases, newsgroups, and the Sybase Developer Network.
To access the Sybase Product Manuals Web site, go to Product Manuals.
Sybase certifications on the Web
Technical documentation at the Sybase Web site is updated frequently.Finding the latest information on product certifications
Point your Web browser to Technical Documents.
Click Certification Report.
In the Certification Report filter select a product, platform, and timeframe and then click Go.
Click a Certification Report title to display the report.
Point your Web browser to Availability and Certification Reports.
Either select the product family and product under Search by Base Product; or select the platform and product under Search by Platform.
Select Search to display the availability and certification report for the selection.
Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages.
Point your Web browser to Technical Documents.
Click MySybase and create a MySybase profile.
Sybase EBFs and software maintenanceFinding the latest information on EBFs and software maintenance
Point your Web browser to the Sybase Support Page.
Select EBFs/Maintenance. If prompted, enter your MySybase user name and password.
Select a product.
Specify a time frame and click Go. A list of EBF/Maintenance releases is displayed.
Padlock icons indicate that you do not have download authorization for certain EBF/Maintenance releases because you are not registered as a Technical Support Contact. If you have not registered, but have valid information provided by your Sybase representative or through your support contract, click Edit Roles to add the “Technical Support Contact” role to your MySybase profile.
Click the Info icon to display the EBF/Maintenance report, or click the product description to download the software.
This document is available in an HTML version that is specialized for accessibility. You can navigate the HTML with an adaptive technology such as a screen reader, or view it with a screen enlarger.
InfoMaker 10.5.1 HTML documentation has been tested for compliance with U.S. government Section 508 Accessibility requirements. Documents that comply with Section 508 generally also meet non-U.S. accessibility guidelines, such as the World Wide Web Consortium (W3C) guidelines for Web sites.
Note:You might need to configure your accessibility tool for optimal use. Some screen readers pronounce text based on its case; for example, they pronounce ALL UPPERCASE TEXT as initials, and MixedCase Text as words. You might find it helpful to configure your tool to announce syntax conventions. Consult the documentation for your tool.
For information about how Sybase supports accessibility, see Sybase Accessibility. The Sybase Accessibility site includes links to information on Section 508 and W3C standards.