远程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:376214
CR Number:   376214
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#10 23 Aug 2005 Fixed
Description
ODBC Driver by Sybase: Request support for SQLDriverConnect SQL_DRIVER_COMPLETE / SQL_DRIVER_COMPLETE_REQUIRED. ODBC Driver will try to connect if the connect string has enough information.



CR:376428
CR Number:   376428
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jun 2006 Fixed
Description
Added support for ASE 15.0 Features .

> support bigint

> support unsigned datatypes ( unsigned smallint, unsigned int, unsigned bigint)

3> Support Server Side packet Size



CR:376836
CR Number:   376836
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Unknown
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2006 Fixed
04 Aug 2006 Fixed
Description
CTBCP: Performance fixes; 1: bcp-in in character mode, 2: bcp_r all uses.



CR:377181
CR Number:   377181
Product Name:   jConnect
Product Component:   Ribo
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0 ESD#2 18 Jan 2005 Fixed
Description
ribo: Getting exception when large REAL (float) value is encountered in the TDS steam.



CR:377257
CR Number:   377257
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Linux
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2005 Fixed
22 Mar 2007 Fixed
Description
SRVLIB: On Linux Itanium 64-bit, Linux AMD 64-bit and Linux on POWER 64-bit, the minimum stack size (SRV_MINSTACKSIZE) is not sufficient. The new limit is now increased from 131072 to 196608.



CR:377290
CR Number:   377290
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)
16 Feb 2006 Fixed
08 Mar 2006 Fixed
Description
CTLIB: Setting the null indicator variable should take precedence over the settings of data and data length in the ctlib routines.
Workaround Description
 set data = non-null which should give the proper datatype of CS_CHAR or CS_LONGCHAR (account for the longer length of the variable). or use the combination of data = null and datalen = CS_UNUSED.



CR:377684
CR Number:   377684
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2006 Fixed
27 Apr 2006 Fixed
Description
ISQL: The display for multiple-byte character can be corrupted when ISQL starts a new line in the middle of a multiple-byte character.
Workaround Description
 You may be able to avoid this corruption by using -w option with large value such as 10000.



CR:377765
CR Number:   377765
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#8 19 Apr 2005 Fixed
Description
ADO.NET: Cannot retrieve output parameter from AseDataAdapter, if Connection is closed before retrieving the output parameter value.



CR:377921
CR Number:   377921
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.09 12 21 Apr 2005 Fixed
Description
For an instream remote procedure call, input parameters were not parsed correctly.



CR:378314
CR Number:   378314
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Apr 2005 Fixed
19 Apr 2005 Fixed
Description
SRVLIB: Open Server with SRV_TR_DEFQUEUE does not display complete index number in error log.



CR:378484
CR Number:   378484
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2006 Fixed
Description
OLE DB Provider by Sybase: Request support for distributed transactions for MS DTC applications.
Workaround Description
 n/a



CR:378488
CR Number:   378488
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#9 15 Jul 2005 Fixed
Description
Sybase ODBC: Request that Sybase ODBC driver will support distributed transactions for MS DTC applications etc.
Workaround Description
 n/a



CR:378538
CR Number:   378538
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)
Description
OLEDB: Use of IID_IMultipleResults for refiid does not return error code from ICommand:Execute() call in the return code.



CR:378679
CR Number:   378679
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2005 Fixed
5.5 ESD#15 22 Mar 2005 Fixed
5.5 ESD#15 22 Mar 2005 Fixed
Description
jConnect: DatabaseMetaData.getProcedureColumns() returns NULL for ASA stored procedures using double datatype.



CR:378823
CR Number:   378823
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2005 Fixed
5.5 ESD#18 13 Jan 2006 Fixed
Description
jConnect: Request to support IPv6 network protocol.



CR:378944
CR Number:   378944
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2006 Fixed
31 Jan 2006 Fixed
Description
OLE DB Provider by Sybase: Add support for Client-side cursor engine, which is invoked by setting CursorLocation property to adUseClient.



CR:379156
CR Number:   379156
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)
21 Mar 2005 Duplicate
Description
bcp -Y option can not convert small Roman numerals between sjis and eucjis.



CR:379160
CR Number:   379160
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)
22 Mar 2005 Duplicate
Description
bcp -Y option can not convert utf8 data from utf8 client.



CR:379511
CR Number:   379511
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 Beta2 09 Feb 2005 Fixed
Description
Driver should support -1 as a valid setting for Packet Size and then use the optimal packet size for future connections.

Driver does support -1 as a valid setting but defers to ASE to decide the optimal packet size



CR:379612
CR Number:   379612
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
CT-Lib: Open Client applications send CS_LONGCHAR_TYPE parameters to servers that have un-set the CS_DATA_LCHAR request capability.
Workaround Description
 Client applications could be coded to check all relevant capabilities.



CR:379803
CR Number:   379803
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2006 Fixed
17 Apr 2007 Fixed
Description
Connections may acccumulate many SQLWarnings if the applications are not clearing warnings, getting warnings and are issuing sql that causes many warnings. In the persistent connecton environment, like connection pooling, this can take the appearance of memory leaks.



This CR would limit the number of SQLWarnings chained off a connection object under the assumption that the use does not care about the warnings but does not want to suffer lost memory thru the chained SQLWarnings. Suggest default number of queued SQLWarnngs equal to 5.



CR:379952
CR Number:   379952
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2005 Fixed
10 Mar 2005 Fixed
07 Mar 2005 Fixed
Description
CS_PARAM_RESULT and CS_STATUS_RESULT should send SRV_DONE_FINAL as last done.



CR:380009
CR Number:   380009
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2006 Fixed
23 May 2006 Fixed
Description
SRVLIB: jConnect client application might hang when multiple batch update statements or option commands are run against Open Server application.



CR:380112
CR Number:   380112
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 MAP126_021 15 Apr 2005 Fixed
12.50.10 005 31 May 2006 Fixed
Description
The TCP/IP Listener needs to be enhanced to handle more Sockets



CR:380175
CR Number:   380175
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
Open Server: Applications should be able to send non-null zero length values for example empty strings ("").
Workaround Description
 None.



CR:380235
CR Number:   380235
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Customer would like to be able to turn tracing on or off in APST



CR:380342
CR Number:   380342
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.05 15 Apr 2005 Fixed
Description
Customer needs QTS 366986 back ported release OSC 12.50.05 (EBF11927)

(QTS 366986 fixes TCP/IP Resets)



CR:380427
CR Number:   380427
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 May 2005 Fixed
15 Jun 2005 Fixed
Description
SRVLIB: On Windows, open server applications show memory leaks when handling a large number of clients continuously connecting/disconnecting.
Workaround Description
 None.



CR:380537
CR Number:   380537
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PROXY connection property usage always throws an exception with SSL setup



CR:380652
CR Number:   380652
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2005 Fixed
13 Jul 2005 Fixed
Description
During a network failure, OpenSwitch will not switch connections until the

"timeout" period expires. The "timeout" being the smallest of the "tcp_ip_abort_interval"

on the operating system or the RESPONSE_TIMEOUT from the OpenSwitch.cfg file.
Workaround Description
 Specify a small tcp_ip_abort_interval to help quickly detect network failures.

Continue to use RESPONSE_TIMEOUT to timeout queries that run too long.



CR:381575
CR Number:   381575
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Microsoft Win32s
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Apr 2005 Fixed
19 May 2005 Fixed
Description
DB-Lib: command timeout set by dbsettime() produces the following read error 20004:-

"DB-Library error: Err 20004, Sev 2 - Cannot perform more than one read"
Workaround Description
 Use DB-Lib 12.5.0



CR:381576
CR Number:   381576
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   HP-UX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2005 Fixed
Description
Feature request for a new CM API that allows issuance of any rp_ type administrative

call to OpenSwitch.



CR:381794
CR Number:   381794
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2005 Fixed
Description
jConnect: Unable to retrieve rowcount with Statement.getUpdateCount() if Statement.getResultSet() is called first.



CR:381847
CR Number:   381847
Product Name:   ESQL
Product Component:   C
Status:   Open
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Programmers would like to be able to have standard header files like <inttypes.h> parsed properly within esql/c programs so that he may use datatypes in the exec sql declare sections as variables without having to do his own typedefs or make his own custom built header files.



Currently if the header files have both C++ and C syntax in them, esql/c will not handle the parsing properly. Standard OS header files routinely include both C++ and C typedefs.
Workaround Description
 make user customer header files or use typedefs in the exec sql declare sections.



CR:381963
CR Number:   381963
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)
02 Aug 2012 Duplicate
Description
SRVLIB: Open Server incorrectly reports the CS_DATAFMT.maxlength of CS_LONGCHAR params as their 'actual' length instead of the maxlength as set by the client application.
Workaround Description
 Ignore CS_MAXLENGTH values for CS_LONGCHAR params.



CR:382506
CR Number:   382506
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2005 Fixed
19 May 2005 Fixed
Description
CPRE: When using typedef to define types, all these types except structure and union types have incorrect scopes.



CR:382539
CR Number:   382539
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)
Description
OLEDB: Hang occurs on ADO RecordSet.Open when CursorLocation=adUseClient, and Select Method=Direct.



CR:382558
CR Number:   382558
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 08 13 Apr 2006 Fixed
Description
MFC Server Option for CICS is not compatible with JAVA programs running within the same CICS
Workaround Description
 Hi Kevin,

We ran the test again, but this time we initialized Sybase from the SYOP transaction and Java worked both before and after Sybase was initialized.



Leroy,

As a work around for Scott, can we leave Sybase out of the PLT and add SYOP to the sequential terminal? Let me know if I can help (e.g., If you tell me the regions that use sybase, I'll update the sequential terminals).



CR:382748
CR Number:   382748
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)
Description
OLEDB: Getting error indicating not a valid type when setting SybaseServerName in a UDL configuration.



CR:382772
CR Number:   382772
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)
Description
OLE-DB: VB appl gets Access violation in RecordSet.CancelUpdate
Workaround Description
 Unknown.



CR:382962
CR Number:   382962
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 31 Jan 2006 Fixed
12.5.1 ESD#12 31 Jan 2006 Fixed
Description
OLE DB Provider by Sybase: Provider is missing support for Bookmarks and Client-side scrollable cursor library. Issues with binding recordsets to controls.
Workaround Description
 None.



CR:383302
CR Number:   383302
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2005 Duplicate
Description
As a result of DB2 deadlock over an extended period of time, Sybase TCP/IP listener CICS transaction SYLB's main program IBMLSTNR repeated outputs the following error message until cancelled by CICS with an AICA abend (runaway CICS task)

>SYBASE 10:05:57 TRANID SYLB TSKNO 69206 EXCEPTION SOCKET NOT FOUND

>SYBASE 10:05:57 TRANID SYLB TSKNO 69206 EXCEPTION SOCKET NOT FOUND

> ...



CR:383307
CR Number:   383307
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.50.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.09 MAP1259006 15 Apr 2005 Fixed
Description
OSC CICS - The Context Handler transaction would not free task storage while the Client stayed connected. That was corrected



CR:383363
CR Number:   383363
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 31 Jan 2006 Fixed
12.5.1 ESD#12 31 Jan 2006 Fixed
Description
OLE DB Provider by Sybase: Application receives "Object or provider is not capable of performing requested operation." error when calling Connection.Execute() method specifying adOpenKeyset CursorType.
Workaround Description
 Use DataDirect provider?



CR:383622
CR Number:   383622
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 08 Apr 2005 Fixed
5.5 ESD#15 08 Apr 2005 Fixed
27 Nov 2006 Fixed
27 Nov 2006 Fixed
Description
jConnect: Client connection properties not migrated when OpenSwitch fails over a jConnect client connection. When jConnect makes a connection to ASE, it sets up the connection with default properties such as Auto-commit, Isolation Level, Quoted Identifier and Text Size. These properties do not get migrated when fail-over occurs.



CR:383724
CR Number:   383724
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.09 MAP1259006 29 Mar 2005 Fixed
Description
OSC - The iso_1 translation overrides to SYGWMCXL macro would not take effect. These issues were previously reported for problems 374005 and 373827, now they were fixed.



CR:383983
CR Number:   383983
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2005 Fixed
25 Aug 2005 Fixed
Description
OLEDB Provider by Sybase: Feature request to support Scrollable RowSet.



CR:383985
CR Number:   383985
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Aug 2005 Fixed
25 Aug 2005 Fixed
Description
OLE DB Provider by Sybase: rsData.MoveLast call not supported by OLE DB Provider.



CR:384072
CR Number:   384072
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
Done in proc related rowsets are always generated by SQL batches when only a few specific cases should return them.



CR:384258
CR Number:   384258
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)
Description
OLE DB: ADO applications which begin transactions using Connection.BeginTrans may hang in RecordSet.Open when the LockType is set to anything except adLockReadOnly.
Workaround Description
 Set "Select Method = Cursor"

or LockType to adLockReadOnly



CR:384285
CR Number:   384285
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2005 Fixed
29 Jul 2005 Fixed
03 Jun 2005 Fixed
Description
Customer needs memory efficient way to send large image data through OpenSwitch



CR:384600
CR Number:   384600
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2005 Fixed
19 May 2005 Fixed
Description
Open server configured with Kerberos intermittently crashes while acquiring the credentials for the incoming connection when the keytab file is accidentally deleted.



CR:384762
CR Number:   384762
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2005 Fixed
Description
ADO.NET: Connection.State property remains set to Open when network is disconnected between client and ASE.



CR:384793
CR Number:   384793
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2005 Fixed
Description
ODBC Driver by Sybase: Enhancement request to add support for ODBC Scalar function: CONVERT.



CR:384924
CR Number:   384924
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)
15 Apr 2005 Fixed
14 Apr 2005 Fixed
20 Apr 2005 Fixed
Description
TRANLIB: Timestamps are not correct when libxadtm is used on the AIX platform with dce applications like CICS and Encina. The errorlog shows:

1900/01/00 00:00:00: 0xb00ca,00000001: [xalog_open_file/165]



CR:385153
CR Number:   385153
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2005 Fixed
Description
ADO.NET: With AseDataReader, when last Select has 0 rows, result set not detected. Need to detect the empty result set.



CR:385393
CR Number:   385393
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for ReadOnly switch



CR:385395
CR Number:   385395
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#9 26 Jul 2005 Fixed
12.5.1 ESD#9 23 Aug 2005 Fixed
Description
ODBC Driver by Sybase: Request to add Hostname in the Configuration for ODBC Data Source



CR:385561
CR Number:   385561
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2013 Insufficient priority to fix
Description
Request for Named Parameter Support in ADO applications



CR:385575
CR Number:   385575
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)
30 Oct 2005 Fixed
Description
ODBC: ODBC Driver sends an incorrect message when default parameters are used in ADO application.



CR:385625
CR Number:   385625
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)
08 Apr 2007 Fixed
16 Apr 2007 Fixed
Description
SRVLIB: On UNIX, Open Server application might report wrong error messages in srv__take_mutex, like "WaitForSingleObject() failed in srv__take_mutex".



CR:385902
CR Number:   385902
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customers need a performance and tuning guide for OpenSwitch



CR:385907
CR Number:   385907
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#8 19 Apr 2005 Fixed
Description
ADO.NET: Cannot access stored procedure meta-data if executing stored procedures from a different database using <database>.<owners>.<procedure name> syntax.



CR:386029
CR Number:   386029
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 19 May 2006 Fixed
Description
OLE DB Provider by Sybase: ADO Recordset.RecordCount always returns -1 when CursorLocation is set to adUseServer.
Workaround Description
 They need to use DataDirect Provider.



CR:386031
CR Number:   386031
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 23 Aug 2005 Fixed
12.5.1 ESD#9 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: ADO Recordset.RecordCount always returns -1 when CursorLocation=adUseServer.



CR:386186
CR Number:   386186
Product Name:   jConnect
Product Component:   Ribo
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2005 Fixed
Description
RIBO: RIBO output does not correctly translate DYNAMIC2 tokens.



CR:386256
CR Number:   386256
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2005 Fixed
Description
ADO.NET: Poor Provider performance when executing batches of SQL Statements.
Workaround Description
 *** Thursday, April 07, 2005 2:56:44 PM *** pvero ***

Suggested Packet Size set to 1024 or higher, but customer is reluctant to do this - cites reasons for not doing so.



Currently, customer is using ddtek oledb provider



CR:386553
CR Number:   386553
Product Name:   jConnect
Product Component:   Jisql
Status:   Open
OS:   Solaris
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like to display bitmap bmp images in jISQL



CR:386560
CR Number:   386560
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2007 Fixed
Description
jConnect: Using column meta-data functions such as getColumnType, getColumnLabel on a user-defined datatype (UDT) column from a table that is not in the current database results in a SQLException.
Workaround Description
 Define the UDTs in the model database before creating the user database. Essentially, the UDT is then in every database.



CR:386892
CR Number:   386892
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2005 Fixed
Description
jConnect: Request for getPrecision to work with other datatypes besides Numeric and Decimal. The JDBC specification seems to indicate that precision should be available, as non-zero value, for all numeric and non-numeric types.
Workaround Description
 *** Wednesday, April 13, 2005 10:00:18 AM *** pvero ***

It is conceivable to use the DatabaseMetaData class method getColumns and retrieve the value COLUMN_SIZE which seems to represent the precision for the datatypes I am testing:



DatabaseMetaData dbmd = con.getMetaData();

rs_cols = dbmd.getColumns(null, null, TABLE_NAME, null);

while (rs_cols.next())

{

String s_name = null;

String s_size = null;

if (ASA == 1) { // bug in ASA in returning this info????

s_name = rs_cols.getString("COLUMN_NAM");

s_size = rs_cols.getString("COLUMN_SIZ");

}

else {

s_name = rs_cols.getString("COLUMN_NAME");

s_size = rs_cols.getString("COLUMN_SIZE");

}

System.out.println("ColumnName is: " + s_name);

System.out.println("ColumnSize is: " + s_size);

}



(Some obscure bug somewhere where the column names are truncated in the response from ASA) - Anyway, the double precision on ASA has COLUMN_SIZE of 8??? On ASE it is 15. I am not sure if this is correct or not and may warrant further investigation.



The weird thing is if you use interactive SQL to ASA, sp_columns returns precision of double (precision) as 15!



CR:386936
CR Number:   386936
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2005 Fixed
Description
jConnect: Request to implement JDBC3.0 ParameterMetaData interface.



CR:387054
CR Number:   387054
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5 ESD#16 05 May 2005 Fixed
6.5 28 Apr 2005 Fixed
5.5 ESD#16 13 May 2005 Fixed
6.5 13 May 2005 Fixed
Description
jConnect: Cache TDS RowFormat and ResultSet definitions across PreparedStatement executions to improve performance of jConnect client applications.



CR:387085
CR Number:   387085
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2005 Fixed
Description
jConnect: Interrupting a thread that's executing commands on ASE will result in orphaned connections on ASE that continue to hold locks and resources on the server.



CR:387354
CR Number:   387354
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2005 Fixed
08 Jun 2005 Fixed
Description
ISQL: ISQL fails to recognize alternative command batch terminators (specified with -c as an alternative to "go") that contain uppercase letters.



CR:387495
CR Number:   387495
Product Name:   Organic OLE DB Provider
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2005 Fixed
Description
ODBC & OLE-DB: Feature request for installer to automatically install Meta-Data stored procedures.
Workaround Description
 Follow instructions to install the procedures by hand.



CR:387519
CR Number:   387519
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Aug 2005 Fixed
Description
jConnect: Commit current transaction if the value of auto-commit is changed in the middle of a transaction. Requested behaviour is consistent with JDBC specifications.
Workaround Description
 None within the specification.



Explicit "Connection.commit()" or "Connection.rollback()"



CR:387661
CR Number:   387661
Product Name:   Connectivity Utilities
Product Component:   dsedit
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If one adds schema to a Sun One Ldap server at the 5.2 level, then dsedit is unable to add or modify ASE server entries if schema checking is enabled.
Workaround Description
 disable schema checking, add one server, export the ASE entry, now use ldapmodify to add future servers or use the gui panels in the ldap server, copying over existing servers as templates.



CR:387690
CR Number:   387690
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)
26 Mar 2006 Presently Not Targeted For Any Future Release Of This Product
Description
The bcp error filename is limited to 132 characters. The error filename should be permitted to be up to 255 characters which is the Posix maximum file name size.
Workaround Description
 symbolic link the errorfile



CR:387826
CR Number:   387826
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.50.08
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2005 Fixed
Description
SYBTRUE is not cleaning up SYBPTTIE and TCPCPROC Storage for OCC apps



CR:388076
CR Number:   388076
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for Named Parameter Support in ADO applications



CR:388101
CR Number:   388101
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2010 Presently Not Targeted For Any Future Release Of This Product
Description
New Feature Request: OCS utility allow to work with the default locale when

it was set unavailable one.



CR:388277
CR Number:   388277
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2005 Not a Bug
Description
ADO.NET: Memory leak detected when connection pooling is used in ADO.NET Provider



CR:388584
CR Number:   388584
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2005 Fixed
Description
jConnect: The Reader object returned by ResultSet.getCharacterStream() terminates when it encounters a Unicode character whose first byte is "FF". E.g. U+FF01.



CR:388681
CR Number:   388681
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#8 14 Jul 2005 Fixed
Description
ODBC Driver by Sybase: Enhancement request to add support for ODBC Scalar function: CONVERT.
Workaround Description
 Use DataDirect driver.



CR:389282
CR Number:   389282
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#10 25 Aug 2005 Fixed
15.0 ESD#1 08 May 2006 Fixed
Description
OLE DB Provider by Sybase: Request for OLE-DB provider to support MS Data Link editor.
Workaround Description
 Create a dummy .UDL file and then add a valid Organic OLE-DB connection string.



CR:389455
CR Number:   389455
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#9 14 Jul 2005 Fixed
Description
ODBC Driver by Sybase: When using ODBC API cursors, binding (SQLBind) datetime columns as SQL_C_TIMESTAMP, results in "Invalid conversion" error.
Workaround Description
 *** Thursday, May 05, 2005 10:39:43 AM *** pvero ***

Not using ODBC Cursor libs seems to work ok. Finding out if the customer can use that.



CR:389540
CR Number:   389540
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5 ESD#18 03 Jun 2005 Fixed
6.5 03 Jun 2005 Fixed
Description
jConnect: Request capability to disable Adaptive Server from sending RowFromat2 Tokens to describe Row Format data. Some applications may see improved performance due to reduced network traffic but at a loss of ResultSet meta data information.



CR:389728
CR Number:   389728
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2005 Fixed
Description
jConnect: If a call to DriverManager.getConnection() exceeds the login timeout, the connection is aborted with an exception, but the underlying connection to the remote server is not closed until the application exits or garbage collection occurs. Client cannot explicitly close the connection as it does not have a handle to the connection.
Workaround Description
 Explcitly call the Garbage Collector in the exception handler.



CR:389834
CR Number:   389834
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2005 Fixed
Description
When running bcp through OpenSwitch, bcp reports "bcp copy in failed"

even though it was able to copy all of the rows into the database.



CR:389840
CR Number:   389840
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)
05 Jun 2005 Fixed
12 Jun 2005 Duplicate
Description
ISQL: On IBM AIX 5.x with CyberSafe GSS-API version 3.x, ISQL might give error "Consistency check performed on the credential failed" and raise SEGV in CyberSafe library call csfC5query_Svcmngr().



CR:390215
CR Number:   390215
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)
25 Oct 2006 Fixed
27 Nov 2006 Presently Not Targeted For Any Future Release Of This Product
15 Nov 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. On Unix,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. But this feature is not available on Windows platforms yet. On Windows, you will get a compilation error "unresolved external symbol _srv_send_data" for the ctos sample or when srv_send_data is being used.



CR:390656
CR Number:   390656
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: RPC site login was not working.
Workaround Description
 *** Monday, May 16, 2005 1:19:29 PM *** pvero ***

You can workaround this with sp_configure 'cis rpc handling' set to 1.



CR:390850
CR Number:   390850
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#9 14 Jul 2005 Fixed
Description
ODBC Driver by Sybase: Using updateable cursor on Select statement using "for update of" clause does not result in exclusive lock held on rowlevel access for tables defined to lock at the rowlevel.



CR:391142
CR Number:   391142
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2005 Fixed
17 Jun 2005 Fixed
Description
SRVLIB: Deadlocks on mutex in comn_take_mutex might cause Open Server to hang.



CR:391294
CR Number:   391294
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5 ESD#18 23 May 2005 Fixed
23 May 2005 Fixed
Description
jConnect: With ServerType=OSW, jConnect is setting incorrect Isolation levels in ASE.
Target Version
 5.5 ESD#18
Workaround Description
 *** Friday, May 20, 2005 6:02:07 PM *** pvero ***

Repro:



1. Use the source code attached to CR (and in the /remote/cases/11138000s/11138021/PSE): Isolation.java



2. Change the connection string to what you need.



3. The usage is java Isolation <X|OSW>



X will use default jConnect mode (No SERVERTYPE is set)

OSW will set SERVERTYPE property to OSW



4. Let it rip. The code will :

a) get the default ASE isolation level and display it

b) it will set and get each of the ASE isolation levels.



It is best to read the Observations section in the CR description to get a handle on this....



CR:391723
CR Number:   391723
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6.ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 01 10 Dec 2007 Fixed
Description
Client does not receive a message for an invalid Server Option license.



CR:391886
CR Number:   391886
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)
02 Jun 2005 Fixed
15 Jun 2005 Fixed
Description
NETLIB: libtcl.cfg security section does not allow comments at the end of the init-string.



CR:391961
CR Number:   391961
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2005 Fixed
01 Jun 2005 Fixed
Description
OpenSwitch becomes unresponsive after a surge of clients disconnect due to RESPONSE_TIMEOUT



CR:392395
CR Number:   392395
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jul 2005 Fixed
Description
ADO.NET: The AseConnnection.StateChange event reports incorrect value for OriginalState The OriginalState is always "Open".



CR:392624
CR Number:   392624
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2006 Not a Bug
Description
The Installer needs to be able to override SMS





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