Welcome to Rapid SQL® XE4 and Rapid SQL® 8.5

Rapid SQL Home | Rapid SQL Documentation | Embarcadero Technical Support | www.embarcadero.com

ReadMe Last Published: Sept. 12, 2013. Any updates to these notes will be available at http://docs.embarcadero.com.


Thank you for using Embarcadero Rapid SQL, the integrated development environment for IBM DB2 UDB for Open Systems, IBM DB2 UDB for OS/390 and z/OS, Microsoft SQL Server, MySQL, Oracle, and Sybase Adaptive Server database systems. Rapid SQL is your fast path to higher productivity whether you're programming in SQL, PL/SQL, Transact-SQL, HTML or Java. Before you use Rapid SQL, please read the information below.


What's New in Version 8.5/XE4

Embarcadero Connect Integration

User Interface and Navigator/Explorer Updates

Oracle Updates

SQL Server Updates

Operational Updates

DBMS Support and Connectivity

Dedicated Support

Generic JDBC/ODBC Connectivity

DBMS Versions No Longer Supported

Release Notes

Known Issues

Bug Fixes

Additional Resources

Licensing Your Embarcadero Product

Embarcadero Technologies Product Support

Embarcadero Technologies Technical Support

Embarcadero Technologies on the Web

What's New in Version 8.5/XE4

Embarcadero Connect Integration

Rapid SQL integrates with Embarcadero Connect, a product that allows easy distribution of data governance repository metadata to the enterprise. New Connect repository functionality includes:

Three new HKLM/HKCU registry settings (ConnectURL, UseConnect, and AllowKeepMeSignedIn) let you lock down those features.

User Interface and Navigator/Explorer Updates

Oracle Updates

SQL Server Updates

Operational Updates

A new command line startup switch, -R, lets you provide a platform-specific connection string when starting Rapid SQL from the command line. For details, see the online Help topic Getting Started > Application Basics > Starting an Installed Version of Rapid SQL from the Command Line.

DBMS SUPPORT AND CONNECTIVITY OPTIONS

DEDICATED SUPPORT CONNECTIVITY OPTIONS

Rapid SQL provides dedicated connectivity to a specific version range of IBM DB2 for Linux, Unix, and Windows, IBM DB2 for z/OS, InterBase/Firebird, Microsoft SQL Server, MySQL, Oracle, and Sybase databases. The following connectivity options are provided:

The following table provides a summary of resources/requirements for connectivity to dedicated DBMS platforms. For each platform, it lists supported versions, the client software, driver, or client/driver combination that must be installed if using native Embarcadero clients, and the third-party, Type 4 JDBC drivers packaged with Rapid SQL.

DBMS Platform Supported Versions Client (or driver/client combination) Required for use with Native Embarcadero Drivers Packaged JDBC Driver
Firebird Firebird 2.0 Firebird ODBC Driver Jaybird JDBC Driver
IBM DB2 for z/OS v8 and v9 DB2 UDB Client for Windows 8.0 or later IBM Data Server Driver for JDBC
IBM DB2 for LUW Versions 9.0 - 9.7 IBM DB2 LUW Client for Windows 8.0 or later IBM Data Server Driver for JDBC
InterBase InterBase 2007

InterBase 2009

InterBase ODBC Driver or DataDirect ODBC driver for InterBase and the InterBase Client Interbase JDBC Driver
Microsoft SQL Server 2005 (All editions including 2005 Express Edition for 32-bit x86 and 64-bit Itanium & x86-64)

2008

2012

Microsoft SQL Server Client Library jTDS Type 4 JDBC Driver for Microsoft SQL Server

Microsoft SQL Server JDBC Driver

MySQL 4.x MySQL Connector/ODBC Driver 5.2.x Driver - MySQL Connector/ODBC driver 3.51.x Driver MySQL Connector/J JDBC Driver
Oracle Oracle 9i, 10g, and 11g Oracle SQL*Net Client Oracle JDBC Thin Driver
Sybase ASE Sybase System 12.5 - Sybase 15.5 Sybase Open Client jTDS Type 4 JDBC Driver for Microsoft SQL Server

Sybase jConnect JDBC Driver

Sybase IQ 12.7 - 15.4 SQL Anywhere ODBC drivers for Sybase IQ 12.7

Sybase IQ 32-bit ODBC drivers

Sybase jConnect JDBC Driver for Sybase IQ

GENERIC JDBC/ODBC CONNECTIVITY

Generic JDBC/ODBC connectivity to non-dedicated DBMS systems or non-database datasources is also provided. Rapid SQL can connect to a datasource using a customer-provided, third-party JDBC version 3.0 or ODBC version 3.0 driver. Minimal Rapid SQL functionality is provided, including a basic Explorer tree and SQL querying.

DBMS VERSIONS NO LONGER SUPPORTED

As of this release, Rapid SQL is no longer tested against Microsoft SQL Server 2000 or IBM DB2 for Linux, Unix, and Windows 8.x.

Release Notes

IMPORTANT ADVISORY NOTES

KNOWN ISSUES


  • The current version of Rapid SQL does not support the MySQL ODBC client that shipped with previous versions of Rapid SQL. If Rapid SQL crashes after connecting to a MySQL data source:
    1. Close Rapid SQL.
    2. Uninstall the older MySQL ODBC client.
    3. Restart Rapid SQL and try connecting to a MySQL datasource. You are prompted to install the MySQL client drivers.
    4. Follow the installation instructions to install the new driver.
  • Note that when debugging a procedure against an Oracle data source, Rapid SQL performs a compilation before debugging. During a compilation, Oracle invalidates referencing objects. For example, if procedures A2 and A3 both reference procedure A1, debugging procedure A1 in Rapid SQL, will result in procedures A2 and A3 being invalidated.
  • For servers running on Sybase version 12.5.3a, the CREATE ENCRYPTION KEY and DECRYPT permissions do not display properly--they'll be shown as null. See Sybase's document CR392544 ("sp_helpprotect does not show privileges related to encryption keys."). This has been fixed in ASE version 12.5.3a/ESD#1 (now available as a download) and ASE version 12.5.4.
  • When you are using the Debugger:
  • Rapid SQL is currently unable to create table names, column names, and check constraint names longer than 18 characters on an OS390 mainframe database.
  • On SQL Server 2005, the Browser component is disabled by default. With this service disabled, in Rapid SQL you cannot reference SQL Server instances by name, only by port number. If you want the ability to reference SQL Server instances by name, you must enable this service on the server.
  • BUG FIXES

    Bugs Fixed in Embarcadero Rapid SQL 8.5/XE4
    RAP-5783 [Explorer] Request for Data retrieval query to query table's columns and not just a SELECT * statement All
    RAP-5790 [DBMS Actions] Sort via query does not sort correctly All
    RAP-5809 [Application] Application has detected a more recent version of the file that was saved automatically All
    RAP-5483 XML data queried from CLOB column appears to be truncated or missing when lauching LOB Editor to view the contents Oracle
    RAP-5793 [DBMS Object Management] Unable to view CLOB. Oracle
    RAP-5807 [Debugger]Variables are unchangeable in Debugger, when attempting to change them, errors appear - Encountered the symbol "VALUE" Oracle
    RAP-5817 [Application] Running explain plan for a query that uses the LISTAGG function errors Oracle
    RAP-5302 Incorrect script generated when renaming a procedure with sp_rename option on SQL Server SQL Server
    RAP-5810 Rapid SQL crashes when executing large script SQL Server
    RAP-5812 Global settings are overwriting local Settings for ISQL scripts SQL Server
    RAP-5788 [DBMS Object Management] Error type when renaming table Number (207) Severity (16) State (4) Server (zpic) Procedure (sp_rename) Invalid column name 't'. Sybase ASE
    RAP-5795 [Debuggers] When using Debugger, Debugger Watch and Variable window displays a NULL value and fails to update with the values given to the Stored Procedure Sybase ASE

    Additional Resources

    Licensing Your Embarcadero Technologies Product

    All Embarcadero Technologies products include a 14-day trial period. To continue using the product without interruption, we recommend that you license it as soon as possible. For information on licensing your product, refer to the Rapid SQL Installation Guide. If you have not yet purchased your Embarcadero Technologies product, contact [email protected], or [email protected] for sales in the EMEA region.

    Embarcadero Technologies Product Support

    The Embarcadero Technologies Web site is an excellent source for additional product information, including white papers, articles, discussion forums, and the Embarcadero Knowledge Base. Visit www.embarcadero.com/support, or click any of the links below, to find:

    Embarcadero Technologies Technical Support

    If you have a valid maintenance contract with Embarcadero Technologies, the Embarcadero Technical Support team is available to assist you with any problems you have with our applications. Our maintenance contract also entitles registered users of Embarcadero Technologies products to download free software upgrades during the active contract period. Evaluators receive free technical support for the term of their evaluation (14 days).

    We encourage you to open technical support cases via the Technical Support request form. For additional information about Embarcadero Technologies Technical Support, visit the Support section of our Web site.

    Embarcadero Technologies on the Web

    To download evaluations of other Embarcadero Technologies products or to learn more about our company and our products visit us at www.embarcadero.com.