远程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:445762
CR Number:   445762
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)
18 Jan 2007 Fixed
15.0 ESD#8 23 Feb 2007 Fixed
Description
OLE DB Provider by Sybase: Unable to execute queries from Microsoft SQL Server using a Sybase ASE linked server.



CR:445837
CR Number:   445837
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2008 Fixed
22 Jan 2007 Fixed
11 Jun 2007 Fixed
26 Nov 2008 Fixed
Description
CM should detect network failure and reconnect when network restored
Workaround Description
 Reduce the following TCP parameters so TCP detects the network failure:

- tcp_keepalive_interval

- tcp_ip_abort_interval

If the network is restored before either of these parameters expire, no

further intervention is required by the administrator. If these either

of these parameters expire, the CM must be restarted.



CR:446011
CR Number:   446011
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLE DB Provider by Sybase: Test Connect on UDL via the Windows Desktop fails w/ MS VC++ runtime error



CR:446237
CR Number:   446237
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2006 Fixed
30 Nov 2006 Fixed
10 Jan 2007 Fixed
15 Nov 2006 Fixed
04 Dec 2006 Fixed
Description
DRIVERS: Replace Netscape LDAP libraries by OpenLDAP library on nt386.



CR:446383
CR Number:   446383
Product Name:   Open ClientCONNECT for IMS and MVS
Product Component:   Open ClientCONNECT for IMS and MVS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#4 01 05 Dec 2006 One-off Provided
Description
Fix 437253 missing from ESD3 release: OCC truncating varchar columns when followed by a varchar column.



CR:446414
CR Number:   446414
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2007 Fixed
01 Feb 2007 Fixed
Description
NETLIB: On Windows, ct_results() may report an error "ct_results(): network packet layer: internal net library error: Net-Library operation terminated due to disconnect" after a timeout.
Workaround Description
 Use esd#7/8



CR:446661
CR Number:   446661
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)
18 Jan 2007 Fixed
15.0 ESD#8 25 May 2007 Fixed
Description
OLE DB Provider by Sybase: Unable to execute a stored procedure from Microsoft SQL Server using a Sybase ASE linked server.



CR:446825
CR Number:   446825
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#4 02 23 Apr 2007 Fixed
Description
New listener should not run when started from a 3270 session.



CR:447275
CR Number:   447275
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.1 ESD#18 08 Dec 2013 Fixed
1.15 ESD#8 08 Dec 2013 Fixed
Description
ADO.NET: The sybdrvado11.dll (for 12.5.1 releases) or sybdrvado115.dll (for 15.0 releases) released in recent ESDs is not compatible with older ESDs. This does not allow multiple versions of the ADO.NET provider to be deployed concurrently.



CR:447292
CR Number:   447292
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows XP
Original Version:   Kon-Tiki
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.6 ESD1 22 Nov 2006 Fixed
Tonga 06 Jun 2007 Fixed
Description
Problem: Enterprise Explorer view throws exception when importing sql.ini and converting them into connection profiles.



Resolution: This issue has been fixed.
Target Version
 1.7



CR:447338
CR Number:   447338
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2006 Fixed
20 Nov 2006 Fixed
Description
DBLIB: DB_Library routines DBIORDESC and DBIOWDESC always return 0.
Workaround Description
 None known.



CR:447423
CR Number:   447423
Product Name:   Database Development
Product Component:   Creation Wizards
Status:   Closed
OS:   Windows XP
Original Version:   1.6 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.6 ESD1 12 Dec 2006 Fixed
Tonga 09 Jul 2007 Fixed
Description
Description: ASE Stored procedures that contain parameters with 'univarchar' type do not run correctly if the value of 'univarchar' is null. This issue only happens in ASE 12.5.2.x.



Resolution/Workaround: Change the default value of univarchar to ' ' (space).



Remaining issues:

If the user clicks on 'Null' checkbox in the Configure Parameters dialog, the stored procedure will be running forever.



Workaround:

User should avoid clicking check box 'Null' for univarchar in the Configure Parameters dialog, otherwise the stored procedure will be running forever; but the user can still click on the Terminate button to terminate the running stored procedure in SQL Results view.
Target Version
 1.6 ESD1



CR:447625
CR Number:   447625
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   IRIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2013 EOL'd version. Not to be Fixed.
Description
Open Server fails to shutdown after SRV_STOP is raised
Workaround Description
 Depending on the Open Server and how you shut it down,

you might be able to set "cis rpc handling" = 0 and then

issue your RPC to shut the server down.



CR:447730
CR Number:   447730
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6.ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#4 02 11 May 2007 Fixed
Description
Client Services Applications (CSAs) fail with a

message about the link to an Attachment Site Parms

not available.



CR:447813
CR Number:   447813
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2006 Duplicate
Description
dbpoll() returns DBTIMEOUT or never returns at all on version 15.0 dblibrary after a dbsqlsend() operation.
Workaround Description
 Avoid dbpoll() and use dbsqlsend() followed by dbsqlok(). Note: this defeats the purpose of using dbpoll().



CR:447910
CR Number:   447910
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#7 16 Jan 2007 Fixed
12.5.1 ESD#17 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Unable to export table from Microsoft Access to ASE when the Access table contains a text(255) column. The exact error received:



[Sybase][ODBC Driver][Adaptive Server Enterprise]

Can't specify a length or scale on type 'longsysname'



CR:448018
CR Number:   448018
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Nov 2006 Fixed
21 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
SRVLIB: When multiple clients connect to an openserver application and select text/image data from a multi-column table, the size of the openserver application grows very large and may exceed the memory limit of the process. On Windows platforms, a new user API srv_send_data() is provided to transfer text/image data through Open Server in small chunks.



CR:448089
CR Number:   448089
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2007 Not reproducible with latest version of the product available as of Resolution Date
Description
OLE DB Provider by Sybase: Unable to connect to ASE using Data Source Name from Visual Basic 6.0 applications.
Workaround Description
 Use IP:Port format for "Data Source" parameter for VB 6.0.



CR:448199
CR Number:   448199
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2007 Fixed
11 Jun 2007 Fixed
Description
ping_host blocks all activity on OpenSwitch
Workaround Description
 Set the PING_WAIT parameter to a very low value but be aware

that doing so risks raising false ping failures if the network is slow.



CR:448251
CR Number:   448251
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jan 2007 Fixed
Description
OpenSwitch disconnects CM if cm_kill fails



CR:448369
CR Number:   448369
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: When reading a varchar output parameter from a stored procedure, provider returns empty string.



CR:448393
CR Number:   448393
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In 12.5.1 all certificates are returned to the client SSL validation callback but in 15.0 only the server certificates and the first CA certificate is returned.



CR:448483
CR Number:   448483
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)
Description
Customer wants to know if we support Linked server between Microsoft SQL and ASE in cluster environment. (Follow up on case CR 420176).



CR:448503
CR Number:   448503
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   all
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
oslib.loc lists SRV_EBADCOMPUTBY instead of SRV_EBADCOMPUTEBY



CR:448508
CR Number:   448508
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD1 28 Nov 2007 Fixed
03 Jan 2008 Fixed
Description
Should not use ASA debugger API to retrieve SP definition.

Also, the DDL gen wizard should not use the Debug API to retrieve procedural object definitions for ASA/IQ.



CR:448550
CR Number:   448550
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   HP-UX
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2012 Fixed
09 Nov 2012 Fixed
29 Oct 2012 Fixed
Description
ESQL: sqlerr[2] does not reflect the number of rows affected by the most recent command when ASE error 9501 is returned.



CR:448598
CR Number:   448598
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows XP
Original Version:   1.6 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.6 ESD1 04 Dec 2006 Fixed
Description
Problem: An overflow error occurs after the user expands and clicks the subscription node under a Replication Server connection profile.



Resolution: This issue has been fixed.
Target Version
 1.6 ESD1



CR:448956
CR Number:   448956
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2006 Fixed
Description
SRVLIB: When multiple clients connect to an Open Server application and select text/image data from a multi-column table, the size of memory used by the Open Server application grows very large and may exceed the memory limit of the process. A new user API srv_send_data() is provided to transfer text/image data through Open Server in small chunks. Sample program ctos is also updated to use this new API.
Workaround Description
 None.



CR:449013
CR Number:   449013
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Need various CM APIs to return more meaningful status than CS_SUCCEED/CS_FAIL



CR:449103
CR Number:   449103
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2006 Fixed
Description
OLEDB: Provided an upgrade of the OpenSSL components embedded within the driver. The new OpenSSL version is 0.9.8d.



CR:449105
CR Number:   449105
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2006 Fixed
Description
ODBC: Provided an upgrade of the OpenSSL components embedded within the driver. The new OpenSSL version is 0.9.8d.



CR:449204
CR Number:   449204
Product Name:   jConnect
Product Component:   Ribo
Status:   Open
OS:   Solaris
Original Version:   6.5 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Ribo raises exception when reading TDS_BUF_ATTN token
Workaround Description
 Use the old "tds" utility if you have it.



CR:449274
CR Number:   449274
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request redo of OpenSwitch PING functionality



CR:449514
CR Number:   449514
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT DOC
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 02 27 Aug 2007 Fixed
Description
After migration to MFC 12.6 ESD#2, the ct is getting repeated paired messages as the

followings in the CICS log:

> EZY1261I 22/11/06 08:21:08 EZACIC03 ATTACH SUCCESSFUL, TCB ADDRESS=00895988 TERM=

TRAN=AMD2 TASK=0001965

> EZY1278I 22/11/06 08:21:08 EZACIC03 DETACH SUCCESSFUL TCB ADDRESS=00895988 TRAN=AMD2

TASK=0001965



CR:449515
CR Number:   449515
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLE DB Provider by Sybase: Superfluous prepare calls being made resulting in poor provider performance.



CR:449516
CR Number:   449516
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Unlike the third-party drivers, Sybase Organic OLE DB (& ODBC) drivers do not provide any HELP button on any of the DSN configuration tabs to explain the various config settings.



CR:449680
CR Number:   449680
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2007 Fixed
Description
jConnect: An empty scrollable resultset causes SQLException when ResultSet.beginFirst() is called.
Workaround Description
 Customer using IDIP = true



CR:449927
CR Number:   449927
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 06 Feb 2008 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Executing a stored procedure via OpenQuery() on a Linked Server fails.



CR:449958
CR Number:   449958
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Open
OS:   Generic
Original Version:   1.6 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If the stored proc uses a variable which contains more than 250 characters, only the first 255 characters will be displayed int he variables view



CR:449987
CR Number:   449987
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#8 08 Dec 2013 Fixed
Description
Request for Winx64 OLEDB Provider for ASE



CR:450003
CR Number:   450003
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Solaris
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect sets an invalid length in PARAMFMT tokens for numeric parameters



CR:450056
CR Number:   450056
Product Name:   Database Development
Product Component:   Query Editor
Status:   Closed
OS:   Generic
Original Version:   1.6 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.7 05 Sep 2007 Fixed
Description
The fact to modify a stored proc in Wspace and re-deploy it, will delete the previous grand execute permission



CR:450057
CR Number:   450057
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Generic
Original Version:   1.6 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2007 Presently Not Targeted For Any Future Release Of This Product
Description
Error message : Column can be appended only to an existing table from database explorer when altering a table by clicking Insert column



CR:450079
CR Number:   450079
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jan 2007 Fixed
25 Feb 2007 Fixed
Description
SRVLIB:srv_createmutex() may cause memory corruption when the actual length of a mutex name is larger than the specified length.



CR:450084
CR Number:   450084
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2007 Fixed
Description
OLE DB Provider by Sybase: Provider throws data overflow errors in Visual Basic application.



CR:450087
CR Number:   450087
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Provider returns error when passing null parameter values of some datatypes to stored procedures.



CR:450118
CR Number:   450118
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#12 06 Feb 2008 Fixed
Description
OLE DB Provider by Sybase: Calling a stored procedure on a Linked Server via OpenQuery() or direct execution fails.



CR:450378
CR Number:   450378
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
5.5 metadata scripts for 12.5.X ASE missing sp_version



CR:450386
CR Number:   450386
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2007 Fixed
15.0 ESD#8 25 May 2007 Fixed
Description
OLE DB Provider by Sybase: Unable to update datetime columns from Microsoft SQL Server using a Sybase ASE linked server.



CR:450478
CR Number:   450478
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#17
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: SQL Update fails when called from Linked Server and syntax contains a 'where' clause



CR:450480
CR Number:   450480
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#17
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: Insert fails from Linked Server when no column names are included in syntax



CR:450481
CR Number:   450481
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#17
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 delete fails when called from Linked Server



CR:451726
CR Number:   451726
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2007 Bundled Request
11 Jun 2007 Fixed
Description
OpenSwitch fails to detect a hung ASE and initiate a failover



CR:451776
CR Number:   451776
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#11 31 Oct 2007 Fixed
1.1 ESD#21 08 Dec 2013 Fixed
Description
ADO.NET: Long text data is truncated during insert when using IDbCommand / IDbDataParameter interfaces.
Workaround Description
 Use the native ASE ADO.NET interfaces (AseCommand & AseParameter). Using these interfaces will let user specify the AseDbType to Text, which allow longer strings to be stored without truncation.



CR:451845
CR Number:   451845
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Linux
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2007 Fixed
25 Sep 2007 Fixed
Description
CTBCP: For fixed-length datatypes, bcp in with no row separators may report error "cs_convert: cslib user api layer: common library error: The result is truncated because the conversion/operation resulted in overflow".



CR:452135
CR Number:   452135
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#8 26 Jun 2007 Fixed
Description
jConnect: DatabaseMetaData functions report SQLAnywhere stored procedure output columns as unknown.



CR:452275
CR Number:   452275
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
In VB.net or c# program, connecting to ASE 12.5.3 via ADO.NET 1.1.5xx.0,

when doing update with a varchar parameter without specifying "Size" property,

and the actual parameter value is a string including simplified chinese chars and

the size of actual string parameter is more than 255 bytes,

exception "Data Overflow ......" would happened.
Workaround Description
 explicitly specify the size of the parameter in byte e.g.

insertCmd.Parameters(0).Size = 260



CR:452382
CR Number:   452382
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jan 2007 Fixed
04 Feb 2007 Fixed
Description
EXAMPLES: ctos sample bulk handler cannot handle arrayinsert.



CR:452444
CR Number:   452444
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   1.6 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.7 01 Feb 2007 Fixed
Tonga 01 Mar 2007 Fixed
1.7 01 Feb 2007 Fixed
26 Oct 2007 Fixed
Tonga 13 Feb 2007 Fixed
Description
Problem Descriptions:

WorkSpace crashes when executing a stored procedure with a huge number (5000) of result sets.



Solutions:

1. Added Eclipse preference under 'Sybase, Inc.-->Database Development-->SQL Results view' to limit the number of result sets can be displayed in the SQL Results view in Multiple window display mode and Single window/Grid display mode. When the limit is reached, a proper warning message will be displayed as a tab in the SQL Results view.

2. If the user wants to examine a large number of SQL result sets after a stored procedure execution, the user can use the SQL Results view context menu "Save All Results' to save the result sets into a text file.

3. All procedural object execution are now put in a separate job, and a progress monitor will be displayed to allow the user to cancel or put in the background.
Target Version
 1.7



CR:452557
CR Number:   452557
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   Microsoft Windows NT
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
notepad.exe editing of libtcl.cfg file creates entries unable to be parsed by the kerberos driver, libsybskrb.dll.



CR:452767
CR Number:   452767
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2009 Fixed
Description
Customer wants OpenSwitch 15 certified on Solaris 2.10



CR:452897
CR Number:   452897
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)
15.0 ESD#2 01 18 Jun 2008 Fixed
Description
OSC/OCC to support Mixed Case Passwords, a new feature as of Z/OS 1.7 . See "New Features. Mainframe Connect 15.0"



CR:453017
CR Number:   453017
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   AIX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2009 Fixed
Description
Customer wants OpenSwitch certified on AIX 5.3



CR:453167
CR Number:   453167
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Windows 2003
Original Version:   1.6 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.7 04 Feb 2007 Fixed
Description
Problem Descriptions:

When using 'Save' or 'Save As' context menu in Database Explorer perspective to save the exported table syntax to a SQL file, the charset was not set automatically to UTF-16, which is the default charset used when exporting table syntax, hence the user need to manually set the SQL file 'charset' property to UTF-16 to be able to read the SQL file.



Solutions:

Database Explorer perspective will set the SQL File charset to UTF-16 automatically when saving the exported table syntax.
Target Version
 1.7



CR:453235
CR Number:   453235
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#8 08 Dec 2013 Fixed
12.5.1 ESD#18
Description
ODBC Driver by Sybase: SQLGetTypeInfo returns incorrect type mapping for unichar and univarchar datatypes.



CR:453264
CR Number:   453264
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currenty jConnect obtains and sends the initial opaque security token in line with login processing. Request that the initial opaque token that is sent to ASE be one which requires no negotation with ASE given that currently only NETWORKAUTH is supported.



CR:453463
CR Number:   453463
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2007 Fixed
06 Mar 2007 Fixed
Description
EXAMPLE: ctos dumps core when "isql -X" connects to it.



CR:453574
CR Number:   453574
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Windows XP
Original Version:   1.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Tonga 07 Sep 2007 Fixed
Description
Allow regular ASE logins to view table definitions in WorkSpace-->DataBase Explorer even though 'Select' permission is turned off for that user.



CR:453601
CR Number:   453601
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Generic
Original Version:   1.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.7 27 Feb 2007 Fixed
Description
Problem description:

Database Explorer uses incorrect terminator for ASE when exporting table syntax.



Solution:

In Workspace 1.7, Database Explorer uses "go" as the statement terminator for ASE when exporting table syntax or logging activity.



CR:453714
CR Number:   453714
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 12 Oct 2007 Fixed
03 Feb 2011 Fixed
Description
OLE DB Provider by Sybase: From a Microsoft SQL Server linked server connection, cannot use a nullable column in the where clause.



CR:453895
CR Number:   453895
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC Driver by Sybase: SQLExecDirect fails with DELETE when using ODBC Cursor library and Microsoft Foundation Classes (MFC).
Workaround Description
 Customer using DataDirect driver for now - this is a migrating issue.



CR:453987
CR Number:   453987
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2007 Fixed
24 Apr 2007 Fixed
Description
CPRE: When parsing a structure or union type definition with one or more fields of user defined non-structure or non-union types, cpre incorrectly reports a syntax error "M_SYNTAX_PARSE".



CR:454054
CR Number:   454054
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2007 Fixed
Description
jConnect: Login attempt does not timeout when firewall has blocked the outbound connection.
Workaround Description
 Customer is using the free jdbc driver, jtds, from sourceforge



CR:454109
CR Number:   454109
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2007 Fixed
27 Mar 2007 Fixed
Description
BLKLIB: Open Server application calling blk_getrow() may lose file descriptor when bcp is run against it with -b1 option.



CR:454252
CR Number:   454252
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2007 Fixed
07 Mar 2007 Fixed
Description
BLKLIB: Bulk copy of NULL text columns may fail in gateway application.



CR:454376
CR Number:   454376
Product Name:   Open ServerCONNECT for IMS and MVS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS IMS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#4 05 11 May 2007 Fixed
Description
Memory leak in DB2 CSPs.



CR:454499
CR Number:   454499
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2007 Fixed
Description
SRVLIB: Under certain circumstances srvlib will core while attempting to parse interface file information.



CR:454631
CR Number:   454631
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 12 Oct 2007 Fixed
03 Feb 2011 Fixed
Description
OLE DB Provider by Sybase: From a Microsoft SQL Server linked server connection, inserting into a table with float or nchar columns cause Insert to fail.



CR:454786
CR Number:   454786
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 May 2007 Fixed
Description
jConnect: Implement Extended Password Encryption feature for jConnect.



CR:455098
CR Number:   455098
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
aries 04 Oct 2012 Not a Bug
Description
Customer tries to store Euro symbol in database. He is aware the iso_1 character set doesn't include it, but as long as the client simply forwards the Windows character (hex value) and stores it, it can be extraced without problems. .NET does not work.



CR:455150
CR Number:   455150
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#18 08 Dec 2013 Fixed
1.15 ESD#9 08 Dec 2013 Fixed
Description
ADO.NET: Connection pooling does not work as expected when Microsoft DTC is in use.



When using MSDTC with Sybase ADO.NET Pooling feature to connect to ASE, Pooling is not working. In ASE, we will see all physical connections instead, which may lead ASE to exceed maximum number of connections.



CR:455310
CR Number:   455310
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#19 08 Dec 2013 Fixed
15.0 ESD#9 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Accessing linked tables in ASE from Microsoft Access 2002, receives "Function sequence error" after Access changes Autocommit settings.



CR:455488
CR Number:   455488
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2007 Fixed
Description
Legacy Open Server is sporadically crashing in ct_connect and com__err_load_sect



CR:455785
CR Number:   455785
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2007 Fixed
09 May 2007 Fixed
Description
NETLIB: On HP, Open Server rejects connection when setsockopt() returns EINTR.



CR:455958
CR Number:   455958
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2007 Fixed
11 Jul 2007 Fixed
23 Jul 2007 Fixed
07 Aug 2007 Fixed
Description
BCP:Implement BCP new command line option --skiprows to indicate how many rows should be skipped from the begining of the input file. BCP will start copying right after the skipped rows.
Workaround Description
 Continue using bcp from the older release.



CR:455979
CR Number:   455979
Product Name:   Open Client
Product Component:   cslib
Status:   Open
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance CS_STICKY_BINDS error to include reason for discarding binds



CR:456062
CR Number:   456062
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Windows XP
Original Version:   1.6 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2007 Presently Not Targeted For Any Future Release Of This Product
Description
A JDBC Connection under DB Explorer does not allow access to Stored Procs
Workaround Description
 Is to use a SYBASE ASE connection profile instead of the JDBC one



CR:456141
CR Number:   456141
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2007 Fixed
03 Apr 2007 Fixed
Description
BCP,DEFNCOPY: bcp and defncopy may fail when the multi-byte table name parameter contains either 0x5b or 0x5d in the lower byte.



CR:456361
CR Number:   456361
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
CS_STICKY_BINDS discards binds when an ASE error is returned instead of the expected result set.
Workaround Description
 retrieve CS_HAVE_BINDS property with ct_cmd_props

if CS_HAVE_BINDS is CS_FALSE

bind variables with ct_bind

end if

while ct_fetch returns CS_SUCCEED or CS_ROW_FAIL

process row data

end while



CR:456574
CR Number:   456574
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   1.1 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ADO.NET Occasional AccessViolationExceptions when running NET 2.0 asp page

with bittype on commit statement.



CR:456617
CR Number:   456617
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2007 Fixed
Description
CTLIB:Incomplete release of memory on connection close.



CR:456633
CR Number:   456633
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)
05 Jun 2007 Fixed
12.5.1 ESD#19 08 Dec 2013 Fixed
12.5.1 ESD#19 08 Dec 2013 Fixed
12.5.1 ESD#19 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: The Provider does not throw error when "Ignore Errors If Results are Pending" option set to false.



CR:456696
CR Number:   456696
Product Name:   jConnect
Product Component:   Ribo
Status:   Open
OS:   Solaris
Original Version:   6.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Ribo raises exception when reading token 0x7C, TDS_PROCID
Workaround Description
 Use the old "tds" utility if you have it.



CR:456773
CR Number:   456773
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Closed
OS:   Windows XP
Original Version:   1.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Tonga 24 Apr 2007 Presently Not Targeted For Any Future Release Of This Product
06 Mar 2007 Fixed
Description
Problem Descriptions:

When the user creates a single trigger with all 3 activation types, i.e., insert, delete and update, and creates another trigger with either insert or update,

and then user modifies and saves the aforementioned 'all' trigger, where the SQL Editor drops the 'all trigger' and recreates it, as in ASE, there is no ALTER TRIGGER command. Thus, in this process ASE server deletes the insert or update trigger as user is re-creating the all action trigger.



In this situation, when we have breakpoint in a trigger in the now deleted 'insert' (or 'update') trigger, ASE servers will get a stack trace during trigger debugging, as there is a breakpoint but the object does not exist any more.



Please refer to the 'Trigger Restrictions' below.



(http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.docset.ase_15.0/title.htm)

-----------------------------------------------

Trigger Restrictions

Adaptive Server imposes the following limitations on triggers:

A table can have a maximum of three triggers: one update trigger, one insert trigger, and one delete trigger.

Each trigger can apply to only one table. However, a single trigger can apply to all three user actions: update, insert, and delete.



Workaround:

The user will need to remove all the breakpoints for the trigger that got deleted, in this case, remove all the breakpoints for the trigger_INS or any trigger that does not exist any more (deleted by the ASE server), only then user can start using the debugger as before.
Target Version
 1.7
Workaround Description
 Here we have two issues,

1. the trigger getting deleted without any warning, but this issue we cannot do anything as that is the ASE server restriction

2. The debugger is not getting kicked in because there is a breakpoint for an object that does not exist, for this we have a workaround, the workaround is: the user will need to remove all the breakpoints for the trigger that got deleted i.e basically in this case remove all the breakpoints for the trigger_INS, only then user can start using the debugger as before.



CR:456778
CR Number:   456778
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2007 Fixed
26 Jul 2007 Fixed
Description
SRVLIB: Open Server loses table and column names when transferring text columns. An error message similar to "Server Message: Server Name: Incorrect syntax near 'from'" will be generated.



CR:456862
CR Number:   456862
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   1.6 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Tonga 08 May 2007 Fixed
Description
Database View, Stored Procedures, when Browsed and not sorted in alphabetical order.



CR:460863
CR Number:   460863
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
oslib.loc lists SRV_ELARGBUF instead of SRV_ELARGEBUF



CR:460882
CR Number:   460882
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Closed
OS:   Windows XP
Original Version:   1.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Tonga 13 Jul 2007 Fixed
06 Mar 2007 Fixed
Description
Known Problem:

During trigger debugging using SQL Debugger in the Database Development Tooling, if the tigger contains SQL statements that reference views that are derived from the trigger table, the end user will not be able to see the contents of the view in the Referenced Tables View during debugging, but the debugging session is not affected.
Target Version
 1.7



CR:461195
CR Number:   461195
Product Name:   Open Client
Product Component:   dblib
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2008 Fixed
Description
DBLIB: dblib applications now use utf8 encoded message files.



CR:461225
CR Number:   461225
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2007 Fixed
02 Apr 2007 Fixed
Description
EXAMPLE: ctlib sample application wide_dynamic fails when run against Open Server application ctos.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------