提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着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:364878
CR Number:   364878
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: Request for sp_password execution on login, when password is expired



CR:365010
CR Number:   365010
Product Name:   ESQL
Product Component:   Cobol
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jan 2013 EOL'd version. Not to be Fixed.
Description
Procedure with decimal/numeric output parameters do not work with ESQL/Cobol.



CR:365054
CR Number:   365054
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)
17 Sep 2004 Not a Bug
Description
srv_xferdata returns error 16324 when return NULL integer parameters
Workaround Description
 Initialize the output parameter to a non-NULL value like 0

or return a non-NULL value. Or, set CS_VERSION_120 in your

Open Server.



CR:365140
CR Number:   365140
Product Name:   Open Server/Mainframe-Doc
Product Component:   Installation Guide
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Our documentation does not show how to use SYBCLOS (SYCL) in the CICS Shutdown procedure



CR:365179
CR Number:   365179
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
sp_sql_type_name failing accessing datatypes on a VIEW on diff dbase then table



CR:365613
CR Number:   365613
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Red Hat Enterprise Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2005 Fixed
Description
ODBC: Release home grown Sybase Adaptive Server Enterprise ODBC Driver 12.5.1 for Mac OS X platform. This driver will eventually replace the existing ODBC Driver after it reaches it's end-of-life.



CR:365942
CR Number:   365942
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#7 10 Dec 2004 Fixed
Description
ODBC Driver by Sybase: The driver does not support comments in sql

Workaround: Do not use comments in sql you want to execute



CR:366242
CR Number:   366242
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 Sep 2004 Fixed
14 Oct 2004 Fixed
Description
SRVLIB: Openserver service thread throws 16145 error while calling srvlib APIs such as srv_numparams, srv_descfmt etc.



CR:366302
CR Number:   366302
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#10 10 Apr 2008 Fixed
Description
ODBC Driver by Sybase: Request to gracefully handle expired password in SQLDriverConnect/SQLConnect.



CR:366464
CR Number:   366464
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)
05 Dec 2004 Fixed
Description
ODBC: Runtime error in MS Access with ADO script AddNew() method. Exact message was "run-time error '-2147467259' (80004005) ODBC-call failed. Now there is a different error: Run-time error '-2147217911' (80040e09) Cannot update. Database or object is read-only. This appears to be an ADO limitation and can be resolved by setting the ASE Recordset object CursorLocation to adUseClient.
Workaround Description
 1. SM = 0 (Cursor)

or

2. Use ctlib (EBF 11581: 4.20.0060)

or

3. set CursorLocation = adUseClient (requires code change)



CR:366580
CR Number:   366580
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)
12.5.1 ESD#28 08 Apr 2009 Duplicate
15.0 ESD#19 08 Apr 2009 Duplicate
Description
OLE DB Provider by Sybase: The ISupportErrorInfo interface is missing some features.



CR:366695
CR Number:   366695
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2004 Fixed
Description
jconnect: The ResultSet.updateObject() method when used with column name, discards scale for numeric types
Workaround Description
 Use the column index instead of column name.



CR:366805
CR Number:   366805
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)
12 Jan 2005 Fixed
21 Mar 2005 Fixed
Description
CTLIB: CT-LIB application may have performance degradation when receiving large resultsets.



CR:366850
CR Number:   366850
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: Support for Multiple LDAP server entries



CR:366857
CR Number:   366857
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: Support for Multiple LDAP server entries



CR:366875
CR Number:   366875
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)
22 Oct 2004 Fixed
31 Oct 2004 Fixed
Description
CTLIB:ct_cancel fails on a disconnected connection with no error information.
Workaround Description
 none except to alter the message handling for this special case.



CR:366938
CR Number:   366938
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Nov 2004 Fixed
08 Dec 2004 Fixed
Description
jConnect: Request to add support for Chinese Unicode Charset GB18030.



CR:366986
CR Number:   366986
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.06
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 001 20 Oct 2004 Fixed
Description
Prevent sending of null packet after TDS_PRACK from TRS.



CR:367021
CR Number:   367021
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2005 Fixed
Description
ADO.NET: Improve performance of GetValue() methods on DataReader object.



CR:367322
CR Number:   367322
Product Name:   Open Server/Mainframe-Doc
Product Component:   Release Bulletin
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need more Documentation on the new UNICODE feature.



CR:367480
CR Number:   367480
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)
17 Oct 2004 Fixed
20 Oct 2004 Fixed
Description
EXAMPLE: CTOS sample now supports CS_TIMEOUT when linked with re-entrant libraries.
Workaround Description
 Use ESD#1



CR:367562
CR Number:   367562
Product Name:   ADO.NET Data Provider
Product Component:   I18N/L10N
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2005 Presently Not Targeted For Any Future Release Of This Product
Description
Request for support of roman8 charset



CR:367565
CR Number:   367565
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2004 Fixed
Description
ADO.NET: Enhancement request to support "Connection Lifetime" and "Idle Timeout". If the connection is used for more than the specified connection lifetime, it should be closed instead of

being put back in the pool. If a connection is idle for more than the time specified in idle timeout, it should be automatically closed.



CR:367700
CR Number:   367700
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Cust wants to revert ISQL column separator display to 12.0 GA behavior
Workaround Description
 Use ISQL from the 12.0 GA release.



CR:367722
CR Number:   367722
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2004 Fixed
Description
jConnect: Inconsistent base date set for smalldatetime and datetime columns in ASE 12.5.1 or later when these columns are used to store Time values. This could cause unexpected query results when these columns are used in where clause of queries.
Workaround Description
 There are a few workarounds that can be done in the code, however the customer has too many applications, too many place to change and they are adverse to change since they have been running into other jConnect problems in the past.



CR:367798
CR Number:   367798
Product Name:   jConnect
Product Component:   JDBC Gateway
Status:   Closed
OS:   NA
Original Version:   5.5 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2004 Fixed
Description
jConnect: Inconsistent base date set for smalldatetime and datetime columns in ASE 12.5.1 or later when these columns are used to store Time values. This could cause unexpected query results when these columns are used in where clause of queries. (this is a duplicate of CR 367722)



CR:367804
CR Number:   367804
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)
02 Aug 2005 Fixed
01 Aug 2005 Fixed
Description
BCP: Added a new option -C to bcp in/out encrypted column instead of plain text.



CR:367819
CR Number:   367819
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.07 004 14 Oct 2004 Fixed
Description
With LSECR=N, listener fails to start transaction SYGH.



CR:367836
CR Number:   367836
Product Name:   Connectivity Utilities
Product Component:   defncopy
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2005 Fixed
28 Mar 2005 Fixed
Description
DEFNCOPY: When defncopy generates a DDL, some spaces may be incorrectly inserted into strings of multiple-byte characters.
Workaround Description
 none



CR:367990
CR Number:   367990
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)
12 Dec 2004 Fixed
18 Jan 2005 Fixed
Description
ISQL: On UNIX platforms, suppress the password that is visible from the command line when running isql using the command 'isql -U<userid> -P<password>'.



CR:367992
CR Number:   367992
Product Name:   Connectivity Utilities
Product Component:   scripts
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2004 Fixed
04 Oct 2004 Fixed
Description
EXAMPLE: Remove entries for DCE security and DCE directory services from libtcl.cfg and correct security example name 'secsrv' to 'secsrv_krb' to indicate the use of the Kerberos security driver.



CR:367993
CR Number:   367993
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 Jan 2005 Fixed
07 Jan 2005 Fixed
17 Sep 2002 Not a Bug
Description
On Unix systems, under rare circumstances, segmentation fault (signal 11) may occur from SSL function sb_memcopy().
Workaround Description
 n/a.



CR:368190
CR Number:   368190
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2004 Duplicate
Description
ODBC: Request for sp_password execution on login, when password is expired



CR:368246
CR Number:   368246
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2005 Not a Bug
Description
ESD's do not contain all versioned drivers from previous ESDs. This means that applications statically built on one ESD may not run in an environment which contains only a later ESD.
Workaround Description
 Install ESD#19 before ESD#22.



CR:368332
CR Number:   368332
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)
05 Dec 2004 Fixed
Description
OLEDB:

When the advanced option "Print Statement" is set to "MS Compatible" in the OLE DB Data Source, each print statement is treated as a separate result set.



But any sproc containing a print statement called through the Sybase ASE OLE DB Provider

would fire the following error at ADODB.RecordSet.Open :

Runtime error '-214767259 (80004005)'

[Native Print code: 0]

[Datadirect ADO Sybase Provider] This is my message from sproc



This has been fixed.



CR:368571
CR Number:   368571
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Dec 2005 Fixed
Description
ADO.NET: Improve performance of AseDataAdapter.Fill() method.



CR:368613
CR Number:   368613
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Unknown
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2004 Fixed
14 Oct 2004 Fixed
Description
CTLIB: a packetsize larger than 32767 bytes results in an "illegal length" protocol packet error.



CR:368669
CR Number:   368669
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jun 2005 Fixed
26 Aug 2005 Fixed
05 Jul 2005 Fixed
Description
OpenSwitch transposes the data for named parameters if the

client application declares them in a different order than

when they were declared in the stored procedure residing

on ASE.
Workaround Description
 Declare the parameters in the client application in the same

order as they are declared in the stored procedure on ASE.



CR:368670
CR Number:   368670
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)
23 Feb 2005 Fixed
28 Mar 2005 Fixed
Description
SRVLIB: Gateway applications cannot return the output parameters in the same order as the parameters were originally specified in the stored procedure's create procedure statement. To deal with this, srv_descfmt(CS_SET, SRV_RPCDATA) has been modified to allow it to be called within a RPC handler to reorder the output parameters. Note that this used to be disallowed and is documented in the open server reference manual.
Workaround Description
 Declare the parameters in the client application in the same

order as they are declared in the stored procedure on ASE.



CR:368752
CR Number:   368752
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)
10 Dec 2004 Fixed
Description
ADO.NET: If an application assigns an enum value as AseDbType to an AseParameter, the provider throws NotSupported Exception



Workaround: Use AseDbType instead of creating new enumerations
Workaround Description
 Cast the enum to an int.



CR:368933
CR Number:   368933
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5 ESD#15 03 Nov 2004 Fixed
6.0 ESD#2 02 Nov 2004 Fixed
Description
jConnect: Unable to distinguish between functions and procedures in data returned by DatabaseMetaData.getProcedures().



CR:369018
CR Number:   369018
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)
17 Jan 2005 Fixed
Description
ODBC: Print statement within If statement returning SQL_ERROR, now returns SQL_SUCCESS_WITH_INFO (to be compatible with older drivers).



CR:369077
CR Number:   369077
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)
17 Jan 2005 Not a Bug
Description
OLEDB: When executing an ASE stored procedure in this manner: Set sybADORecordset = sybADOConn.Execute("proc_Name"), the execution results in 2 execution calls to the Sybase ASE. This occurs, because by default the ADO Execute method sets the CommandType property for the ADO Recordset to "adCmdUnspecified". When this occurs, the ADO API executes the stored procedure at first as a TDS_LANGUAGE event. If this does not return a row result set, the API then calls the stored procedure as a TDS_DBRPC event, therefore causing the double execution. To resolve this behavior the programmer must set the ADO CommandType property to adCmdStoredProc, either explicitly on the ADO Recordset or by changing the example : Set sybADORecordset = sybADOConn.Execute("proc_Name", adCmdStoredProc).



CR:369511
CR Number:   369511
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer needs OC/OS to support streaming binary and character data
Workaround Description
 1) Code the jConnect application to use the textpointer method rather than setAsciiStream.

2) Use the setBinaryStream method against tables with the image datatype.



CR:369522
CR Number:   369522
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)
09 Nov 2004 Fixed
16 Nov 2004 Fixed
Description
CTLIB: ct_cancel(CS_CANCEL_ALL) intermittently crashes when extra results such as extended error data is present in one of its command handles.



CR:369694
CR Number:   369694
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#7 10 Dec 2004 Fixed
Description
ODBC Driver by Sybase: The driver does not support SQL_WLONGVARCHAR as a SQL type when using SQLBindParam()



Workaround: None



CR:369711
CR Number:   369711
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2004 Fixed
Description
ODBC Driver by Sybase: SQLProcedures() incorrectly returns SQL_PT_PROCEDURE in the PROCEDURE_TYPE column for user defined functions

Workaround: None



CR:369724
CR Number:   369724
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 Beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#7 14 Dec 2004 Fixed
Description
ODBC Driver by Sybase: The length indicator in SQLBindCol() always returns 0 when the data being fetched is a fixed type.

Workaround: None



CR:369730
CR Number:   369730
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2006 Fixed
Description
MFC Client Option for CICS, use of EXTRACT-EXIT with TCP/IP has pontential security risks



CR:369732
CR Number:   369732
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)
17 Dec 2004 Fixed
Description
Parsing of imbeded quotes in a language event request was performed incorrectly.



CR:369790
CR Number:   369790
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)
10 Dec 2004 Fixed
Description
ADO.NET : Enhancement request to allow the application to ignore errors occuring in a stored procedure statment if there are pending results. This enables the application to ocntinue processing results and access output parameters.



A connection string property NoErrorIfRSPending has been added to the provider to support this behavior.



CR:369814
CR Number:   369814
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2008 Fixed
19 Apr 2005 Fixed
Description
Customer wants a GUI interface to administer OpenSwitch and RCM



CR:369995
CR Number:   369995
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2005 Fixed
Description
jConnect: Applications using Statement cache have occasional trouble using prepared statements. Receive exception: Exception in thread "main" com.sybase.jdbc2.jdbc.SybSQLException: Stored procedure 'xyz' may be run only in unchained transaction mode. The 'SET CHAINED OFF' command will cause the current session to use unchained transaction mode.



CR:369997
CR Number:   369997
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)
16 Dec 2004 Fixed
31 Jan 2005 Fixed
Description
NETLIB:Native kerberos appends an extral character @ to the client principal name during login.

This causes the connection to fail.
Workaround Description
 Only workaround is to add userid, like janders@ to the ASE which is unacceptable for a customer environment.



CR:370125
CR Number:   370125
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2006 Fixed
19 Oct 2006 Fixed
Description
Customer wants RCM to completely quiesce queue before switching users



CR:370455
CR Number:   370455
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   5.5 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
loadjava produces ORA-29545 error when trying to add jConnect classes into Ora database.

Tested and reproduced with:

jConnect 5.5 ESD#13 (EBF 11937)

Oracle 9.0.2



CR:370482
CR Number:   370482
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#7 14 Dec 2004 Fixed
Description
ODBC Driver by Sybase: When the application has set the connection property "dynamicprepare=true", SQLPrepare() returns an error if the sql command to be prepared is inserting or updating an image or text column.

Workaround: None



CR:370757
CR Number:   370757
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2005 Fixed
Description
ODBC Driver by Sybase: New feature request to be able to obtain connection information from Sybase interfaces / SQL.INI files.



CR:370778
CR Number:   370778
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)
13 Jan 2005 Not a Bug
Description
ODBC: cp850 characters are not displaying correctly in Visual Basic ADO application. To resolve this set the "CHARSET" connection property to "iso_1". ASE defaults to "cp850", so the setting of charset to "iso_1" will force the ASE to translate the characters to "iso_1". This is not a bug.



CR:371179
CR Number:   371179
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2005 Not reproducible with latest version of the product available as of Resolution Date
Description
ISQL12.5.1 has significant performance degradation versus 11.1.1 on Windows
Workaround Description
 Use ISQL 11.1.1



CR:371229
CR Number:   371229
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)
15 Feb 2005 Fixed
21 Feb 2005 Fixed
Description
CTLIB: ct_cancel() performance in 12.5.1 on a single engine PC is much slower and has much greater CPU usage than earlier releases.
Workaround Description
 eliminate the ct_cancel() activity by reading til CS_END_RESULTS



CR:371359
CR Number:   371359
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
Improve response time of meta data accessor scripts for ASE 12.5.2 used by jConnect.
Workaround Description
 None except local modification of sp_jdbc_getprodecurecolumns.



CR:371361
CR Number:   371361
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2005 Fixed
Description
Comments were added for generated SYGWMCXL macro parameters.
Workaround Description
 Insert keyword parameters under macro SYGWMCXL TYPE=ENTRY (see below)



> SYGWMCXL TYPE=ENTRY,CHARSET=iso_1, *

>...

> CHARTYPE=A, *

> CHARSIZE=1, *

> PAD=20, *



CR:371557
CR Number:   371557
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
OLEDB:

When the advanced option "Print Statement" is to "MS Compatible" in the OLE DB Data Source, each print statement is treated as a separate result set.



But any sproc containing a print statement called through the Sybase ASE OLE DB Provider

would fire the following error at ADODB.RecordSet.Open :

Runtime error '-214767259 (80004005)'

[Native Print code: 0]

[Datadirect ADO Sybase Provider] This is my message from sproc



This has been fixed.



CR:371891
CR Number:   371891
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)
17 Jan 2005 Fixed
Description
OLEDB: Provider used new, physical ASE connection when 1) First ADO Recordset was opened and then closed and 2) a second ADO Recordset is opened. This was consuming ASE Connections when it was not necessary, since the first Recordset was closed.



CR:372072
CR Number:   372072
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#7 10 Dec 2004 Fixed
Description
ADO.Net: AseParameter.DbType. gives exception: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values when parameter is a user defined datatype on DATETIME.
Workaround Description
 Unknown



CR:372075
CR Number:   372075
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2005 Fixed
Description
ADO.NET: stored procedure 'output' parameters returned from AseCommandBuilder.DeriveParameters are incorrectly reported as having direction 'input' when they are actually defined as 'output' parameters.



CR:372101
CR Number:   372101
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2004 Fixed
29 Nov 2004 Fixed
Description
The coordination module API cm_timer_rem() removes the wrong timer when there is more than one timer defined.



CR:372322
CR Number:   372322
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   5.5 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to produce diagnostic traces on connection events such as opening and closing connections and certain exceptions.
Workaround Description
 I think much of this is possible now but it is difficult for programmers to derive all the information and hook into the events.



CR:372401
CR Number:   372401
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#7 14 Dec 2004 Fixed
Description
ODBC Driver by Sybase: When "select ... for browse" is used, SQLNumResultCols() returns more columns than being selected.

Workaround: None



CR:372458
CR Number:   372458
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)
09 Feb 2005 Fixed
Description
OLE-DB: Since 2.70.0034 max rows returned in a RecordSet can be set using DBPROP_MAXROWS but cannot be reset to 'no limit'.
Workaround Description
 Set to very high value?



CR:372492
CR Number:   372492
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)
17 Jan 2005 Fixed
Description
OLEDB: An empty ADO Recordset, after NextRecordset is called, falsely indicated an existing Recordset.



CR:372642
CR Number:   372642
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)
19 Nov 2004 Fixed
Description
ODBC: Unicode data is getting truncated when trying to insert 4 Chinese Characters into a univarchar column and it fails on the function SQLExecute.



CR:372663
CR Number:   372663
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2005 Fixed
03 Jun 2005 Fixed
Description
CTLIB: mktemp was used to generate a capture file when protocol debugging was enabled via ct_debug. This caused warnings on Linux when linking applications.



CR:372674
CR Number:   372674
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: Request to support Numeric Precision greater than 16



CR:372729
CR Number:   372729
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)
19 Nov 2004 Fixed
Description
ODBC: Memory buffer over run.



CR:372893
CR Number:   372893
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)
23 Nov 2004 Duplicate
Description
QTS Close Duplicate please see QTS 363335.

The code below has reduced the Recevie Timeout from 30 Secs to 1. The issue is now that 1 sec is to short for some companies. We are suppling a ZAP for customers to configure this to what ever time will work for them. We need a way to configure this such as a parameter on the listener....



CR:373016
CR Number:   373016
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2006 Presently Not Targeted For Any Future Release Of This Product
Description
Customer would like a configurable way to suppress the Errno 36 (ECONNRESET) message from getting wirtten to the CSML. The Message means that the Client TCP/IP side of the conversation ended abnomally from a TCP/IP poit of view. Most likely a Client shutting down an Application before it closed the connection properly.



CR:373026
CR Number:   373026
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Red Hat Enterprise Linux
Original Version:   12.5.1 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#7 14 Dec 2004 Fixed
Description
ODBC Driver by Sybase: When an application binds a variable as SQL_C_WCHAR, SQLGetData() returns the same row even when multiple rows are present in the result

Workaround: Use SQLFetch() instead of SQLGetData()



CR:373181
CR Number:   373181
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)
05 Jan 2005 Fixed
11 Jan 2005 Fixed
Description
COMNLIB: Performance of threaded libraries is poor compared with version 12.0 or earlier.
Workaround Description
 stay with older 12.0 threaded libraries til problem is fixed but need to get to higher levels.



CR:373323
CR Number:   373323
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2005 Fixed
Description
ODBC Driver by Sybase: Incorrect Language and Charset setup causing failed connection for some Language / Charset settings.



CR:373344
CR Number:   373344
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)
10 Dec 2004 Fixed
11 Jan 2005 Fixed
Description
SRVLIB: Open server leaks 48bytes memory per SSL connection. For failed SSL connection due to invalid certificate used, there is an additional 568bytes memory leak.
Workaround Description
 None known.



CR:373370
CR Number:   373370
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 2004 Fixed
24 Jan 2005 Fixed
Description
SRVLIB: Processing many concurrent srv_createmutex, srv_deletemutex, srv_createmsgq, srv_deletemsgq and srv_getobjid calls on many threads can cause a SEGV in srv_getobjid.
Workaround Description
 Only workaround would be to have customer code mutex calls around all his srv_createmutex srv_deletemutex, srv_createmsgq, srv_deletemsgq calls which is unacceptable to him.



CR:373403
CR Number:   373403
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2004 Fixed
10 Dec 2004 Fixed
10 Dec 2004 Fixed
Description
jconnect applications don't receive DONEINPROC tokens when running through OSwitch.



CR:373621
CR Number:   373621
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2005 Fixed
Description
ADO.Net: Using ASECommandBuilder gives exceptions: "Cannot execute a command without opening the Connection" and "Missing Primary Key for table <Table>".
Workaround Description
 None known



CR:373734
CR Number:   373734
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#7 14 Dec 2004 Fixed
Description
ODBC Driver by Sybase: SQLFetch() returns Data Trunctaion warning when the application uses the same pointer for length indicator in SQLBindParameter().

Workaround: Use separate variables for the length indicator.



CR:373758
CR Number:   373758
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jul 2005 Fixed
Description
OpenSwitch times out long running queries when the RESPONSE_TIME

configuration parameter is set too low. Customer wants a way to

timeout if the network/host goes down but not timeout active, long

running queries.
Workaround Description
 Possibly set the timeouts to a lower value at the operating system's TCP layer.

On Solaris this would be accomplished by changing the following parameters:

tcp_ip_abort_cinterval

Abort timeout at connect time.

This is the 3-way handshake abort timer.

The default value is 180000 (3 MIN)



tcp_ip_abort_interval

Abort interval used after connected (abort timeout for an established connection)

This is the maximum time TCP retransmits will be tried for a connection

in the ESTABLISHED state should be tried before a RESET segment is sent.

Default 480000 (8*MINUTES)



CR:373827
CR Number:   373827
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 25 Jan 2005 Fixed
Description
Character set translation wrongly defaulted to using the ascii_8 translation table.



CR:374005
CR Number:   374005
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)
11 24 Jan 2005 Fixed
Description
Translation overrides for ISO_1 character set in SYGWMCXL macro did not work correctly.



CR:374165
CR Number:   374165
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: Visual Basic application sometimes throws an Access Violation while executing a parameterised insert command under heavy load.
Workaround Description
 Use ODBC driver instead.



CR:374290
CR Number:   374290
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2006 Fixed
Description
jConnect: Add support for JDBC 3.0 retrieval of Auto Generated keys feature using Statement.getGeneratedKeys method.
Workaround Description
 "select @@identity" will only work for simple INSERT statements.



CR:374586
CR Number:   374586
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2005 Fixed
28 Mar 2005 Fixed
Description
SRVLIB: When multiple clients continuously connect to open server without doing a full tds login, open server eventually runs out free messages with 16016 error. Note this only occurs when open server is built with the threaded libraries.
Workaround Description
 stop the tcpip low level pinging done by routers



CR:375006
CR Number:   375006
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#7 28 Jan 2005 Fixed
Description
ODBC Driver by Sybase: If an application uses SQL_C_DEFAULT as the 'C' type for any fixed type, in the call to SQLBindColumn(), the driver returns an error.

Workaround: Use the appropriate 'C' type



CR:375025
CR Number:   375025
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#7 28 Jan 2005 Fixed
Description
ADO.NET: When using an AseParameter of type AseDbType.TimeStamp as a ParameterDirection.InputOutput the provider throws an Exception with the message "Object reference not set to an instance"



CR:375147
CR Number:   375147
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2005 Fixed
18 Oct 2006 Fixed
Description
SRVLIB: Open Server deallocates the endpoint in srv__net_stop() which could cause memory corruptions.



CR:375422
CR Number:   375422
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2005 Fixed
Description
ADO.NET: IDataParameter.DbType.Binary does not support Byte[] arrays larger than 255 bytes and throws exception: Data overflow. Increase specified column size or buffer size
Workaround Description
 Use AseParameter.AseDbType.Image - not so portable.



CR:375584
CR Number:   375584
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 TDS 2.70.0041 - VB appl gets Access violation in RecordSet.UpdateBatch
Workaround Description
 None known.



CR:375622
CR Number:   375622
Product Name:   Open Server/Mainframe-Doc
Product Component:   COBOL Programmer's Reference
Status:   Open
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
I just show one example of the problem below, teh RSp guide refere to RSP8C being in Appendix 'E' its not, it's at the end of Appendix 'D' there is no Appendix E.



RSP8C shows an example of how to transmit variable text. See Appendix E, "RSP8C variable text sample RSP" for a reproduction of the sample.



CR:376005
CR Number:   376005
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
Cover letter states to use favorite tool to decompress ZIP - not working with gunzip (UNIX). This CR is a request to change the jConnect Cover letter to be more specific about what can be used.



CR:376200
CR Number:   376200
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2006 Fixed
31 Jan 2006 Fixed
Description
OLE DB Provider by Sybase: Feature request for OLEDB Data Source configuration Manager for Sybase ASEOLEDB Provider.





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

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,16.x,17.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使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

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

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

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
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


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

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


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

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------