提供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:333665
CR Number:   333665
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
OpenSwitch 12.5.1 hangs against Open Server 12.5.1



CR:333851
CR Number:   333851
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)
27 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Open Client/Open Server was enhanced to allow parameters with language events. Mainframe Connect will be enhanced to use this new feature.



CR:334020
CR Number:   334020
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2004 EOL'd version. Not to be Fixed.
10 Sep 2004 Fixed
Description
CTLIB, CSLIB: Allow use of SYBOCS_CFG environment variable to over-ride default configuration value.
Target Version
 Galaxy



CR:334158
CR Number:   334158
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2004 Deferred
04 Nov 2005 Fixed
23 May 2006 Fixed
Description
CTLIB: New Feature to allow CS_LOGIN_TIMEOUT & CS_TIMEOUT properties to be set at connection level as well as context level.
Workaround Description
 Use multiple CS_CONTEXTs in a single application - yuk!



CR:334178
CR Number:   334178
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2003 Fixed
Description
BCP: BCP -Y does not do conversions for multibyte characterset columns greater than 255 bytes in length.



CR:334361
CR Number:   334361
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2006 Fixed
Description
jConnect install document for 5.5 still refers to 5.2 version.
Review Status
 Reviewed Mar 2004. The requested changes have been made to the jConnect 5.5. documentation.



CR:334482
CR Number:   334482
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2004 Fixed
5.5 16 Mar 2004 Fixed
5.5 16 Mar 2004 Fixed
5.5 16 Mar 2004 Fixed
5.5 16 Mar 2004 Fixed
5.5 16 Mar 2004 Fixed
Description
jConnect has added a new connection property, QUERY_TIMEOUT_CANCELS_ALL. This property works in the following way: If a client has called Statement.execute(), and one of the SQL statements in the execute batch times out, jConnect will issue a cancel_all command on the Connection. This will cause all pending statements on the Connection to be canceled.



This behavior can be useful, for example, in a case where the timeout is caused by a deadlock situation.



CR:334483
CR Number:   334483
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
OLEDB: Error running proc:"The name 'sp_who sa' is not a valid identifier" w/ adCmdText
Workaround Description
 - change from adCmdText to adCmdStoredProc

- use ODBC Driver 4.20 TDS-Based instead



CR:334644
CR Number:   334644
Product Name:   Open ClientCONNECT for IMS and MVS
Product Component:   MVS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Mar 2004 Fixed
Description
On array processing, the fetch count is not being properly set.



CR:334672
CR Number:   334672
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 Mar 2004 Fixed
Description
Add getrlimit(RLIMIT_NOFILE) to warn user about file descriptors
Workaround Description
 Decrease the CONNECTIONS parameter to something smaller

than the number of file descriptors so OpenSwitch does

not ever try to overrun that value.



CR:334785
CR Number:   334785
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2003 Fixed
Description
SRVLIB: Open Server fails to perform necessary byteswapping on CS_UNICHAR characters



CR:334856
CR Number:   334856
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Oct 2003 Fixed
5.5 08 Oct 2003 Fixed
Description
If a client does the following:



1. set DYNAMIC_PREPARE connection property to true

2. create a batch of PreparedStatements

3. call setFetchSize()

4. executeBatch()



jConnect will still properly execute the batch. Before this fix, jConnect would become confused by the setFetchSize(), which would create a cursor to process results (even though a cursor makes no sense in the context of executing a batch of statements).



CR:335065
CR Number:   335065
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2004 Fixed
Description
Changed the OpenSwitch's default of suppressing some errors

to start displaying these errors.



CR:335268
CR Number:   335268
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Documentation needs clarification regarding batch rejection operations. During bcp operations, bcp rejects individual rows for problems it detects like converstion errors and placed information in the -e <errorfile>. bcp does not reject entire batches, the server does for errors in the batch that it detects. The current documentation leads one to believe that it is bcp rejecting a batches instead of rows on the client side of things.
Target Version
 Galaxy
Review Status
 Reviewed March 2004. The fix is targeted (but not committed) for the documentation that will be released with the next major product release.



CR:335480
CR Number:   335480
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jan 2004 Fixed
Description
OpenSwitch crashes in np_err_string
Workaround Description
 Revert to OpenSwitch 12.0



CR:335484
CR Number:   335484
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2003 Fixed
Description
CTLIB: OpenSwitch crashes in np_err_string
Workaround Description
 Revert to OpenSwitch 12.0



CR:335601
CR Number:   335601
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2003 Not a Bug
Description
When log size reaches MAX_LOGSIZE OpenSwitch overwrites the log



CR:335650
CR Number:   335650
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2004 Fixed
16 Apr 2004 Fixed
20 Apr 2004 Fixed
20 Apr 2004 Fixed
20 Apr 2004 Fixed
20 Apr 2004 Fixed
20 Apr 2004 Fixed
28 Apr 2004 Fixed
28 Apr 2004 Fixed
21 Apr 2004 Fixed
28 Apr 2004 Fixed
28 Apr 2004 Fixed
27 Apr 2004 Fixed
12 May 2004 Fixed
29 Apr 2004 Fixed
29 Apr 2004 Fixed
09 May 2004 Fixed
09 May 2004 Fixed
12 May 2004 Fixed
Description
EXAMPLE: dblibary, ctlibrary and srvlibrary examples now have more readable 'Makefile' and helper script 'sybopts.sh'. Functions in the examples are also rewritten in ANSI format.



CR:335688
CR Number:   335688
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)
22 Oct 2003 Fixed
14 Jan 2004 Fixed
Description
OCSCFG: On Windows NT, references to net library drivers in ocscfg.exe are not needed.



CR:335891
CR Number:   335891
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2003 Fixed
Description
BCP, ISQL: In some circumstance, BCP and ISQL incorrectly report timing statistics.For example, they might report negative clock time if the running jobs span accross midnight.



CR:336056
CR Number:   336056
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)
25 Feb 2004 Fixed
Description
OLEDB: Initialization String is limited to 40 bytes in ASE OLE DB Configurator. Manually editting the IDS file exceeds this limitation.
Workaround Description
 Manually edit the IDS file



CR:336076
CR Number:   336076
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)
13 May 2004 Fixed
13 May 2004 Fixed
Description
SRVLIB: multthrd example core dumps if no servername is specified on the commandline.



CR:336195
CR Number:   336195
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)
02 May 2006 Fixed
Description
ODBC Driver by Sybase: Add support for some missing Data Source Information types in SQLGetInfo function: SQL_USER_NAME, SQL_TXN_CAPABLE, SQL_TXN_ISOLATION_OPTION, SQL_NON_NULLABLE_COLUMNS, SQL_NULL_COLLATION and SQL_MAX_TABLES_IN_SELECT.



CR:336405
CR Number:   336405
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.04 124 25 Feb 2004 Fixed
Description
Memory leak in AMD2SPS Module.



CR:336519
CR Number:   336519
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under isql version 10.0.4 compute results were displayed directly under the columm which generate the compute results. Under isql version 12.5 compute results are generated left aligned in the printout.
Target Version
 Galaxy
Review Status
 Reviewed March 2004. The fix is targeted (but not committed) for the documentation that will be released with the next major product release.



CR:336538
CR Number:   336538
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2003 Fixed
10 Nov 2003 Fixed
Description
OpenSwitch gets error "mempool_getblock: mem_alloc() failed".



CR:336585
CR Number:   336585
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Fixed
Description
RCM passes two undocumented parameters to the NOTIFICATION_PROCESS



CR:336607
CR Number:   336607
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2003 Fixed
Description
CTLIB: Using Wide Dynamic/ Cursors can cause a core dump in comnlib mapping routines.



CR:336650
CR Number:   336650
Product Name:   Open ClientCONNECT for IMS and MVS
Product Component:   MVS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2003 Not a Bug
Description
SYISQL fails with a code of -7, the region size must be increased appropriately.
Workaround Description
 NONE



CR:336670
CR Number:   336670
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2004 Fixed
Description
CMON thread makes multiple connections to same ASE



CR:336674
CR Number:   336674
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)
28 Jul 2006 Fixed
27 Aug 2006 Fixed
16 Aug 2006 Fixed
16 Aug 2006 Fixed
Description
BCP: When bcp reaches its maximum number of errors it does not report the reason why it stops.
Target Version
 To Be Determined
Review Status
 Reviewed March 2004. This CR is still under review.



CR:336709
CR Number:   336709
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
Multiple sockets for an OCC transaction are not closed on abend.
Target Version
 12.50.04



CR:337095
CR Number:   337095
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
OLEDB Provider 2.70.0022/2.70.0023: Precision error when stored procedure input parameter is set to Null
Workaround Description
 Use ODBC Driver 4.20.00.06 instead.



CR:337129
CR Number:   337129
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)
25 Feb 2004 Fixed
Description
ODBC: ASE varchar was treated the same as char value when ODBC was connected to ASE via Open Server gateway such as Open Switch, and ASE was at version 12.0. The varchar data was being padded so the data displayed was "full length" of the varchar column as defined on ASE. The padding no longer occurs.



CR:337320
CR Number:   337320
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
Request to support setObject(parmIndiex, NULL)
Review Status
 Reviewed Mar 2004. This CR is in review by engineering. Needs to be discussed with Sun.



CR:337422
CR Number:   337422
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)
25 Feb 2004 Fixed
Description
OLEDB: Literal empty string as parameter in ADO application fails against ASE 12.0 with the error: "While reading characters from the client, the receiving buffer has been detected to be too small." This is ASE Error 4020.
Workaround Description
 None



CR:337651
CR Number:   337651
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2003 Fixed
5.2 11 Nov 2003 Fixed
5.2 11 Nov 2003 Fixed
5.2 11 Nov 2003 Fixed
5.2 11 Nov 2003 Fixed
5.2 11 Nov 2003 Fixed
Description
When a client calls updateObject (int index, Object o), and the Object is a BigDecimal, jConnect will respect the value's scale. Previously, jConnect would incorrectly set the scale to 0.



CR:337720
CR Number:   337720
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2004 Fixed
Description
ADO.NET: The ASE ADO.NET Data Provider does not support encryption of ASE Login password.
Review Status
 Reviewed Mar 2004. This fix to this CR is targeted for SDK 12.5.1 ESD #2.
Workaround Description
 Possibly use ADO.Net ODBC driver.



CR:337724
CR Number:   337724
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2004 Fixed
5.5 18 Feb 2004 Fixed
5.5 18 Feb 2004 Fixed
5.5 18 Feb 2004 Fixed
5.5 18 Feb 2004 Fixed
5.5 18 Feb 2004 Fixed
Description
Clients can now pass in a Short object to setObject(). Previously, jConnect was missing some internal conversion methods, which resulted in an Exception being thrown in this case.



CR:337822
CR Number:   337822
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2004 Fixed
Description
ADO.NET: The ASE ADO.NET Data Provider cannot use LDAP to obtain database connection information.



CR:337825
CR Number:   337825
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2004 Fixed
Description
ADO.NET: The ASE ADO.NET Data Provider does not support setting up connections for fail-over in a High-availability cluster.



CR:338060
CR Number:   338060
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2003 Fixed
Description
ADO.NET:DataOverflow Exception when inserting values greater than 127 into a TinyInt class.



CR:338223
CR Number:   338223
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
SYGWCTXH is Abending OC4 at Offset 1972



CR:338256
CR Number:   338256
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Fixed
Description
ADO.NET: AseDataAdapter.fill() returns value from previous cell when current cell value is null.



CR:338322
CR Number:   338322
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Fixed
Description
ADO.NET: AseException is generated when AseDataAdapter.Update(DataSet) command is called to update a table with newly inserted rows and target ASE table contains auto-incremented primary key values.



CR:338334
CR Number:   338334
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2004 Fixed
Description
ODBC: Unable to display and input Traditional Chinese (Big5) characters correctly due to Big5 characters were incorrectly mapped into unicode when using datatype SQL_C_WCHAR.



CR:338356
CR Number:   338356
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Need to announce "no support" for ODBC/OLEDB in .NET Environment



CR:338504
CR Number:   338504
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)
25 Feb 2004 Fixed
Description
ODBC: The ASE install master script set incorrect values, that are not within the ODBC 3.X specification. To correct this problem now, you can modify the system tables.



CR:338697
CR Number:   338697
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2005 Fixed
Description
ADO.NET: New feature request to be able to obtain connection information from Sybase interfaces / SQL.INI files.



CR:338706
CR Number:   338706
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2004 Fixed
Description
ADO.NET: The ASE ADO.NET Data Provider cannot use SSL encryption with ASE.



CR:338799
CR Number:   338799
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)
13 Jan 2004 Fixed
Description
NETLIB: ct_connect() does not failover to secondary interface entries.
Workaround Description
 None.



CR:338850
CR Number:   338850
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2004 EOL'd version. Not to be Fixed.
21 Oct 2007 Fixed
22 Oct 2007 Fixed
19 Nov 2007 Fixed
19 Nov 2007 Fixed
Description
COMNLIB: Change the maximum length of a parameter of SDK utilities to PATH_MAX (Unix) or _MAX_PATH (Windows). This fix is not available on SGI platform now.
Target Version
 12.5.1
Review Status
 Reviewed March 2004. The fix is targeted (but not committed) for a future 12.5.1 EBF.
Workaround Description
 Use:



Shorter absolute paths

Relative paths

Run the utility in the required directory



CR:339062
CR Number:   339062
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2003 Fixed
Description
ADO.NET: On an exception condition if ASE generates a list of errors, AseException object contains only the first error



CR:339090
CR Number:   339090
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2004 Fixed
Description
ADO.NET: The ASE ADO.NET Data Provider supports only a subset of charsets supported by ASE.



CR:339123
CR Number:   339123
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2004 Fixed
27 Apr 2004 Fixed
Description
SRVLIB: Openserver RPC which uses parameters of type CS_UNICHAR_TYPE does not work.
Target Version
 To Be Determined
Review Status
 Reviewed Mar 2004. A fix is targeted for a future release of the product.
Workaround Description
 Change the datatype of the rpc parameter on the open server to be CS_LONGBINARY_TYPE



CR:339355
CR Number:   339355
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2003 Fixed
Description
ADO.NET: Internal Error 30002 when a processing a null datetime column under certain circumstances.
Workaround Description
 use sp :



CREATE PROCEDURE dbo.customers_test



AS

BEGIN



declare @NullDate datetime



select @NullDate=NULL



SELECT 1 as Tag,

NULL as Parent,

C.CustomerID as Customer_1_cid,

C.ContactName as Customer_1_name,



CR:339371
CR Number:   339371
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)
17 Feb 2004 Fixed
Description
BCP: bulk copy in with -t option may crash when copying in a file larger than 2GB.
Target Version
 12.5.1
Review Status
 Reviewed March 2004. The issue will be fixed in SDK 12.5.1 ESD #2.
Workaround Description
 Use a 64bit version of bcp



CR:339464
CR Number:   339464
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2004 Fixed
Description
Customer would like to AND connection attributes in their POOL



CR:339515
CR Number:   339515
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2004 Diagnostic Provided
Description
Document and test installing OpenSwitch as a service on Windows
Workaround Description
 1) Install it as a service:

C:\sybase\OpenSwitch-12_5\bin>OSwitch -c OpenSwitch.cfg -R install

INFO: service_install: Installed service named SWITCH1 using config file

OpenSwitch.cfg



I had to make a few changes to make this work.

2) I had to change



CR:339567
CR Number:   339567
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2004 Fixed
Description
CTLIB: OCS 12.5.1 client with its CS_NETIO property set to asynchronous mode will hang when trying to connect to pre-12.0 ASE.



CR:339841
CR Number:   339841
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 02 Nov 2004 Fixed
5.5 ESD#15 02 Nov 2004 Fixed
Description
ribo: Ribo throws java.lang.NullPointerException when converting a TDS file.



CR:339984
CR Number:   339984
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2004 Third Party Problem
Description
ODBC: Driver help file has different information about Select Method and Prepare Method than the default driver settings.



CR:340075
CR Number:   340075
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)
15.0 ESD#1 21 Dec 2005 Fixed
Description
ODBC Driver by Sybase: Request to add support for SQLBulkOperations.



CR:340079
CR Number:   340079
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Statement.setMaxRows() should be honored within cursors as well as outside the scope of cursors. Currently the setMaxRows() does not within a cursor.



jConnect should be altered to code around the current ASE behavior to provide the proper JDBC behavior which is to limit the ResultSet to the setRowMax() number of rows whether a cursor is used or not.
Workaround Description
 No known workaround.



CR:340162
CR Number:   340162
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2003 Fixed
Description
ADO.NET: Executing a stored procedure with "print" statements in the stored procedure code causes exceptions.



CR:340163
CR Number:   340163
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Dec 2003 Fixed
Description
ADO.NET: Return type for AseParameterCollection.Add method chnaged from Int32 to AseParameter.
Workaround Description
 Do this operation in steps



AseParameter p1 = new AseParamter("@p1", AseDbType.Integer);

p1.Value = 123;

myCommand.Add(p1);



CR:340381
CR Number:   340381
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Today, only ODBC Driver has the Password Encryption feature. Customer would like to have password encryption feature to OLE DB Provider.
Review Status
 Reviewed Mar 2004. There are currently no plans to implement this feature.



CR:340565
CR Number:   340565
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
setMaxRows() method is ignored when using setFetchSize() on a statement



CR:340567
CR Number:   340567
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Dec 2003 Fixed
Description
DBLIB: DB-Library doesn't return network errors.



CR:340710
CR Number:   340710
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2004 Fixed
Description
Wants OpenSwitch to send message to clients issuing commands to LOCKED server



CR:340715
CR Number:   340715
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 Dec 2003 Fixed
5.5 10 Dec 2003 Fixed
5.5 10 Dec 2003 Fixed
5.5 10 Dec 2003 Fixed
5.5 10 Dec 2003 Fixed
5.5 10 Dec 2003 Fixed
5.5 10 Dec 2003 Fixed
Description
If a client application set LITERAL_PARAMS to true, jConnect would cause an Exception to be thrown when a database name was in the connection URL, or when a customer called Connection.setCatalog(String dbName). This error no longer occurs.



CR:340817
CR Number:   340817
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2003 Fixed
02 Dec 2003 Fixed
Description
CM applications that serve more than one OpenSwitch server may not detect the failure of a secondary OpenSwitch server right away.



CR:341065
CR Number:   341065
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2004 Fixed
Description
ODBC:TDS ODBC Driver doesn't connect to an Asymmetric Secondary ASE in a HA setup



CR:341137
CR Number:   341137
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)
01 Apr 2004 Fixed
Description
ODBC: Set identity_insert tab ON causes SQL_ERROR on execution of stored procedure. Now it returns SQL_SUCCESS_WITH_INFO.



CR:341442
CR Number:   341442
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)
04 Feb 2004 Fixed
Description
SRVLIB: Some platforms reported SRV_C_DEBUG capability without srv_dbg_stack() support.



CR:341467
CR Number:   341467
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2003 Duplicate
Description
blktxt won't build, Makefile misleads customers there is dependency on libsrv
Workaround Description
 Change:

BLKLIBS = `sh sybopts.sh blk srv` $(CTLIBS)



to:

BLKLIBS = `sh sybopts.sh blk` $(CTLIBS)



CR:341667
CR Number:   341667
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 configure WorkArounds attributes via GUI.
Target Version
 To Be Determined
Review Status
 Reviewed Mar 2004. This CR is targeted (but not committed) for a future release of the product in 2005.



CR:341807
CR Number:   341807
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Fixed
Description
ADO.NET: If ASE returns informational message(s) as a result of execution of a command or stored procedure then the ADO.NET Data Provider may throw an exception. Typically these messages get generated as a result of print statements in sotored procedure or set commands such as "set showplan on".



CR:341980
CR Number:   341980
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.05 008 24 May 2004 Fixed
Description
Customer needs a way to map language requests to more than one transaction depending on selected criteria, for example, the user's ID. See General Information and Technical Notes, item 1, for reference.



CR:342025
CR Number:   342025
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2003 Fixed
5.5 11 Dec 2003 Fixed
Description
We have updated the jConnect Programmer's Reference Manual and the jConnect Installation Guide. We are now including these documents in the EBF zip files that customers can download from the web. The documents also are available online at http://manuals.sybase.com/jc.html



CR:342043
CR Number:   342043
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Fixed
13 Feb 2004 Fixed
Description
BLKLIB: blk_colval() getting invalid length when client is Windows NT and Open Server is Solaris.



CR:342254
CR Number:   342254
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2005 Fixed
09 Jun 2005 Fixed
Description
CTLIB: Occasionally fully async connections could lose SIGIO in non-reentrant library.



CR:342554
CR Number:   342554
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)
01 Apr 2004 Fixed
Description
ODBC: E_FAIL status with AddNew() and CursorLocation set to adUseClient in a Visual Basic ADO applciation. This is resolved by using the WorkArounds2=16 connection attribute. You can add this to the ADO connections string as "WA2=16". Another alternative is to add the "WorkArounds2=16" for the DSN as found in the registry under ODBC.INI.
Workaround Description
 set cursor location to adUseServer (this is the default setting)



CR:342620
CR Number:   342620
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Mar 2004 Fixed
Description
When client drops from network OpenSwitch makes Recursive Calls to srv__seterr



CR:342785
CR Number:   342785
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2004 Fixed
26 Jan 2004 Not reproducible with latest version of the product available as of Resolution Date
05 May 2004 Fixed
Description
CTLIB: Odd file descriptor limit causes SIGBUS.
Workaround Description
 To start ASE disable CT-Lib with trace flag 7821.

Reset fd's to a reasonable value, say 10,000, using the appropriate shell command:

in ksh: ulimit -n 10000



CR:342973
CR Number:   342973
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Feb 2004 Duplicate
Description
SRVLIB: Open Server does unexpected charset conversion between non-japanese charset and japanese charset.
Review Status
 Reviewed March 2004. Closed as not a bug.



CR:343024
CR Number:   343024
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2004 Fixed
Description
OCC cannot process a message longer than 512 bytes.



CR:343050
CR Number:   343050
Product Name:   ESQL
Product Component:   Cobol
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jan 2005 Fixed
20 May 2005 Fixed
Description
COBPRE: cobpre may generate COBOL codes that violate Columns 73-80 in Japanese environment.



CR:343185
CR Number:   343185
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2004 Fixed
5.5 08 Apr 2004 Fixed
Description
jConnect no longer throws a StringIndexOutOfBoundsException in the following case: Customer sets DYNAMIC_PREPARE and SELECT_OPENS_CURSOR conn properties to true, and the query contains a ...FOR UPDATE clause.



CR:343200
CR Number:   343200
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
5.5 08 Apr 2004 Fixed
5.5 08 Apr 2004 Fixed
Description
When a client tried to set the BE_AS_JDBC_COMPLIANT_AS_POSSIBLE property, and passed that value in with a Properties object to the DriverManager.getConnection method, jConnect would wind up resetting all the prop values that are triggered when the jdbc compliance prop is set. jConnect now sets the JDBC compliance properties properly.



CR:343207
CR Number:   343207
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 Jan 2004 Fixed
09 Jan 2004 Fixed
Description
ISQL: Using ASE feature real-time messaging may cause core dump in ISQL.



CR:343251
CR Number:   343251
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)
09 Feb 2004 Fixed
Description
ODBC: No updates were allowed on disconnected ADO Recordset from a stored procedure call, after upgrading to the 4.20 driver build. Application would recieve the error

"-2147217887 : Multiple-step operation generated errors. Check each status value." To prevent this from happening, a new connection option is required, ReportUnknownForUpdatable, which is False (0) by default. When set to TRUE (1), this option will always return SQL_ATTR_READWRITE_UNKNOWN for the SQL_DESC_UPDATABLE field of the result column descriptors. This will only apply to stored procedure result sets.
Workaround Description
 Removal of EXEC keyword will enable this to work. However, this is unreasonable as customer has Many apps to change (1000)



CR:343256
CR Number:   343256
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2004 Fixed
Description
DBLIB: Allow dblib on Windows NT to use directory services other than the interfaces file.



CR:343341
CR Number:   343341
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)
12 Apr 2004 Duplicate
Description
NETLIB: sql.ini entries for name pipes using NAMEPIPE are not recognized
Review Status
 Reviewed June 2004. Closed as a duplicate of CR 339270.
Workaround Description
 manually change NAMEPIPE to MSNMP in the sql.ini. Note: also pre-339270, make the entry of the form:

master=MSNMP,\\.\pipe\sql\<name>



CR:343354
CR Number:   343354
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2004 Fixed
Description
jConnect: If you call PreparedStatement.setBinaryStream() and at runtime, the user InputStream throws an IOException, jConnect does not cleanup the network buffers completely. As a result, the subsequent command including the call to rollback() will receive an exception.
Target Version
 To Be Determined
Review Status
 Reviewed June 2004. CR is still under review by engineering.
Workaround Description
 1. Catch the IOException in the InsputStream so that it does not propagate to jConnect and after the insert/update is successful, then issue rollback().

2. OR catch the SQLException thrown by jConnect when the IOException thrown by InputStream is encountered, then call the rollback() method twice. The first rollback() will throw another SQLException due to state of network buffers. You need to catch that exception and reissue rollback() the second time.



CR:343384
CR Number:   343384
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2004 Fixed
5.5 09 Feb 2004 Fixed
5.5 09 Feb 2004 Fixed
5.5 09 Feb 2004 Fixed
5.5 09 Feb 2004 Fixed
5.5 09 Feb 2004 Fixed
Description
jConnect now returns metadata properly when PreparedStatement.getMetaData is called. Previously, we were only returning metadata if the statement was dynamically prepared.



CR:343430
CR Number:   343430
Product Name:   Open Client/Open Server-Doc
Product Component:   Release Bulletin
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 24 Aug 2005 Fixed
Description
SDK and Open Server 12.5.1 require Solaris patch 108993-18 or later.



CR:343643
CR Number:   343643
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2004 Fixed
Description
OLEDB: Version 2.70 ignores MaxRecords property when Select Method = Cursor



CR:343967
CR Number:   343967
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Fixed
Description
ADO.NET: The "Max Pool Size" connection property is not being utilized to limit the maximum number of concurrent connections to the database.



CR:344035
CR Number:   344035
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
Open Server leaks memory when shut down from a STOP_SRV event





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

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。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------