Release Notes for Rapid SQL XE6 Patch

Go Up to What's New in Rapid SQL XE6 Patch

Important Advisory Notes

• If you want to run Rapid SQL on Microsoft Windows 8.1, verify that third-party DBMS native drivers install properly. Consider using a JDBC connection.

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:

• The Debugger windows (Variables, Watch, CallStack, Dependency) cannot be undocked. This behavior is deliberate and is true only for the Debugger windows. The Output window can be undocked.
• When running Windows XP SP2, SQL Server 2000 SP4 is required on both the client and the server.
• When running the Debugger on SQL Server 2005 CLIENTS:

1. Verify that the file ssdebugps.dll is registered on the client machine. This file is REQUIRED for debugging and Microsoft only installs it on the server machine and not as a part of a client-only install.
2. Follow the instructions under the "Configure DCOM on the computer that is running Visual Studio. NET" heading from Microsoft to reconfigure the DCOM settings on your client machine: http://support.microsoft.com/default.aspx?kbid=833977.
3. On the Default Properties tab of the My Computer dialog box, make sure the Default Authentication Level is set to None and that the Default Impersonation Level is set to Impersonate.

• When using the Embarcadero Sybase debugger against a Sybase database with multiple temporary databases (supported in Sybase ASE 12.5.0.3 and above), either the user or the debugger application must be bound to a specific temporary database.

• To bind the Embarcadero Sybase Debugger:

sp_tempdb "bind" , "ap", "Sybase Debugger", "DB", "<tempdb name>"

• To bind the user:

sp_tempdb "bind", "lg", "<login id>", "DB", "<tempdb name>"

• 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.

Bugs Fixed

Bugs Fixed in Embarcadero Rapid SQL XE6 Patch

Issue #	Description	DBMS
RAP-5876	[Debugger] Opening previously saved parameter files (prm) appear corrupted	Sybase ASE
RAP-5872	Options Icon Missing from Toolbar	All
RAP-5871	[Windows] Request to add back "minimize" and cascading Window functionality	All
RAP-5850	[SQL Editor] Application becomes unresponsive when copying and pasting from Excel into query	DB2 for LUW
RAP-5849	[Database Search] When search string is in single quotes, search files(Ex. 'EG')	Sybase ASE
RAP-5840	[Application]Unable to execute stored procedure (parameter window won't appear)	All
RAP-5831	[Debuggers] The initial execution window is replaced with the one happens to be in when stopped	Sybase ASE
RAP-5668	[SQL Editor] Application crashes when code complete is enabled	All
RAP-5499	Cannot compile certain Stored procedure in DB2	DB2 for LUW
RAP-5475	When close the Rename dialog box and do a full refresh on the table has been renamed, error message occurs	Sybase ASE
RAP-5359	It takes unexpected long time to open Package Bodies list or open a Package body code when user has about 35,600 packages	Oracle
RAP-5294	populateCollectionAttributes() failed to populate for object type Table when user open an Oracle table	Oracle
RAP-5283	Why is there a limit (64) on the number of bookmarks that can be created???	SQL Server
RAP-4908	Toolbar is shifting out of view	All
RAP-4831	Creation of a new project in SQL Server 2005 doesn't bring across any existing functions. Procedures seem to come across without issue.	Oracle
RAP-4691	The syntax checker for a Sybase 15 computed column is returning syntax errors even though it is valid on the database	Sybase ASE
RAP-4649	Application is very slow in opening objects such as databases and tables also in DDL extractions	SQL Server
RAP-4234	Code for SQL Server user 'SYS' is empty in the code window.	SQL Server
RAP-4232	Formatting of SQL in code editor is not good.	All
RAP-4206	Toolbars out of alignment.	All
RAP-3205	RS74[3218]: Having difficulty in saving the results of query to a network server drive	Sybase ASE
RAP-3148	RS740 3218 BUG Syntax check is giving out an error even through the SQL is correct	Sybase ASE
RAP-2033	ENHANCEMENT: ability to sort in alphabetical order the list of folders and files in 'FAVORITES' window	All
RAP-2026	RS720: Upgrade favourites during installation from previous release	All
RAP-1504	Enhancement: User would like to have an option to automatically close all Projects when exiting out of Rapid SQL.	All
RAP-1276	Suggestion Overwriting a project should prompt you to allow you to overwrite	Oracle