远程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:273145
CR Number:   273145
Product Name:   Connectivity Utilities
Product Component:   scripts
Status:   Closed
OS:   Linux
Original Version:   11.1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2002 Fixed
Description
Linux post install script, SWR 9803 and 9939 RPM, does not install new files that are not installed during GA/Rollup release.
Workaround Description
 For example, 'rpm2cpio' can extract tgz file from rpm file.
(Other tool exists, like rpm2tgz,alien)

1.rpm2cpio sybase-SWR9803-1.i386.rpm | cpio -id
2.Extracted file is : opt/sybase-11.9.2/SWR/SWR-9803.tar.gz
3.tar xvfz SWR-9803.tar.gz
4.cp -pr * $SYBASE



CR:279302
CR Number:   279302
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   AIX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2002 Presently Not Targeted For Any Future Release Of This Product
Description
When executing remote procedure using "ctisql", an additional message (eg. 1 row affected) is printed while dbisql does not show this message.



Resolution: Reviewed Sep 2002. Presently not targeted for any future release of the product as changes between dblib and ctlib based isql are expected. This is documented in the 11.1 'Release Bulletin Open Client/Server' manual, section on 'Standalone Utilities'.

There are several differences between dblib and ctlib based isql. A change so late in the game could cause a regression to scripts at other customer sites.



CR:279451
CR Number:   279451
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)
11 Mar 2003 Fixed
Description
OCC does not support the TDS 5.0 Returm Parm format.
Workaround Description
 No Workaround



CR:279892
CR Number:   279892
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2002 Fixed
Description
OSC 12.5 EBFI0335 not freeing up one of the 2 TDSPROCS which are allocated, leaving 1524 bytes of shared memory around below is a code frag from CTDSMS stdfree routine.



CR:280053
CR Number:   280053
Product Name:   Open Client for MVS
Product Component:   Open Client for MVS
Status:   Closed
OS:   MVS
Original Version:   10.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Apr 2003 Fixed
Description
OCC MVS 3.2 EBF6780 not process Cancel correctly ctbreults fails
Workaround Description
 NONE



CR:280245
CR Number:   280245
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)
MAP006 07 Oct 2002 Fixed
Description
Add gatewayless support for sgw_setserver rpc



CR:280283
CR Number:   280283
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)
30 Dec 2002 Fixed
Description
OLEDB: adTinyInt datatype in ADO application, when used as a parameter in a stored procedure, caused an error: "The given type name is unrecognized." Sybase ASE tinyint datatype was not supported as parameter in stored procedure. It is now.
Workaround Description
 Can use adInteger for the ADO type - but this would allow programmer to pass invalid range of values if they are not carefule (Like negative ints or ints greater than 255).



CR:286543
CR Number:   286543
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2002 Fixed
16 Aug 2002 Not a Bug
14 Apr 2003 Fixed
25 Aug 2003 Fixed
Description
CPRE: cpre core dumps on structure declarations as a result of the fix to CR 254863.
Workaround Description
 Use cpre from an EBF prior to 9917.



CR:286574
CR Number:   286574
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)
11 Mar 2003 Fixed
Description
OCC 12.5 problems with ASE 12.5 support



CR:286671
CR Number:   286671
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
4.2 03 Jun 2002 Fixed
4.5 03 Jun 2002 Fixed
Description
Because of an error in the jConnect metadata, customers using ASA7 or higher could not take advantage of the Dynamic Class Loading feature in jConnect. That bug has been fixed.



CR:286966
CR Number:   286966
Product Name:   ESQL
Product Component:   Cobol
Status:   Closed
OS:   OpenVMS
Original Version:   10.0.4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2002 Fixed
Description
ESQL: COBPRE produces invalid area A code when used in /terminal mode on VMS



CR:287137
CR Number:   287137
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   11.1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2002 Presently Not Targeted For Any Future Release Of This Product
27 Aug 2002 Fixed
15 Sep 2002 Fixed
28 Oct 2002 Fixed
Description
CTLIB: ct_connect uses retry delay value from interfaces as login timeout.
Workaround Description
 1) Remove the retry/delay values from the interfaces file

so that the default login timeout of 60 seconds is used.



CR:287160
CR Number:   287160
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jun 2002 Fixed
4.5 18 Jun 2002 Fixed
4.5 18 Jun 2002 Fixed
4.5 18 Jun 2002 Fixed
4.5 18 Jun 2002 Fixed
4.5 18 Jun 2002 Fixed
Description
jTDS no longer hits a ClassCastException in the case where widetable is enabled and the client passes in a SrvDataFormat object to the

sendResults (SrvSession, SrvDataFormat [], Object [][]) method.



Clients wishing to send widetable results with the sendResults method should pass in an array of SrvRowDataFormat2 objects to the newly created

sendResults (SrvSession, DataFormat [], Object [][]) method.



CR:287247
CR Number:   287247
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2003 Duplicate
Description
The request of this CR is to enable support for LONGCHAR in bcp



CR:287576
CR Number:   287576
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2003 Fixed
Description
Need fix for CR279451 ported to OCC CICS 4.0
Workaround Description
 No Workaround



CR:287581
CR Number:   287581
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2002 Fixed
11 Jul 2002 Fixed
24 Jul 2002 Fixed
Description
CTLIB: When retry_count property is used, ct_connect does not attempt to retry the connection upon connection failure/timeout.



CR:287714
CR Number:   287714
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2002 Fixed
Description
OpenSwitch crashes when admin users issues blank exec command.



CR:287731
CR Number:   287731
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 Jun 2002 Fixed
Description
ODBC: A table with a Primary Key consisting of varchar, int, datetime and including 2 additional fields of text, datetime will fail when opened in MS Access after linking to the table. When opened data references display #DELETED instead of the actual data in the table.
Workaround Description
 None *except use GA odbc version



CR:287840
CR Number:   287840
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 Jun 2002 Fixed
Description
ODBC: With 4.10.0000 (EBF 9970) ODBC Driver, showplan results were returned as SQL_ERROR instead of SQL_SUCCESS_WITH_INFO. Also the order of the message text was incorrect.



CR:287865
CR Number:   287865
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request to enhance bcp so it has an option to delete rows as they are extracted. This is to address the need for a method to extract a table and then truncate it as one transaction, to prevent other users from modifying the data between the extraction and the deletion of the rows.



Status: Reviewed Sep 2002. Pending further investigation by Engineering.



CR:288013
CR Number:   288013
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Sep 2002 Fixed
27 Oct 2002 Fixed
28 Oct 2002 Fixed
Description
CTLIB: ct_get_data() incorrectly returns a length value of 2 for null value numeric columns. Null values should return zero for all types.
Workaround Description
 Code applications to assume that numeric types of length 2 or less are NULL values.



CR:288048
CR Number:   288048
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2002 Fixed
Description
There was an issue with TDS packet processing in the client code while it waited for

an acknowledgement of the TDS attention packet. The problem occurs while putting

together confidential data packets to determine if the ack has arrived.



CR:288113
CR Number:   288113
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2002 Fixed
26 Jul 2002 Fixed
28 Jan 2003 Fixed
03 Mar 2003 Fixed
02 Apr 2003 Fixed
15 Jul 2003 Fixed
30 Sep 2003 Fixed
Description
OpenSwitch should be configurable to failover at login timeout or connect timeout, and these timeout values should also be configurable in the OpenSwitch config file.
Workaround Description
 None.



CR:288132
CR Number:   288132
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)
02 Mar 2004 Fixed
Description
ODBC: With MS Access 2000 users this error sometimes appeared when building a query: "Invalid precision value. Error in parameter 1." This problem no longer occurs. You need to set WorkArounds2=32768.



CR:288181
CR Number:   288181
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)
27 Feb 2003 Fixed
Description
ODBC: Connection behavior using MS Access with attribute DRIVER fails to link table MS Access can not handle DSN-less connections. Work around is to use DNS connections.



CR:288348
CR Number:   288348
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2002 Fixed
4.2 01 Jul 2002 Fixed
4.2 01 Jul 2002 Fixed
4.2 01 Jul 2002 Fixed
4.5 01 Jul 2002 Fixed
4.2 01 Jul 2002 Fixed
Description
Added a connection property to disable performance-sapping SQLWarning creation. When executing a stored procedure on the server with a Statement.execute() results-processing loop, clients who don't care to read the stored procedure's return status will cause jConnect to construct a SQLWarning. This SQLWarning, with SQLState 010P4, states that an output parameter was received and ignored. In applications that hit this condition a lot, the repeated creation of SQLWarnings can have a slight, but measurable, effect on performance.



The DISABLE_UNPROCESSED_PARAM_WARNINGS connection property can be set to true in order to stop jConnect from creating these SQLWarnings.



CR:288667
CR Number:   288667
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Mar 2003 Fixed
Description
OCC CICS and MVS/IMS does not seem to work for a CTBCONPROP call setting the CS_LOC_PROP.



CR:288672
CR Number:   288672
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 02 Jul 2002 Fixed
12.0 29 Jul 2002 Fixed
Description
CPRE: cpre hangs with various changes to environment variables.
Workaround Description
 Sometimes removing control characters from environmental variables works.



CR:288800
CR Number:   288800
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)
17 Sep 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Ability to set the workarounds of the ODBC driver via the setup dialog box, instead of manually entering this in the registry.



Resolution:

This CR was reviewed Sep 2002 and a decision was made to not implement this request.

Both Sybase and Datadirect have considered this request and feel that if an unwary customer starts to fiddle with the switches, they could potentially create a bigger problem than when they started.

A better option is to edit the registry by creating scripts for example, with the required switches after confirming in development/QA that these switches work.



CR:288910
CR Number:   288910
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   Unknown
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 MFC107 10 Oct 2002 Fixed
Description
Errors were being reported when a deallocation of a non-prepared dynamic event occured.



CR:288912
CR Number:   288912
Product Name:   jConnect
Product Component:   jutils
Status:   Closed
OS:   NA
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2002 Fixed
03 Jul 2002 Fixed
03 Jul 2002 Fixed
Description
jIsql has been updated to be more 'Mac-friendly.' Mac users can specify the -M single command-line option to use jisql with Mac-style menus. Additionally, the output GUI will conform to a Mac look-and-feel.



CR:288940
CR Number:   288940
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Aug 2002 Fixed
Description
CTLIB: Multiple race conditions may cause ct_results()/ct_fetch() to fail in a gateway server when these calls are called at the same time when the attention handler is calling ct_cancel (CS_CANCEL_ATTN).



CR:288947
CR Number:   288947
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
4.2 01 Jul 2002 Fixed
4.5 01 Jul 2002 Fixed
Description
jConnect can no longer send datetime values prior to 1/1/1753 to ASE using the setDate method. ASE and ASA datetime columns have a lower limit of 1/1/1753.



CR:288985
CR Number:   288985
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2002 Fixed
Description
CTLIB: Binding parameter of length 256 and type CS_CHAR_TYPE fails with error: ct_param(): user api layer: external error: A data length
of 256 exceeds the maximum length allowed for CHAR data. This has been fixed. And, the CS_CHAR of length 256 will be treat as XNL CS_CHAR.



CR:289254
CR Number:   289254
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Mar 2003 Fixed
Description
The locale field of the fmt, structures in the OCC examples is incorrect.



CR:289261
CR Number:   289261
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2002 Fixed
26 Jul 2002 Fixed
Description
CTLIB: ct_fetch may return incorrect status if an error is reported by the ASE when cursor rows are being fetched. This can lead to an 803 error being reported by the ASE and the client connection terminated.
Workaround Description
 Ensure CS_CURSOR_ROWS is set to 1.



CR:289263
CR Number:   289263
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2002 Fixed
Description
installjava and extractjava binaries and their assocaited files are being shipped with SDK 12.5 ebf#6.
Workaround Description
 Copy the utilities from an ASE installation.



CR:289299
CR Number:   289299
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2002 Presently Not Targeted For Any Future Release Of This Product
Description
Small memory leak in cs_ctx_alloc() / cs_ctx_drop() loop
Target Version
 12.5
Review Status
 Reviewed March 2003. This bug is fixed and closed in 12.5 EBF #9 and up.
Workaround Description
 Do not call cs_ctx_alloc/cs_ctx_drop in a loop. Use

cs_ctx_global if you need to repeatedly get the context.



CR:289430
CR Number:   289430
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2002 Fixed
4.2 29 Jul 2002 Fixed
4.2 29 Jul 2002 Fixed
4.2 29 Jul 2002 Fixed
4.2 29 Jul 2002 Fixed
4.2 29 Jul 2002 Fixed
Description
jConnect no longer allows column reads when a ResultSet is positioned before the first row or after the last row.



CR:289511
CR Number:   289511
Product Name:   OpenTransport
Product Component:   JMS Driver
Status:   Closed
OS:   Multiple
Original Version:   2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2002 Workaround
Description
The setup for using the JMS ot Driver for clients to a WebSphere app server is harder than for the other app servers. The user may want to use the MQSeries ot driver instead, when using WebSphere.



1. The correct MQ Series classes for the client platform must be installed - ma88. This can be downloaded from ibm for free.

2. Some WebSphere jars must be copied over to the client platform: websphere.jar, utils.jar, ujc.jar, ras.jar, ns.jar, jca.jar, j2ee.jar, iwsorb.jar, ibmorb.jar. All these jar files must be in the JMS_SES_JVM_CLASSPATH property, as well as the JMS ot driver dbt26jmsjni.jar, in your nnsyreg.dat file.

3. You must use a WebSphere VM (and it must be the same version vm as the one the WebSphere app server is using!). In the WebSphere install, you can unselect everything, but the developer tools. This will install the vm for you. You can also copy the vm over from the app server, if it is on the same platform as the client. I'm not sure if you can download from IBM just the vm.



It would be much easier for the customer to use the MQSeries ot driver with WebSphere, but JMS does work.



CR:289539
CR Number:   289539
Product Name:   OpenTransport
Product Component:   JMS Driver
Status:   Closed
OS:   Solaris
Original Version:   2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2002 Fixed
Description
will not core dump. A message property, that is null, will not be listed in the message.
Workaround Description
 If the message property is null, the client replace it with an empty string. On July 8 2002, a JMS test client was sent to Craig to reproduce the propblem.



CR:289754
CR Number:   289754
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)
30 Dec 2002 Fixed
Description
OLEDB: Queries with Outer Joins under {OJ...} SQL Syntax gives SQLSTATE=42000 (Incorrect Syntax near BY) using TDS-based OLEDB driver 2.50 or above.
Workaround Description
 The only workaround found is to use OLEDB provider 2.10 (not TDS-based).



CR:289865
CR Number:   289865
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2003 Fixed
Description
OCC on all platform cannot convert a Nullable Datetime (Datetimn) to a char.



CR:289891
CR Number:   289891
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)
09 Aug 2002 Not a Bug
Description
SYGWXCPH macro with HOSTNAME is not working in z/OS



CR:289963
CR Number:   289963
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2002 Fixed
5.2 29 Jul 2002 Fixed
5.2 29 Jul 2002 Fixed
5.2 29 Jul 2002 Fixed
5.2 29 Jul 2002 Fixed
5.2 29 Jul 2002 Fixed
Description
jConnect is smarter now about closing remembered statements in pooled connections. We no longer create and throw and catch unneeded exceptions.



CR:290075
CR Number:   290075
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2002 Fixed
19 Jul 2002 Fixed
Description
CSLIB: Error message

updated to reflect the correct location for the file objectid.dat:$SYBASE/config.



CR:290094
CR Number:   290094
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2002 Fixed
4.5 06 Sep 2002 Fixed
Description
jConnect is now more memory efficient when client applications close ResultSets. Previously, clients who called ResultSet.close() but left a Statement around for future reuse, would not get the full benefit of garbage collection on the closed ResultSet. jConnect will now internally null out some references to give better memory utilization.



CR:290176
CR Number:   290176
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2002 Fixed
4.2 29 Jul 2002 Fixed
4.2 29 Jul 2002 Fixed
4.2 29 Jul 2002 Fixed
4.5 29 Jul 2002 Fixed
4.2 29 Jul 2002 Fixed
Description
jConnect has improved the efficiency when using settable parameters in Prepared and Callable Statements.



CR:290532
CR Number:   290532
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jul 2003 Fixed
31 Jul 2003 Fixed
31 Jul 2003 Fixed
Description
OpenSwitch core dumps in mempool_alloc on text/image parameters.
Review Status
 Reviewed March 2003. No estimated target release as yet.
Workaround Description
 Set textsize to a lower value so the overflow condition does not occur.

It appears that textsize can be set up to 2147483612 without causing

the overflow.



CR:290858
CR Number:   290858
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2003 Fixed
Description
OCC CTBBIND does not use the Scaler passed in for Packed Decimal conversion



CR:290910
CR Number:   290910
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2002 Fixed
Description
ESQL: programs return SQLCODE of 0 instead of 100 when no rows fetched
Workaround Description
 Use the -V switch to specify a different context version

(example: cobpre -VCS-VERSION-120). If the customer can

use this parameter when they compile their program, it

will enable them to use Open Client 12.5 but it will force the

program to revert t



CR:290922
CR Number:   290922
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Dec 2002 Fixed
4.2 09 Dec 2002 Fixed
4.2 09 Dec 2002 Fixed
4.2 09 Dec 2002 Fixed
4.2 09 Dec 2002 Fixed
4.2 09 Dec 2002 Fixed
4.2 09 Dec 2002 Fixed
Description
Fixed the updateBigDecimal method so that it respects the scale of the BigDecimal parameter.



CR:291178
CR Number:   291178
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)
18 Jun 2003 Fixed
Description
ODBC: Support for Password Encryption, as found in the Client Library based ODBC Drivers.



CR:291530
CR Number:   291530
Product Name:   Open ServerCONNECT for CICS
Product Component:   tcp/ip
Status:   Closed
OS:   MVS
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2003 Fixed
Description
SYGWCACS contains Exec Cics Handle Condition with no corresponding E C Pop. In consequence conditions raisewd in the calling progranm are handled incorrectly by SYGWCACS.



CR:291690
CR Number:   291690
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Sep 2002 Fixed
23 Aug 2002 Fixed
26 Aug 2002 Fixed
26 Aug 2002 Fixed
Description
DBLIB: The error message "Requested data-conversion does not exist." occurs as a result of the fix to CR 273862.



CR:291703
CR Number:   291703
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   SunOS
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2002 Fixed
22 Oct 2002 Fixed
22 Oct 2002 Fixed
Description
ESQL: sybesql.c header incorrectly states Sybase System 11 ESQL/C precompiler.
Target Version
 12.5
Review Status
 Reviewed March 2003. The bug is fixed in 12.5 EBF #10 and up.



CR:291706
CR Number:   291706
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Nov 2002 Fixed
11 Dec 2002 Fixed
20 Feb 2003 Fixed
Description
ISQL: isql 12.5 has a different output format from isql 12.0 backwards, such as it doesn't indent the column when data extends beyond specified width.
Target Version
 12.5
Review Status
 Reviewed March 2003. The bug has been fixed in a 12.5 EBF released after Jan 2003.



CR:291708
CR Number:   291708
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2002 Fixed
26 Aug 2002 Fixed
Description
ISQL: isql does not wrap when column width parameter -w is specified.



CR:291761
CR Number:   291761
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2002 Fixed
14 Aug 2002 Fixed
Description
SMPOS OpenSwitch fails to close and deallocate cursors



CR:291811
CR Number:   291811
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2002 Fixed
Description
BLKLIB: Bulk copy in through gateway server hangs.



CR:291969
CR Number:   291969
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)
24 Oct 2002 Fixed
Description
OLEDB: When in a transaction the rowcount for a SELECT returns as -1.



CR:292025
CR Number:   292025
Product Name:   Open Client/Open Server-Doc
Product Component:   Installation Guide
Status:   Closed
OS:   SunOS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Feb 2004 Fixed
Description
Open Client installation guide has wrong syntax for executing SYBASE.csh
Review Status
 Reviewed Dec 2002. Fix is targeted for the next release of the documentation.



CR:292150
CR Number:   292150
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2002 Fixed
27 Aug 2002 Fixed
29 Aug 2002 Fixed
27 Aug 2002 Fixed
Description
BLKLIB: Bulk copy in of NULL char/varchar column on DOL table core dump when using multi-byte character set.
Workaround Description
 Use APL lock scheme for the table,

or don't run bcp as a client with japanese character set.



CR:292186
CR Number:   292186
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2003 Fixed
5.2 06 May 2003 Fixed
5.2 06 May 2003 Fixed
5.2 06 May 2003 Fixed
5.2 06 May 2003 Fixed
5.2 06 May 2003 Fixed
Description
jConnect can now call ResultSet.updateRow() twice on the same row without moving off of that row between calls.
Target Version
 To Be Determined
Review Status
 Reviewed March 2003. No update from engineering as yet.
Workaround Description
 Perform all updates before calling updateRow(), only calling updateRow() one time before re-positioning the cursor row. Effectively, limit updateRow() to a single occurrence.



CR:292299
CR Number:   292299
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2003 Fixed
25 Aug 2003 Fixed
Description
ESQL: ESQL/C causes 702 error and stack trace in ASE12.5 because of an invalid length definition for parameters sent to ASE.
Target Version
 12.5
Review Status
 Reviewed March 2003. This bug is fixed in 12.5 EBF #10 and up.
Workaround Description
 Add the following line to the Cpre code or to sybhesql.h:

#define _SQL_PCHAR_LEN ((CS_INT) 16384)



This will redefine the macro to ASE 12.5's stated maxium.

When compiling, you will get a macro redefinition warning.



CR:292372
CR Number:   292372
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)
30 Dec 2002 Fixed
Description
ODBC: client connection cannot fail over when ASE HA is on NT



CR:292457
CR Number:   292457
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
Description
Eliminated NullPointerException that occurred with SybMessageHandler implementation.



CR:292459
CR Number:   292459
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 Oct 2002 Fixed
08 Oct 2002 Fixed
Description
CTOS: fails to process parameters from pre 12.5 clients w/ connecting to ASE 12.5.



CR:292517
CR Number:   292517
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2002 Duplicate
Description
BLKLIB: blk_colval doesn't support DOL tables



CR:292550
CR Number:   292550
Product Name:   jConnect
Product Component:   Jisql
Status:   Closed
OS:   NA
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2002 Fixed
2.0 06 Sep 2002 Fixed
Description
When a client issues a 'shutdown' command from jisql, the user can now see the SQLServer message that says that the server is shutting down. Previously, a user would only see a SQLException that indicated the connection had been terminated. With this fix, a user will now see two SQLWarning messages indicating that the shutdown command has executed properly, and that the server is shutting down.



Note that the SQLWarning messages will be displayed in the fashion that the user has select from the options jisql menu. By default, the Warnings are displayed in the message box at the bottom of the jisq connection window.



CR:292580
CR Number:   292580
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2002 Fixed
01 May 2003 Fixed
17 Sep 2002 Not a Bug
Description
ODBC: Previously, updating/inserting large image data in excess of 8 MBs would fail with this message: "-2147467259 : Method 'Update' of object '_Recordset' failed". This no longer happens and the image data is now updated/inserted.



CR:292810
CR Number:   292810
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)
23 Aug 2002 Fixed
Description
ODBC: Using DAO and sending "sp_addlogin" resulted in error 3146.
Workaround Description
 There is no way to really identify the client



CR:292979
CR Number:   292979
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5 11 Apr 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
DB-Lib sample programs example6 and example9 crash OpenSwitch



CR:292980
CR Number:   292980
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
DB-Lib sample programs example6 and example9 crash OpenSwitch



CR:292991
CR Number:   292991
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2002 Fixed
04 Nov 2002 Fixed
Description
ISQL: isql ignores ^Z to put it into the background
Workaround Description
 Use isql from a previous EBF.



CR:293004
CR Number:   293004
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2012 EOL'd version. Not to be Fixed.
Description
CS_BEHAVIOR = CS_BEHAVIOR_120 implemented for isql.

In OC 11.1.1 and 12.0 (prior to OC 12.0 EBF#15, see

CR 291708) when using isql with "-wXX" parameter, data

that was greater than XX did not wrap. This configuration

option reverts the behavior to the old (and incorrect)

behavior exhibited in OC 11.1.1 and OC 12.0 prior to EBF

#15.
Target Version
 To Be Determined
Review Status
 Reviewed March 2003. The feature may be considered for a future release of the product.
Workaround Description
 Use isql from 12.5



CR:293114
CR Number:   293114
Product Name:   jConnect
Product Component:   Jisql
Status:   Closed
OS:   NA
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Sep 2002 Fixed
2.0 06 Sep 2002 Fixed
Description
jisql will now display Polish messages in its GUI when the client uses the '-Z Polish' option at the command line.



CR:293132
CR Number:   293132
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)
24 Oct 2002 Fixed
Description
ODBC: On connecting to an Open Server application the ODBC Driver would cause Catastrophic Failure" in an ADO application. It was discovered the failure occurred on the API call, SQLGetInfo, when retrieving the value for the SQL_DATABASE_NAME attribute. This problem is now resolved, but it is REQUIRED to include the database name in the connection string. This is required when using Open Server applications such as Sybase

OpenSwitch.
Workaround Description
 Use 4.00.0001 or prior - but this impedes anyone applying newer patch for other problems, such as this customer.



CR:293312
CR Number:   293312
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   4.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
4.2 05 Sep 2002 Fixed
Description
jConnect now allows warnings to be retrieved on Connection and Statement objects even when an IOException is hit that kills the Connection.



CR:293404
CR Number:   293404
Product Name:   jConnect
Product Component:   Jisql
Status:   Closed
OS:   NA
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Sep 2002 Fixed
2.0 04 Sep 2002 Fixed
2.0 04 Sep 2002 Fixed
Description
If the default language of the JVM is not supported by jisql, jisql will start up with its default language as English. The languages which jisql supports are English, Chinese, German, Spanish, French, Japanese, Korean, Portuguese, and Polish.



CR:293488
CR Number:   293488
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)
20 Feb 2004 Fixed
Description
Documentation Update: Care is required when using ct_send_data to update text/image columns in a view. The update privileges must be granted on the underlying table itself (and this could be in a different database) and not the view. This is because the current CS_IODESC structure returned by the ASE relates directly to the table and not the view, and it is against this CS_IODESC that the ct_send_data occurs.
Review Status
 Reviewed Dec 2002. Fix is targeted (but not committed) for the next release of the documentation.



CR:293514
CR Number:   293514
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2003 Fixed
20 Mar 2003 Fixed
01 Apr 2003 Fixed
Description
CTLIB: ct_results may hang if ct_cancel(CS_CANCEL_ATTN) is called before any pending result is retrieved.
Workaround Description
 None



CR:293965
CR Number:   293965
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2002 Fixed
5.5 07 Sep 2002 Fixed
Description
jConnect now offers a way to use "lightweight" copies of PreparedStatements and CallableStatements. Such a mechanism can be useful to customers who have PreparedStatement or CallableStatement 'templates' they plan to execute numerous times; to save memory and processing time over the Connection.prepareStatement or Connection.prepareCall methods, the newly provided copy methods can be called. Note that there are some restrictions on how the copies must be created and executed.



For more information, see the javadocs for com.sybase.jdbcx.Connection.



CR:294006
CR Number:   294006
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 Sep 2002 Fixed
4.2 23 Oct 2002 Fixed
4.2 23 Oct 2002 Fixed
4.2 23 Oct 2002 Fixed
4.2 23 Oct 2002 Fixed
4.2 23 Oct 2002 Fixed
Description
jConnect will now throw a SQLException when a client specifies a port number that is out of range for a socket (the valid range is 0 through 65535, inclusive). The new SQLException code is JZ0PN.



CR:294053
CR Number:   294053
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Oct 2002 Fixed
16 Oct 2002 Not a Bug
05 Jun 2003 Not reproducible with latest version of the product available as of Resolution Date
Description
CTLIB: Using wide dynamic/cursors can cause a core dump in the Comnlib
mapping routines.



CR:294114
CR Number:   294114
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Oct 2002 Fixed
4.5 10 Oct 2002 Fixed
4.5 10 Oct 2002 Fixed
4.5 10 Oct 2002 Fixed
4.5 10 Oct 2002 Fixed
4.5 10 Oct 2002 Fixed
Description
Added a connection property to disable jConnect from sending unichar/univarchar character parameter data. The new connection property is DISABLE_UNICHAR_SENDING



Typically, jConnect will send unichar/univarchar parameter data when the following conditions are met:



1. The server is ASE, and the version is 12.5 or higher

2. The server is using utf-8 as its default character set

3. The client has specified a value of 6 for the JCONNECT_VERSION connection property.



Using unichar/univarchar data can sometimes lead to a performance degradation at the server, so if a client wishes to enable widetable functionality (which requires a JCONNECT_VERSION of 6), but wishes to disable unichar, they can set the new property value to true.



Reviewed Dec 2002. This issue is being tracked under ASE CR 228419 and is targeted (but not committed) for the ASE 15.0 release.
Target Version
 To Be Determined
Review Status
 Reviewed March 2003. This CR is targeted (but not committed) for the ASE 15.0 release.
Workaround Description
 None, since the customer needs the extra functionality that comes with 6.



CR:294211
CR Number:   294211
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)
27 Feb 2003 Fixed
Description
OLEDB: Integer output parameter was displayed as 0 after execution of the stored procedure.



CR:294297
CR Number:   294297
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)
24 Oct 2002 Fixed
Description
OLEDB: Oledb Provider would close the network socket after TDS_LOGOUT, without waiting for the TDS_DONE acknowledgement from the ASE.



CR:294349
CR Number:   294349
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2002 Fixed
02 Dec 2002 Fixed
08 Apr 2003 Fixed
07 Apr 2003 Fixed
Description
CSLIB: cs_locale returns success when called with a locale and a context which is different from the context under which the locale is allocated.



CR:294532
CR Number:   294532
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2002 Fixed
02 Dec 2002 Fixed
Description
SRVLIB: pre-12.5 clients may receive a tds protocol, illegal token error.
Workaround Description
 There is no workaround for this issue, other than to use 12.5 ctlib clients.



CR:294605
CR Number:   294605
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2003 Fixed
5.5 14 Feb 2003 Fixed
5.5 14 Feb 2003 Fixed
5.5 14 Feb 2003 Fixed
5.5 14 Feb 2003 Fixed
5.5 14 Feb 2003 Fixed
Description
Added date and time datatype capabilities to jConnect. This will allow jConnect clients to send and retrieve values from date and time columns when ASE begins supporting those datatypes (in ASE version 12.5.1). jConnect customers should set their JCONNECT_VERSION connection property to 6 to turn on date and time datatype capabilities.



CR:294866
CR Number:   294866
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Feb 2004 Fixed
6.0 09 Feb 2004 Fixed
Description
Enhancement request for jConnect to support Kerberos
Target Version
 To Be Determined
Review Status
 Reviewed Nov 2002. This CR is targeted (but not committed) for a future release of the product. No estimated version as yet.



CR:294872
CR Number:   294872
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)
30 Dec 2002 Fixed
Description
OLEDB: Numeric/decimal output parameter value was always 0 when stored procedure had a result set.



CR:295364
CR Number:   295364
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2002 Fixed
30 Oct 2002 Fixed
13 Nov 2002 Fixed
Description
BCP: bcp out performance degrades as a result of the fix to CR273270/CR288048.
Target Version
 12.5
Review Status
 Reviewed March 2003. This bug has been fixed in 12.5 ebfs released after Jan 2003.
Workaround Description
 Use bcp from a previous EBF



CR:295418
CR Number:   295418
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Linux
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2002 Fixed
05 Nov 2002 Fixed
27 Jan 2003 Fixed
25 Aug 2003 Not a Bug
Description
NETLIB: Open server used with reentrant libraries (except Solaris) may hang during shutdown via RPC.



CR:295539
CR Number:   295539
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)
24 Oct 2002 Fixed
Description
ODBC: Default parameters are not supported by the ODBC Driver since ASE does not provide this information in the Catalog Stored Procedures. Instead, if you try to use default parameters you will receive this error message: "Default parameters are not supported by this database."



CR:295709
CR Number:   295709
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)
30 Dec 2002 Fixed
Description
ODBC: Unable to get a message returned from a raiserror that was inside a trigger.
Workaround Description
 Not with TDS based - not sure if customer will use ODBC 12.0.



CR:295783
CR Number:   295783
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)
24 Oct 2002 Fixed
Description
ODBC: Odbc driver would close the network socket after TDS_LOGOUT, without waiting for the TDS_DONE acknowledgement from the ASE.



CR:295816
CR Number:   295816
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   HP-UX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2003 Fixed
07 Nov 2002 Fixed
Description
CM crashes with assertion failure in comasync.c when ct_debug added to cm_init.c
Target Version
 12.0
Review Status
 Reviewed March 2003. This CR is targeted for the OpenSwitch EBF released after April 2003.





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