远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:478647
CR Number:   478647
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2007 Fixed
Description
jConnect: Add support for unsigned and bigint data types in the Bulk Insert feature of jConnect.



CR:478653
CR Number:   478653
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Feature request to support reading DSN information from a SOD file.
Workaround Description
 NONE at this time



CR:478756
CR Number:   478756
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 20 Dec 2007 Fixed
Description
ODBC Driver by Sybase: Calling SQLPrepare for a stored procedure with large number of parameter crashes the ODBC application.



CR:478871
CR Number:   478871
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
To support BLOB datatype in ctlib applications.



CR:478901
CR Number:   478901
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   1.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2007 Fixed
15 Jan 2008 Fixed
Description
Customer is requesting ability to search in result sets.



Resolution: Added search context menu to allow the user to search a text string in the SQL Results view in text mode.



CR:478961
CR Number:   478961
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows 2000
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2007 Fixed
20 Jan 2008 Fixed
Description
Problem Description: Remove the schema (role) folders under database connection profile in the Enterprise Explorer, so that the user does not need to go thru each schema (role) folder to find the data objects.



Resolution: Added context menu Show Schema and Show Owner in Enterprise Explorer to give the user the choice to turn on/off the schema folder grouping and see the owner name along with the object name.



CR:479021
CR Number:   479021
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
He developped an Excel file, linked to an ASE database via ODBC (syodase.dll).

When he tried to use SDK 15 ODBC (sybdrvodb.dll), he received error messages



CR:479088
CR Number:   479088
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2007 Fixed
Description
jConnect: The header comments in meta-data stored procedure script for ASE 15.0 refer to sp_version stored procedure which does not exist in the script.



CR:479089
CR Number:   479089
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2007 Fixed
Description
jConnect: The sp_version meta-data stored procedure missing in the ASE 12.5.x scripts.



CR:479180
CR Number:   479180
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2007 Fixed
03 Sep 2007 Fixed
Description
EXAMPLES: Bulk copy via ctos may result in blk_init() error.



CR:479211
CR Number:   479211
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#5 08 Oct 2007 Fixed
Description
MFC 12.6 ESD#3 and ESD#4 raises unexpected messages when starting and stopping the Sybase Listener (SYLB):

> SYBASE 08:22:41 TRANID SYLB TSKNO 00027This transaction is already active (in CSML)

> You cannot cancel a transaction that is not active (in SYCM screen)
Workaround Description
 Replace CICS load module SYOSMSGS from ESD#3 or ESD#4 with that from ESD#1 or GA (not sure what the impact may be to any new messages introduced in ESD#3 or ESD#4)



CR:479254
CR Number:   479254
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#11 09 Nov 2007 Fixed
1.1 ESD#21 18 Dec 2007 Fixed
Description
ADO.NET: Using tsequal function in the query results in Internal Error 30016.



CR:479397
CR Number:   479397
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 12 Nov 2007 Fixed
12.5.1 ESD#21 18 Dec 2007 Fixed
12.5.1 ESD#21 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: ADO UpdateBatch command is failing with error: "Row cannot be located for updating. Some values may have changed since it was last read."
Workaround Description
 *** Friday, August 31, 2007 5:48:05 PM *** pvero ***

CursorLocation=adUseServer



or use

ASE OLEDB Provider



Have no reply if customer will use or not.



CR:479517
CR Number:   479517
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows XP
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD1 12 Nov 2007 Fixed
Description
Problem Description: DDLGen wizard should allow the user to change the database name so that the generated DDL can be run on the database specified by the user without modifying the DDL script manually.



Resolution: Fixed, with the exception of for some ASE system stored procedures that require database name (qualified name).



CR:479698
CR Number:   479698
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#11 06 Nov 2007 Fixed
Description
ADO.NET: Provider does not raise an exception if a value for all parameters is not supplied.



CR:479700
CR Number:   479700
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#11 06 Nov 2007 Fixed
Description
ADO.NET: Duplicate parameters incorrectly processed by the provider.



CR:479723
CR Number:   479723
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 06 Nov 2007 Fixed
12.5.1 ESD#21 14 Dec 2007 Fixed
Description
OLE DB Provider by Sybase: Missing Data Source definition produces "Invalid Port" error rather than missing data source missing error.



CR:479942
CR Number:   479942
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2010 Fixed
Description
ODBC Driver by Sybase: Request to port ODBC Driver to Major Unix platform.



CR:479974
CR Number:   479974
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Generic
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2008 Fixed
23 Oct 2007 Added to user documentation
25 Feb 2008 Fixed
Description
When the user expands more than one database object folders in Enterprise Explorer and refreshes a folder, all other database object folders under the same parent object are collapsed as well.



Resolution:

Fixed
Target Version
 Tonga
Review Status
 Need to add the above CustDesc to the release note.



CR:480059
CR Number:   480059
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLE DB Provider by Sybase: Milliseconds in Time datatype are not passed by OLEDB Driver



CR:480065
CR Number:   480065
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#21 20 Dec 2007 Fixed
Description
OLE DB Provider by Sybase: RecordSet.Update() may case varchar column value to be truncated.



CR:480253
CR Number:   480253
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: ICommandText reference count not decremented when command times out. Issue resolved by providing clarifications on the Client code.



CR:480609
CR Number:   480609
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2007 Fixed
19 Oct 2007 Fixed
Description
SRVLIB: On certain platforms such as Sun Solaris and IBM AIX, Open Server may crash at srv__langcpy() when a client sends a command and then force close the connection without reading the result data.



CR:480639
CR Number:   480639
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using the Sybase OLEDB provider (sybdrvoledb.dll (15.0.0.152) ChangeDatabase call results in an unhandled exception.



CR:480653
CR Number:   480653
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Executing an insert statement that fires a trigger from Microsoft SQL Server Linked Server fails.
Target Version
 15.0 ESD#13



CR:480709
CR Number:   480709
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using the Sybase OLEDB provider (sybdrvoledb.dll (15.0.0.152)) and OleDbCommandBuilder.DeriveParameters is called for the connection, the OleDBTpye of the parameter is variant but should be varchar.



CR:480718
CR Number:   480718
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2013 Fixed
Description
Should work similar to the ServerVersion property that works in OLEDB driver.

Makes it easier to get the version number of the server.



CR:480768
CR Number:   480768
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   1.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2007 Fixed
07 Nov 2008 Fixed
Description
Allow the user to add index creation and insert statements in ASE Temp table creation wizard.



Resolution: Now the user can manually type in create index and insert statements in the ASE Temp table creation wizard and proper SQL annotation will be generated. With the annotation in place, indexes will be created and rows will be inserted at stored procedure execution/debug time.



CR:481086
CR Number:   481086
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ADO.net Driver cannot switch to a second query entry in sql.ini like ct_library program



CR:481097
CR Number:   481097
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 13 Nov 2007 Fixed
12.5.1 ESD#21 20 Dec 2007 Fixed
Description
ODBC Driver by Sybase: Calling SQLDisconnect crashes ODBC application if the underlying connection has been previously terminated by ASE.



CR:481121
CR Number:   481121
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Process on Cube in MS Analysis Server (OLAP), 10% of the time the load fails



CR:481241
CR Number:   481241
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   12.5.1 ESD#19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2012 EOL'd version. Not to be Fixed.
Description
cs_convert, On itanium does not double the quote and it truncates the string.



CR:481243
CR Number:   481243
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2007 Fixed
30 Oct 2007 Fixed
Description
CPRE: Clear a compilation warning message with routine _sqlsetintrerr() in file sybtesql.h. The message says "variable 'ret' may be used before its value is set". The message only appears on HP Itanium with OS version HPUX 11iv2.



CR:481483
CR Number:   481483
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2007 Fixed
08 Oct 2007 Fixed
09 Oct 2007 Fixed
29 Oct 2007 Fixed
Description
Improve memory handling for Dynamic SQL processing and result sets with compute-clauses.
Workaround Description
 None.



CR:481490
CR Number:   481490
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Apr 2008 Fixed
Description
Mechanism to truncate the RCM log file upon start-up



CR:481547
CR Number:   481547
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#12 08 Dec 2013 Fixed
1.1 ESD#21 08 Dec 2013 Fixed
Description
ADO.NET: Memory leak observed when connection is closed after an exception.



CR:481770
CR Number:   481770
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 12 Oct 2007 Fixed
03 Feb 2011 Fixed
Description
Organic OLEDB Provider: Simple select fails when executed from Linked Server



CR:481930
CR Number:   481930
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to provide information on using Distributed Transactions with jConnect



CR:481938
CR Number:   481938
Product Name:   Connectivity Utilities
Product Component:   dsedit
Status:   Closed
OS:   NA
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2007 Fixed
Description
DSEDIT: On Unix platforms, dsedit did not allow to enter ssl filter information such as ssl="cn=mycluster".
Workaround Description
 use dscp or manually edit the interfaces file to enter the filter information



CR:482022
CR Number:   482022
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#14 09 Mar 2009 Duplicate
Description
jConnect: Request to support T-SQL queries that include "COMPUTE" clause.



CR:482044
CR Number:   482044
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#22 21 Jan 2008 Fixed
15.0 ESD#12 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Get null values for varchar columns with size greater than 255.



CR:482064
CR Number:   482064
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request option in jConnect to "detect" it's in an XA (Global) transaction - throw an exception when transaction is lost. In this case, if some statement failed and the XA transaction is implicitly ended, when the next XA call is made by jConnect client, a SQLException is thrown to the affect of informing the client the XA transaction was ended

implicitly. At this point it's unknown if this requires some new status from ASE/DTM to client, or if this is even within the XA specification. This request comes up because of the ASE behavior to implicitly end an XA transaction when a trigger command fails, such as in duplicate insert, foreign key constraint error, explicit rollback commadn, etc.



CR:482280
CR Number:   482280
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 15 Nov 2007 Fixed
Description
OLE DB Provider by Sybase: Errors when accessing ASE resources from Linked Server using the 64-bit OLEDB Provider.



CR:482361
CR Number:   482361
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2012 Not a Bug
Description
Open Client 12.5.1 (all ESDs)



Please, add the following important recompilation information into EBF readme files for customer's orientation on how to proceed with his ctlib applications after applying latest EBFs:



- If the CTlib application is using the OCS shared libraries then there is no need to recompile or relink. Just overlay the ESD and the application should work.



- If the application is statically linked with the OCS static libaries then it needs to be relinked with the ESD OCS libs to use the ESD fixes.



- If the application is modified to use the new features introduced in the ESDs, then it needs to be recompiled and relinked



CR:482529
CR Number:   482529
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#11 06 Nov 2007 Fixed
1.1 ESD#21 14 Dec 2007 Fixed
Description
ADO.NET: Sending parameterized INSERT statement using DbType.String can cause overflow.
Workaround Description
 *** Wednesday, October 10, 2007 5:12:51 PM *** pvero ***

1. In their test app:



public static AseParameter AddParameter(AseCommand command, string paramName, DbType paramType)

{

AseParameter param = command.CreateParameter();

param.ParameterName = paramName;

param.DbType = paramType;

// add the size - forced the size to 255 - works

param.Size = 255; <----------------------------------- Add this and it works - customer could potentially apply this to a modified

version of their AddParameter method



command.Parameters.Add(param);



return param;

}



2. If I set the Parameter Size to 0 before setting the second value:



command.Parameters["@c1"].Size = 0;

// len 138

command.Parameters["@c1"].Value =



@"012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567";



Test succeeds with this change as well.



CR:482754
CR Number:   482754
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Tonga 21 Oct 2007 Fixed
12 Nov 2007 Fixed
Description
Go is interpreted incorrectly by the SQL parser for ASA SQL scripts.



Resolution: Make Go a keyword so that it will be treated as a statement terminator. But notice that the go cannot be used as an alias.



CR:482879
CR Number:   482879
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Customer sees internal error when processing dimension in MS Analysis Services.



CR:482964
CR Number:   482964
Product Name:   Database Development
Product Component:   Cheat Sheets
Status:   Closed
OS:   Generic
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Tonga 18 Oct 2007 Fixed
05 Nov 2007 Fixed
Description
1. Procedural object creation cheatsheet: When an object is edited, the Visual SQL dialog comes up and the user can form the query to add into the procedural object. The problem is that the location of the cursor is not remembered so the query always gets added to the end of the procedural object, which is not what the user intended.



2. Event Handler cheatsheet: Using this cheatsheet the user creates an event, completes the edit, and adds the query. If the user then attempts to add another query by using 'Click to redo,' the contents in the editor removes the header and the contents become as follows:



begin

print 'Replace this print line with your SQL statements'

end



instead of:



CREATE EVENT test34

ENABLE

AT ALL

HANDLER

begin

print 'Replace this print line with your SQL statements';

insert into T1 (c1)

values(9)

end



In addition, items edited before were not saved and are gone. It appear that the reason this problem occurs is that the editor is being reloaded every time 'Click to edit' or 'Click to redo' is selected in the cheatsheat.



For "eventhandlers", when the editor is loaded the code must be retrieved from the point of the header, which is before the begin statement.



CR:483060
CR Number:   483060
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#20
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2008 Fixed
15 Jan 2008 Fixed
Description
CPRE: cpre raises M_INTERNAL_ERROR when parsing extra large ESQL/C file.
Workaround Description
 Manually edit source file and remove the empty/blank lines.



CR:483143
CR Number:   483143
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   AIX
Original Version:   15.0 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2007 Fixed
02 Nov 2007 Fixed
19 Nov 2007 Fixed
Description
CTBCP: For fixed-length datatypes, bcp in may report error "cs_convert: cslib user api layer: common library error: The conversion/operation was stopped due to a syntax error in the source field." when using a data format file without any column separators.



CR:483149
CR Number:   483149
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2009 Duplicate
Description
ODBC Driver by Sybase: Setting the ADODB.Recordset.MaxRecords propaty does not limit the rows returned.
Workaround Description
 Use top command of SQL.



CR:483197
CR Number:   483197
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Sybase Data Source Administrator, getting 'Internal Error' with invalid password on Test Connect.



CR:483313
CR Number:   483313
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#20
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
21 Apr 2008 Fixed
Description
CPRE: cpre may take very long time to process an ESQL/C file containing a large number of continuous empty lines.
Workaround Description
 None known.



CR:483629
CR Number:   483629
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2008 Bundled Request
Description
Pre-TDS 5.0 clients encounter an error with OpenSwitch when not configured for full pass-through mode, with multi-byte character setting & differs from the character set as that of the client.



CR:483814
CR Number:   483814
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows XP
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2007 Fixed
Description
When the user switches to the Database Development perspective and then closes WorkSpace, error messages show in the ErrorLog view.



CR:483836
CR Number:   483836
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A statement "SELECT COLUMN INTO #PPP FROM TABLE" is executed and the transtate using select @@transtate returns 3, using the DataDirect driver the return is 1.



CR:483926
CR Number:   483926
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2007 Fixed
03 Jan 2008 Fixed
08 Aug 2008 Fixed
Description
CTLIB:ct_connect() leaks memory when the server is down.



CR:483939
CR Number:   483939
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2007 Fixed
15 Nov 2007 Added to user documentation
Description
A null pointer exception is thrown when generating DLL on IQ127(database node) with all options selected.



CR:483946
CR Number:   483946
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ADO error collection reports errors in reverse order when multiple errors are returned from a query batch.



CR:483954
CR Number:   483954
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Implicit conversion for datatype 'IMAGE' to 'VARBINARY' is not allowed, Use the CONVERT function to run this query



The error is raised when trying to call a stored procedure with a binary parameter through ADO.NET



CR:484459
CR Number:   484459
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLEDB driver raises exception "Domain error during implicit conversion of numeric value to a decimal field" when executing a stored procedure with a decimal value



CR:484460
CR Number:   484460
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 04 Feb 2008 Duplicate
12.5.1 ESD#21 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: DSNs created through Sybase Data Source Administrator cannot be created as system DSNs such that they can be used by any user on the system.



CR:484463
CR Number:   484463
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 08 Dec 2013 Fixed
12.5.1 ESD#21 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Missing Data Source definition produces "Invalid Port" error rather than "Data source not found and no default driver specified" error.



CR:484466
CR Number:   484466
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.15 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#11 04 Feb 2008 Duplicate
1.1 ESD#22 08 Dec 2013 Fixed
Description
ADO.NET: NullReferenceException thrown when disposing AseDataReader outside scope of using block with AseCommand.



CR:484469
CR Number:   484469
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#11 04 Feb 2008 Duplicate
1.1 ESD#21 08 Dec 2013 Fixed
Description
ADO.NET: Sending parameterized INSERT statement using DbType.String can cause overflow errors.



CR:484470
CR Number:   484470
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
To Be Determined
Description
OLE DB Provider by Sybase: Memory not released after ADODB.Recordset is closed.



CR:484471
CR Number:   484471
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#11 08 Dec 2013 Fixed
1.1 ESD#21 08 Dec 2013 Fixed
Description
ADO.NET: Using the same parameter name multiple times in a statement causes incorrect parameter errors.



CR:484473
CR Number:   484473
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#11 08 Dec 2013 Fixed
1.1 ESD#21 08 Dec 2013 Fixed
Description
ADO.NET: Provider does not raise an exception if a value for all parameters is not supplied.



CR:484519
CR Number:   484519
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2010 Fixed
Description
ODBC Driver by Sybase: The sp_odbc_datatype_info procedure gets error 2762 if it's executed in a transaction.
Workaround Description
 1> sp_dboption tempdb, 'ddl in tran', true

2> go



CR:484557
CR Number:   484557
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2007 Fixed
Description
DDL generated for ASE 15 failed to execute for table creation statements with double quoted identifiers.



Resolution: Added annotation in the generated DDL script to warn the user to set the quoted identifier preference correctly.



CR:484753
CR Number:   484753
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2007 Fixed
Description
Table schema editor doesn't show IQ Unique value for column correctly.



CR:484754
CR Number:   484754
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2007 Fixed
Description
1.The CONTAINS keyword in a query is seen as an error. (SQL File)

2. Not recognise no result set as a valid syntax.



CR:484977
CR Number:   484977
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2009 Fixed
27 Mar 2009 Fixed
07 Apr 2009 Fixed
06 Apr 2009 Fixed
Description
CTLIB: Add ability to call ct_send_data()w/o generating a 'writetext' sql command.



CR:485085
CR Number:   485085
Product Name:   Database Development
Product Component:   Online Help
Status:   Closed
OS:   Generic
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD1 03 Jan 2008 Fixed
Description
Database Development Tooling should be able to add INSERT statement in the temp table creation wizard.



CR:485230
CR Number:   485230
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2007 Fixed
Description
CERTREQ: When req_commonname in the input file specified with certreq -F contains spaces,

it will be truncated at the first space.
Workaround Description
 The workaround is to generate the certificate interactively or don't use spaces in

the common name.



CR:485263
CR Number:   485263
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for KeepAlive setting on the win socket



CR:485324
CR Number:   485324
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 21 Jan 2008 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Provider can't convert string value representing float value to OLEDB float type for an RPC call.



CR:485371
CR Number:   485371
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1 ESD#19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2008 Fixed
21 Feb 2008 Fixed
Description
SRVLIB:srv_poll() runs into assertion failure when processing more than one file descriptors.
Workaround Description
 None.



CR:485383
CR Number:   485383
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Sending a batch of parameters to insert multiple rows results in only one row being inserted.



CR:485409
CR Number:   485409
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Updating varchar column with Null value results in column value being set as a space (0x20).



CR:485411
CR Number:   485411
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
OLE DB Provider by Sybase: When retrieving Catalog View using SQL Server Management Studio get error 7346.



CR:485663
CR Number:   485663
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2008 Fixed
22 Jul 2008 Fixed
26 May 2008 Fixed
23 May 2008 Fixed
22 Jul 2008 Fixed
Description
With OpenSwitch running on UNIX platform, registered procedure 'rp_who' gives wrong 'rspid', for a client connected to it from Windows platform.
Workaround Description
 Turn off Full passthru mode if possible.



CR:485680
CR Number:   485680
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Feb 2008 Fixed
04 Mar 2008 Fixed
Description
CTLIB: ct_get_data() may crash in ct__tds_gd_process().
Workaround Description
 Use ct_bind() instead of ct_getdata()



CR:485704
CR Number:   485704
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer wants a property to retrieve current number of open connections



CR:485716
CR Number:   485716
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Poor performance when processing Cube/Dimension using parallelism.



CR:485743
CR Number:   485743
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Memory corruption with SSIS and preview Table List.



CR:485745
CR Number:   485745
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
15.0 ESD#12 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: When previewing SQL Command in SSIS get OLE DB error code 0x80004001.



CR:485784
CR Number:   485784
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2008 Fixed
22 Jul 2008 Fixed
22 Jul 2008 Fixed
22 Jul 2008 Fixed
22 Jul 2008 Fixed
Description
OpenSwitch may crash if TDS 4.6 client built by DB-Library, cannot connect to ASE via OpenSwitch under 'full pass through' mode when OpenSwitch and the client have different character sets.



OpenSwitch may crash in thrd_lock() or mtx_lock() functions.



CR:485809
CR Number:   485809
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#5 03 29 Apr 2008 Fixed
15.0 ESD#2 01 29 Apr 2008 Fixed
Description
AMD2 transaction abends with 0C4, reason code 10.
Workaround Description
 Since it is not possible to avoid loading SYGWXCPH CICS load module near the end of a 1-MB memory page, the workaround is to re-link SYGWXCPH and extend it with low-values using the Linkage Editor's IEWL EXPAND function



// EXEC PGM=IEWL,PARM='XREF,LIST,NORENT,AMODE=31,RMODE=ANY'

//SYSPRINT DD SYSOUT=*

//SYSLMOD DD DISP=SHR,DSN=....SYGWXCPH....LOADLIB

//SYSUT1 DD UNIT=WORK,SPACE=(CYL,(1,1))

//SYSLIN DD *

INCLUDE SYSLMOD(SYGWXCPH)

ENTRY TDVCONS

EXPAND TDGLOBAL(32768)

NAME SYGWXCPH(R)

/*



Now the COMP instruction will reference the extension of SYGWXCPH filled with low-values



CR:485824
CR Number:   485824
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.15 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2009 Duplicate
Description
ADO.NET: ExecuteReader(CommandBehavior.SingleRow) does not return any rows.



CR:485867
CR Number:   485867
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2007 Fixed
Description
LIBRARIES: Debug libraries for IBM AIX not correctly compiled with debug flags in ESD#11.



CR:485876
CR Number:   485876
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   AIX
Original Version:   12.5.1 ESD#20
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2008 Not a Bug
Description
Tested with Open Server 12.5.1 ESD#14 and ESD#20 for AIX 32-bits



When customer uses ct_init and ct_exit and executes application as asynchronous mode, a memory leak happens.

We need to remove ct_init and ct_exit to get the memory stablized.



CR:485908
CR Number:   485908
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2007 Fixed
Description
SRVLIB: Client using TDS version 4.6 fails to connect to Open Server in passthrough mode.
Workaround Description
 There is no way to set packet size larger than 512 bytes.



To disable ASE sanity check for login packets, use -T4066 in RUN Server file.

But it may be risky if a corrupted packet would be sent from a client.



CR:485986
CR Number:   485986
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows 2000
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2007 Fixed
Description
Content assist should be able to show column type info.



CR:485987
CR Number:   485987
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows XP
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2008 Fixed
Description
In WS2.0 Database Development perspective, open a external SQL file using "File -> Open File ...".

2. Do some modification to the SQL file.

3. Save and close the SQL file.

4. Reopen the SQL file.



CR:486138
CR Number:   486138
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2007 Not a Bug
Description
jConnect: Error converting client characters into server's character set.



CR:486219
CR Number:   486219
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 05 May 2010 Fixed
12.5.1 ESD#22 05 May 2010 Fixed
Description
ODBC Driver by Sybase: Driver does not set the TCP/IP keep alive property for the connection to ASE.



CR:486291
CR Number:   486291
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Selecting varchar columns in ASE from Linked Server results in one of these error messages 7347 or 7356 or 233.



CR:486432
CR Number:   486432
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 04 10 Dec 2007 Fixed
Description
RPC not found message is incorrect.



CR:486499
CR Number:   486499
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows XP
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2007 Fixed
Description
If the user extracts ASA table data as a sql file and opens this sql file in the

sql editor, the name of the connection profile is lost.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------