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

 

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

如有问题,请联系我!

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

 

CR:321839
CR Number:   321839
Product Name:   Open Client-Doc
Product Component:   Client-Library C Reference Manual
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Added new Open Client property ARRAY_INSERT for Bulk-Library API bulk_props().



CR:321881
CR Number:   321881
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2003 Fixed
15 Mar 2004 Fixed
20 Jun 2003 Fixed
25 Jul 2003 Fixed
Description
When cache is turned on and OpenSwitch is under heavy connection load, some client sessions will hang.



CR:321962
CR Number:   321962
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)
11 Aug 2003 Fixed
Description
Transaction is not def message is used for a catch all message by ctxh.



CR:322108
CR Number:   322108
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)
12.5 11 Aug 2003 Fixed
Description
The SO_LINGER SetSOCKET Option need to be removed for OCC Connections. The Linger call seems to be hanging cics region waiting to close Connections.



CR:322240
CR Number:   322240
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2003 Fixed
17 Jun 2003 Fixed
17 Jun 2003 Fixed
Description
COMNLIB: Numeric division may give incorrect results when divisor is very small.



CR:322478
CR Number:   322478
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.2 08 Oct 2003 Fixed
5.2 08 Oct 2003 Fixed
5.5 08 Oct 2003 Fixed
5.2 08 Oct 2003 Fixed
5.2 08 Oct 2003 Fixed
Description
jConnect can now handle numerics up to 127 precision/scale. Note that Sybase Adaptive Server Enterprise has a limit of 38 for precision/scale. Adaptive Server Anywhere has a larger limit, which is why jConnect was upgraded.
Workaround Description
 pvero 6-12-03:

It appears that the customer can use setString on ASA (on ASE you would need to use T-SQL convert command - i have not tested but this customer is only using ASA to my knowledge.)



CR:322597
CR Number:   322597
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
SSL handshake failure when logging into open server sometimes doesn't result in SRV_T_IODEAD being set.



CR:322661
CR Number:   322661
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Dec 2003 Fixed
25 Jul 2003 Fixed
23 Dec 2003 Fixed
Description
CM timer does not work on NT.



CR:322687
CR Number:   322687
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 Jun 2003 Fixed
5.5 20 Jun 2003 Fixed
5.5 20 Jun 2003 Fixed
5.5 20 Jun 2003 Fixed
5.5 20 Jun 2003 Fixed
5.5 20 Jun 2003 Fixed
Description
jConnect is now more intelligent about the way it sends unichar/univarchar data to servers that support those datatypes.



To request unichar/univarchar support, a client must set the JCONNECT_VERSION connection property to 6. Furthermore, a client must set the DISABLE_UNICHAR_SENDING property to false (we have changed this property so that it now defaults to true).



When unichar/univarchar is properly enabled, jConnect will send unichar/univarchar parameter data only if the characters cannot be converted to the negotatiated character set of the Connection.



For example, if the server has iso_1 as the default character set, and the client tries to send a unichar representation of the euro character (and unichar is enabled), jConnect will send the String to the server as unichar/univarchar.



CR:322806
CR Number:   322806
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)
20 Jun 2003 Fixed
20 Jun 2003 Fixed
19 Jun 2003 Fixed
Description
ISQL: Numeric division resulting in precision > 62 raises overflow message in cs_convert()



CR:322901
CR Number:   322901
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)
01 Dec 2004 Fixed
Description
Enhance the "Receive time out" error message to include the IP address of the connecting client.



CR:323048
CR Number:   323048
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
Provide a configuration switch to disable password checking, and validate only the userid.



CR:323170
CR Number:   323170
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 02 13 Sep 2007 Fixed
Description
Introduce Secured Socket Layer (SSL) protocol support in OpenServer Connect, on

both SNA and TCP/IP protocols



CR:323279
CR Number:   323279
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Not a Bug
25 Jul 2003 Fixed
24 Mar 2004 Fixed
Description
Wildcard expressions are not recognized in the POOL section of the config file.



CR:323627
CR Number:   323627
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)
21 Oct 2003 Fixed
Description
ODBC: ADO property (Commmand object) CommandTimeout was not working prior to this release.



CR:323711
CR Number:   323711
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2003 Fixed
07 Aug 2003 Fixed
25 Jul 2003 Fixed
Description
BCP: bcp fails while copying in univarchar utf8 data in native format
Workaround Description
 Use unichar columns or copy data out in character format

(and use column/row delimiters if needed).



CR:323821
CR Number:   323821
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)
19 Aug 2003 Fixed
Description
ODBC: Running query in MS Access 2002 on Windows XP that loops over the execution and returns large result set can result in memory access error resulting in an application crash.



CR:323957
CR Number:   323957
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2004 EOL'd version. Not to be Fixed.
Description
Need ability to re-enable server side character set conversion
Target Version
 To Be Determined
Review Status
 Reviewed Aug 2003. No fix targeted at this time. Workaround: set the property BLK_CONV to have blklib convert the characters itself(also set CS_NOCHARSETCNV_REQD=CS_TRUE). Then, call ct_command with 'set char_convert ', such as 'set char_convert iso_1'.
Workaround Description
 Read the results back from the server on a second

connection that has server character conversion enabled.



CR:324278
CR Number:   324278
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2004 Not reproducible with latest version of the product available as of Resolution Date
03 Aug 2003 Fixed
Description
When OpenSwitch is connected to an ASE on NT, the resource monitor fails to cancel client connections even when it detects that the resource limit has been exceeded.



CR:324352
CR Number:   324352
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2003 Fixed
23 Jul 2003 Fixed
Description
BCP: Multiple fixes concerning (var)char and (var)binary columns of size 256 and up.
Workaround Description
 Use a maximum column size of 255 characters.



CR:324566
CR Number:   324566
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2003 Fixed
05 Mar 2004 Fixed
Description
rp_pool_attrib does not recognize duplicate entries and will continue to add them to the pool even when they already exist. Similarly, to remove these duplicate entries from a pool, the user will need to execute rp_pool_remattrib multiple times as well.



CR:324645
CR Number:   324645
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)
16 Oct 2003 Fixed
Description
ODBC: Applications may crash with corrupted memory when processing results from stored procedures that access remote OpenServer applications.



CR:324671
CR Number:   324671
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2003 Fixed
5.2 29 Aug 2003 Fixed
5.2 29 Aug 2003 Fixed
5.2 29 Aug 2003 Fixed
5.2 29 Aug 2003 Fixed
5.2 29 Aug 2003 Fixed
5.5 17 Sep 2003 Fixed
17 Sep 2003 Fixed
Description
jConnect now properly handles batches of dynamic prepared statements. Previously, jConnect would sporadically fail to send the parameters to the server correctly.



CR:324744
CR Number:   324744
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
Description
cs_convert truncates numbers when using non-english locale like german or french
Review Status
 Reviewed Mar 2004. Closed as not to be fixed. There will be no support for other numeric separators based on locale settings.
Workaround Description
 Customer can write/install their own custom conversion routine

like we illustrate in the sample i18n.c.



CR:324750
CR Number:   324750
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2003 Fixed
21 Jul 2003 Fixed
Description
LDAP: Clients (isql, dsedit) may fail with segmentation violation when LDAP server returns a blank transport type



CR:324752
CR Number:   324752
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   IRIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2003 Fixed
10 Nov 2003 Fixed
Description
Samples: Makefile/sybopts.sh incorrect for irix sgi64 missing -DSYB_LP64
Target Version
 12.5.1
Review Status
 Reviewed March 2004. Fix is in 12.5.1 ESD #1.
Workaround Description
 Add -DSYB_LP64 to compile line



CR:324786
CR Number:   324786
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2004 Not reproducible with latest version of the product available as of Resolution Date
Description
executeBatch() throws SQLException "JZ0SB Parameter index out of bounds"

when called with many paramters multiple times.



CR:325110
CR Number:   325110
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.6 ESD#2 11 Aug 2006 Fixed
Description
MFC Server Option for CICS, the listener cannot be restarted after abnormal end because its port was not released



CR:325303
CR Number:   325303
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 Jul 2003 Fixed
5.5 11 Jul 2003 Fixed
Description
The DatabaseMetaData.getBestRowIdentifier method does not fail anymore with the following error: 'com.sybase.jdbc2.jdbc.SybSQLException: Attempt to insert NULL value into column 'DECIMAL_DIGITS', table '#bestinfo'; column does not allow nulls. Update fails.' The method now executes as expected.



CR:325371
CR Number:   325371
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)
25 Feb 2004 Fixed
Description
BCP: Under some circumstances, BCP might run into memory allocation errors when large batch sizes are used.



CR:325575
CR Number:   325575
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 29 Mar 2004 Fixed
25 Jul 2003 Fixed
Description
The RCM configuration parameters monitor_wait and timer_interval cannot be equal to one another. When the two parameters are equal, the RCM hangs at startup and does not provide a clear error message. Users may not realize that the startup did not complete since no errors message is written to the log. Note the RCM log file should conclude with the statement: "The Replication Coordination Module (RCM) has started." when the initialization steps complete successfully.



CR:325604
CR Number:   325604
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)
06 May 2004 Not a Bug
Description
ODBC: Exec keyword contributes to message: "Multiple-step operation generated errors. Check each status value."
Workaround Description
 Remove "EXEC " keyword from code - in QueryString



CR:325895
CR Number:   325895
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
Datetime value is read incorrecly by OLEDB Provider.
Workaround Description
 Use ODBC Driver instead.



CR:326265
CR Number:   326265
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2004 Not reproducible with latest version of the product available as of Resolution Date
03 Aug 2003 Fixed
Description
OpenSwitch could core dump when large number of debugging messages are

written to log file (such as with DEBUG=a) in stress-test mode.



Workaround: Use DEBUG=a only for debugging purposes when there is a problem.

Otherwise, DEBUG=e is recommended.



CR:326416
CR Number:   326416
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Aug 2003 Fixed
06 Aug 2003 Fixed
Description
BCP: Truncate trailing spaces when bcp'ing into a univarchar column.



CR:326501
CR Number:   326501
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Solaris
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Allow regular connection attempts to retry an alternate host/port combination even if LDAP and HA are not being used. Similar to CR 305625 without the LDAP and HA requirements.
Target Version
 To Be Determined
Review Status
 Reviewed March 2004. This CR is targeted for a future release of the product. No definite version as yet.
Workaround Description
 Only workaround at present is to have the customer jConnection application retry. This is difficult if there is connection pooling or the customer doesn't have control of the process obtaining the connections.



CR:326567
CR Number:   326567
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 29 Mar 2004 Fixed
25 Jul 2003 Fixed
Description
The Replication Coordination Module (RCM) utilizes the native operating system's "ping" utility to verify the existence of servers that RCM monitors. When RCM "pings" a server on the IBM platform, the executation of RCM hangs (discontinues execution, but does not halt).
Workaround Description
 RCM allows users to supercede the default ping command, and adding the following line to the RCM configuration file will workaround this problem.



PING_HOST_CMD = /usr/sbin/ping -c 1 %s



CR:326666
CR Number:   326666
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Solaris
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Downloading SybMetaData from a server is slow and all sybase servers don't implement metadata (e.g. OpenServer). If SybMetaData could be serialized to a local file, and used at connection start then it would not have to downloaded from a server everytime. The data could also be downloaded from one server and used on other servers.
Target Version
 To Be Determined
Review Status
 Reviewed March 2004. This CR is still in review.



CR:326667
CR Number:   326667
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
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.
Description
jConnect implementation often requires SybMetaData to be handled by the server. Customers would like to use jConnect against openservers. OpenServer needs to implement minimal sp_mda metadata capability for those customers wishing to use jConnect against their installed openserver.
Target Version
 To Be Determined
Review Status
 Reviewed March 2004. This CR is still in review.



CR:326849
CR Number:   326849
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 09 Mar 2004 Fixed
Description
SYCM ASRA under a certain condition when trying to cancel a Listener. Not sure why this is happening. The Dump shows that the ASRA was because we try to access a SYMNMS2O map field on MAP SYOSMGM, the problem is that the Base register for the MAP has been over layed. The base Reg is Reg 4 and at the time of the Abend it contained '40000000' not a vaild Address.



CR:326882
CR Number:   326882
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Aug 2003 Fixed
07 Aug 2003 Fixed
Description
BCP: bcp does not set hostname which is displayed by sp_who
Workaround Description
 Set the CS_HOSTNAME

property in their "ocs.cfg" file like this:

[bcp]

CS_HOSTNAME = bluedragon



CR:326887
CR Number:   326887
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)
06 May 2004 Fixed
Description
OLEDB: When CursorLocation=adUseClient, an error, "-2147467259 Data provider or other service returned an E_FAIL status", occurs when select involves TEXT column.
Workaround Description
 Use ODBC Driver, or set CursorLocation=adUseServer



CR:327159
CR Number:   327159
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2003 Fixed
07 Aug 2003 Fixed
Description
ISQL:isql does not recognize return status correctly when CS_BEHAVIOR is set to CS_BEHAVIOR_100.



CR:327199
CR Number:   327199
Product Name:   Open Client/Open Server-Doc
Product Component:   Common Libraries Reference Manual
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Fixed
Description
Setting CS_OPT_NOCOUNT to CS_TRUE or executing the SQL "set nocount on" on a connection before executing a bcp operation causes erroneous error messages saying that the operation has failed upon completion.
Target Version
 12.5
Review Status
 Reviewed Mar 2004. The changes are included in the 12.5.1 Common Libraries manual.



CR:327253
CR Number:   327253
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: AddNew() not generating full INSERT statement



CR:327297
CR Number:   327297
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2003 Fixed
29 Aug 2003 Fixed
Description
CPRE:Under some circumstances,ESQL/C incorrectly splits lines of SQL files when processing string literals.



CR:327343
CR Number:   327343
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.6 ESD#2 15 Jun 2006 Fixed
Description
Customer would lke to use SYCM to referesh the TCP/IP env, rather then running SYBCLOS and SYBOPEN. Have a away via SYCM screen, possible a a PF key.... To close an Open the Listeners and clear out the Global Area. So that changes in the SYLSCFG can be updated easier.



CR:327376
CR Number:   327376
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   IRIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2004 Fixed
Description
Open Client Release Bulletin only states OS IRIX 6.5 is required. But open client/server software will not run on older hardware based on the mips3 hardware platform. For SGI we should clearly state hardware dependancies in addition to the required OS versions.
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:327644
CR Number:   327644
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Retrieve Database names list from server in login dialogbox instead of fixes comma separate list.
Target Version
 To Be Determined
Review Status
 Reviewed March 2004. This CR targeted (but not comitted) for a future release of the product in 2005.
Workaround Description
 No workaround



CR:327647
CR Number:   327647
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Database list in Setup of dialogbox can hold only 255 characters
Target Version
 12.5
Workaround Description
 Use less datbase names in Database list



CR:328613
CR Number:   328613
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)
21 Oct 2003 Fixed
Description
OLEDB: When executing a stored procedure with an input parameter of varchar datatype, the provider wrongly passes an empty string as a NULL string to ASE.



CR:328651
CR Number:   328651
Product Name:   Other - Docs: Connectivity
Product Component:   Other - Docs: Connectivity
Status:   Closed
OS:   Unknown
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2004 Fixed
Description
Cover letters need to warn about missing components



CR:328655
CR Number:   328655
Product Name:   Open Client-Doc
Product Component:   Client-Library Release Bulletin
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2004 Fixed
Description
Update Release Bulletins on DB-Library issues
Target Version
 12.5.1
Review Status
 Reviewed March 2004. The requested updates have been made to the 12.5.1 documentation.



CR:328838
CR Number:   328838
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for the ability to bcp out using dirty reads (transaction isolation level 0)



CR:328964
CR Number:   328964
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2003 Not a Bug
Description
Bulk-Lib reports error w/ ASE 12.5.0.3 multiple tempdb "#" temp tables:

Message number: LAYER = (0) ORIGIN = (0) SEVERITY = (0) NUMBER = (0)

Message String: blk_init(): blk layer: internal BLK-Library error: Failed when CT_Lib routine ct_fetch(BLK_IN_GET_FMT) called.
Workaround Description
 Don't use "#" pound in the name of temptables.



CR:328965
CR Number:   328965
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Dec 2003 Fixed
Description
BLKLIB: blklib does not support ASE multiple temporary databases feature
Target Version
 12.5.1
Review Status
 Reviewed March 2004. The issue is fixed in SDK 12.5.1 ESD #1.
Workaround Description
 Don't use "#" pound in the name of temptables.



CR:328989
CR Number:   328989
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 Feb 2004 Fixed
Description
BLKLIB: When NETIO is ASYNC or DEFER, blk_done will react incorrectly to ct_cancel requests.



CR:329073
CR Number:   329073
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
Spaces trimmed by OLEDB Provider between SQL Statement and argument.

Workaround is to use ODBC Driver 4.20 instead.
Workaround Description
 Use ODBC Driver 4.20 instead.



CR:329245
CR Number:   329245
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2003 Fixed
5.5 15 Sep 2003 Fixed
Description
jConnect no longer truncates RPC parameters to INTEGER types when the client has registered the parameter as a BIGINT.



CR:329421
CR Number:   329421
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
Description
setObject(Types.LONGVARCHAR) must send a LONGCHAR datatype if possible (as stated in the JDBC javadocs). Previously, jConnect would send the param as VARCHAR or CHAR datatype if the param was <= 255 chars.
Workaround Description
 None.



CR:329429
CR Number:   329429
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)
16 Oct 2003 Fixed
Description
OLEDB: does not handle varbinary or varchar params longer than 255 bytes.
Workaround Description
 Use the ODBC driver.



CR:329535
CR Number:   329535
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2003 Fixed
5.5 15 Sep 2003 Fixed
Description
jConnect has added the IMPLICIT_CURSOR_FETCH_SIZE connection property to aid customers who do large selects interleaved with metadata calls.



This property is used in conjunction with the SELECT_OPENS_CURSOR property. When SELECT_OPENS_CURSOR is set to true, *and* this property is set to any positive value, select statements executed by the client will open a cursor. The cursor will have a fetch size of the value set with this property.



Note that when this property is set, jConnect changes the way it normally interprets the SELECT_OPENS_CURSOR property; normally SELECT_OPENS_CURSOR will open a cursor only if the SQL contains a 'FOR UPDATE' clause. When IMPLICIT_CURSOR_FETCH_SIZE is set to some non-zero value, jConnect will open a cursor for every select, with or without a FOR UPDATE.



CR:329622
CR Number:   329622
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)
03 Sep 2003 Fixed
Description
CTISQL: isql doesn't display the correct error message when textsize is set to a very large value using 'set textsize <value>'.



CR:329719
CR Number:   329719
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2004 EOL'd version. Not to be Fixed.
Description
isql mixes row count string with print output if CS_BEHAVIOR is CS_BEHAVIOR_100.
Target Version
 12.5.1
Review Status
 Reviewed March 2004. Bug will be fixed in an upcoming 12.5.1 EBF (EBF # not targeted as yet).



CR:329979
CR Number:   329979
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2003 Fixed
Description
SRVLIB: setjmp apparently doesn't flush the RSE on Linux which may cause problems down the road.



CR:330046
CR Number:   330046
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
EventListener.connectionClose() gets invoked when PoolConnection.getConnection()

is called twice for the same PoolConnection object (which will implicitly close

the connection open by the first call). JDBC spec says that this should not happen.
Workaround Description
 Ignore the connectionClose event.



CR:330245
CR Number:   330245
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)
10 Sep 2003 Fixed
Description
BCP: Core dumps if connection is lost on 'Copy in'



CR:330288
CR Number:   330288
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
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.
Description
Customer wants bcp/isql to try standby servers in interfaces file silently
Workaround Description
 Use "-m3" for isql, nothing for bcp



CR:330297
CR Number:   330297
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: adCurrency reports incorrect values when used as Output parameter
Workaround Description
 Use adDouble for the datatype



CR:330322
CR Number:   330322
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)
25 Feb 2004 Fixed
Description
ODBC: MS Access -7776 error with import table on 1.2 GHz PC due to a datetime column.



CR:330593
CR Number:   330593
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   NA
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2004 Fixed
17 May 2004 Presently Not Targeted For Any Future Release Of This Product
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
CT-LIB: Under some circumstances, CT-LIB application may have performance degradation when receiving large resultsets.



CR:330682
CR Number:   330682
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)
28 Oct 2003 Fixed
Description
ODBC: CtLib based driver, 4.10, is adding 0x00 to character strings that are greater than 255 bytes in length. This did not occur on previous versions.
Workaround Description
 Works with TDS based but customer is not using tds based on their older applciations - see Business Impact in the Description section.



CR:330703
CR Number:   330703
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2003 Fixed
Description
BLKLIB: blk_bind() ignores localization defined at the connection and data element level.



CR:330849
CR Number:   330849
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 implement getSQLStateType
Target Version
 6.0
Review Status
 Reviewed March 2004. This CR is targeted (but not committed) to the next major release of the product scheduled for 2005.



CR:330874
CR Number:   330874
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)
29 Aug 2006 Fixed
31 Aug 2006 Fixed
Description
CTLIB: A CT-Library application core dumps when it calls ct_data_info() after ct_get_data() is called on a non text/image column.



CR:330970
CR Number:   330970
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2003 Fixed
Description
The CM or RCM process consumes a large percentage of CPU cycles.
Workaround Description
 None.



CR:331024
CR Number:   331024
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
5.5 10 Sep 2003 Fixed
Description
jConnect would sometimes fail to call clearBatch() after a successful call to executeBatch. The JDBC specification states that clearBatch must be called, and jConnect now follows the spec when executeBatch is called.



CR:331166
CR Number:   331166
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2003 Fixed
Description
OpenSwitch segfaults because mem_free is being called on memory that is not allocated on the heap.



CR:331209
CR Number:   331209
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Setting SRV_S_IFILE servername length as 255 fails, on 12.5, worked on 12.0.



Customer finds srv_props(CS_SET,SRV_S_IFILE) regression moving from

12.0 openserver to 12.5 openserver.



char intf[255] = {"\0"};



strcpy(intf, "./interfaces");

retcode = srv_props(ctos_ctx->cx_context, CS_SET, SRV_S_IFILE, intf, CS

_SIZEOF(intf), (CS_INT *) NULL);
Workaround Description
 code variable as char name[254]; or use strlen(variable) on the srv_props() call.



So,



char intf[255] = {"\0"};



strcpy(intf, "./interfaces");

retcode = srv_props(ctos_ctx->cx_context, CS_SET, SRV_S_IFILE, intf



CR:331243
CR Number:   331243
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 29 Mar 2004 Fixed
Description
rcm.loc is missing certain locales messages



CR:331247
CR Number:   331247
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2003 Fixed
Description
Users cannot connect to primary OpenSwitch when RCM is configured for redundancy.
Workaround Description
 Don't use a "SECONDARY_OPENSWITCH" in your rcm.cfg file.



CR:331285
CR Number:   331285
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2007 Fixed
16 Feb 2007 Fixed
Description
BCP: Hexadecimal and octal field/row terminators are not correctly stored in the bcp data file.



CR:331333
CR Number:   331333
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2003 Fixed
17 Sep 2003 Fixed
Description
CM needs to be able to set the timeout value of its connections to the OpenSwitch server to other than the default 60 seconds.



CR:331362
CR Number:   331362
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: When "set nocount on" is set, headings for empty result sets are not returned to the client.
Workaround Description
 set nocount off



CR:331472
CR Number:   331472
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Sep 2003 Fixed
12 Sep 2003 Fixed
Description
When OpenSwitch is configured with CMON=1, SWITCH_AT_LOGIN_TIMEOUT=1, and RESPONSE_TIMEOUT<60, user connections are switched back and forth between the primary and secondary Adaptive Servers.
Workaround Description
 Turn CMON off, CMON=0



CR:331631
CR Number:   331631
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Oct 2003 Not a Bug
Description
CS_LOGIN_TIMEOUT does not work in external configuration file ocs.cfg
Review Status
 Reviewed March 2004. This issue is closed as not being a bug.
Workaround Description
 Use the "-l" parameter.



CR:331706
CR Number:   331706
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)
27 Oct 2003 Fixed
Description
CSLIB: cs_convert() using a locale from a different context could fail.



CR:331731
CR Number:   331731
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: No cursor deallocation when ADO Recordset object is closed. Now when RecordsetObject.Close is issued the ASE cursors will be closed and deallocated.



CR:332279
CR Number:   332279
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Oct 2003 Presently Not Targeted For Any Future Release Of This Product
12 Nov 2003 Fixed
Description
BCP: When bcp -Y truncates data no error messages are displayed.



CR:332294
CR Number:   332294
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)
12.5 09 Mar 2004 Fixed
Description
OCC cannot process XNL datatype of INT8, 64 bit integer.



CR:332389
CR Number:   332389
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 Sep 2003 Fixed
Description
jConnect has changed its default data caching strategy. When jConnect is done using data it has cached, jConnect now releases that data to Java's garbage collector. Previously, jConnect would manage its own internal memory cache. But, we have found that Java's improvements in garbage collection mean that customers will see better performance if we allow the Java Virtual Machine to garbage-collect old data.



This change should result in better performance for some customer applications. It will not hurt performance.



CR:332700
CR Number:   332700
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#1 01 10 Dec 2007 Fixed
Description
TRACE=Y may be added to the SYBTPSEC macro for TCP listener tracing that shows the client IP address.



CR:332767
CR Number:   332767
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)
01 Oct 2003 Fixed
Description
SRVLIB: On Solaris and Linux platforms,srv_dbg_stack was not able to obtain a stacktrace for other threads in reentrant libraries.



CR:332812
CR Number:   332812
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 Not reproducible with latest version of the product available as of Resolution Date
Description
OpenSwitch 12.5 hangs with 100 users when run in FULL_PASSTHRU mode
Workaround Description
 Don't use FULL_PASSTHRU mode.



CR:332865
CR Number:   332865
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2003 Fixed
Description
Some memory errors that were exposed during internal testing need to be addressed on all platforms.



CR:333018
CR Number:   333018
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)
30 Sep 2003 Fixed
16 Oct 2003 Fixed
Description
CTLIB, SRVLIB: Solaris 8 /usr/lib/libthread.so has issues. Use /usr/lib/lwp/libthread.so instead.
Workaround Description
 Set LD_LIBRARY_PATH environment variable to include /usr/lib/lwp (/usr/lib/lwp/sparcv9 for 64-bit applications.)



CR:333167
CR Number:   333167
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2004 EOL'd version. Not to be Fixed.
17 May 2005 Fixed
17 May 2005 Fixed
Description
BCP: When bcp fails to copy a batch into ASE, it erroneously reports that the operation is successful.



CR:333225
CR Number:   333225
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)
20 Nov 2003 Fixed
Description
CTLIB: Non-threaded libraries were setting and resetting the signal mask too frequently

resulting in reduced performance.



CR:333326
CR Number:   333326
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2003 Fixed
19 Nov 2003 Fixed
15 Dec 2003 Fixed
Description
CM blocks users from logging in during ping intervals.
Workaround Description
 Set the cm_timer_add() period to something small like

5000 (5 seconds) so that impact to end users is minimized.



CR:333474
CR Number:   333474
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)
esd1 15 Oct 2003 Fixed
Description
CTLIB: Unable to connect to ASA, ASIQ, MSSQL, DB2 using sp_addserver host/port number.





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

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

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

ReadASADB适用场景

各种误操作:

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

本工具的应用场景:

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