远程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:344071
CR Number:   344071
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2004 Fixed
2.0 21 Jan 2004 Fixed
2.0 21 Jan 2004 Fixed
2.0 21 Jan 2004 Fixed
2.0 21 Jan 2004 Fixed
2.0 21 Jan 2004 Fixed
Description
The DatabaseMetaData.getColumns method no longer fails when used against a server that has utf-8 as the default character set and a non-binary sort order.



CR:344287
CR Number:   344287
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2004 Fixed
Description
ODBC: Table import in Access 2000/2002/2003 hangs with Select Method=Direct
Workaround Description
 Use Select Method = Cursor



CR:344680
CR Number:   344680
Product Name:   Connectivity Utilities
Product Component:   defncopy
Status:   Open
OS:   NA
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If a server is has a default characterset utf8 and a stored procedure is created using

(french) accented characters, defncopy is adding extra spaces to the text of the

procedure when the client configured with iso_1.
Target Version
 To Be Determined
Review Status
 Reviewed June 2004. Not enough priority to commit this CR to a given release.



CR:344719
CR Number:   344719
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2004 Fixed
07 Apr 2004 Fixed
15 Jun 2004 EOL'd version. Not to be Fixed.
Description
DBLIB: Memory leak of 255 bytes each time client application connects to server using encrypted passwords set by DBSETLENCRYPT(login, TRUE).
Workaround Description
 None.



CR:344783
CR Number:   344783
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect retrieves data with blanks for a "char null" column.
Review Status
 Reviewed June 2004. This CR is currently in review in engineering.
Workaround Description
 Use trim() function on ResultSet.getString() in your Java program.



CR:344941
CR Number:   344941
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2004 Not a Bug
Description
Need stronger RCM analyze functionality. Would like the

analyze functionality check for mismatched configuration

options in the rcm.cfg and the OpenSwitch.cfg files.
Workaround Description
 Make sure each configuration file (OpenSwitch.cfg and rcm.cfg)

match properly.



CR:344968
CR Number:   344968
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Feb 2004 Fixed
Description
SRVLIB: Calling srv_sendinfo with a srvproc that has not logged in complete may cause an access violation.



CR:345019
CR Number:   345019
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: OLEDB 2.70.0024 hangs when using 2 recordsets on a connection and when retrieving text data.



CR:345068
CR Number:   345068
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2005 Fixed
Description
Explanation of setting SSID to the TCP/IP stack name (or TCP/IP job name) is available in the MFC Server Option a.k.a. Open ServerConnect for CICS Installation and Administration Guide only (see URL below)



http://sybooks.sybase.com/onlinebooks/group-or/orp1250e/osconins/@Generic__BookView?DwebQuery=SSID



CR:345190
CR Number:   345190
Product Name:   jConnect
Product Component:   Jisql
Status:   Closed
OS:   NA
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2004 Fixed
2.0 18 Feb 2004 Fixed
2.0 18 Feb 2004 Fixed
2.0 18 Feb 2004 Fixed
2.0 18 Feb 2004 Fixed
2.0 18 Feb 2004 Fixed
Description
Added a JFileChooser to jisql, to allow for greater customization of how the file list is sorted.
Target Version
 2.0
Review Status
 Reviewed Mar 2004. The issue has been fixed in the 2.0 release.



CR:345277
CR Number:   345277
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2004 Fixed
Description
ADO.NET: The memory allocated for AseCommand objects is not freed until the underlying connection is closed.



CR:345443
CR Number:   345443
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to increase length of bounded arrays in tds loginrec for lhostname, lusername, lpw, lappname and lservname.



CR:345689
CR Number:   345689
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   HP-UX
Original Version:   11.1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2007 Fixed
Description
BCP: bcp prints out warning message when loading data into the table with identity

column without -E option specified.
Review Status
 Reviewed June 2004. CR may be considered post 15.0 or a 15.0 ESD in 2005 or later.



CR:345719
CR Number:   345719
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2005 Fixed
Description
jConnect: A jConnect application calling PreparedStatement.setCharacterStream() to set a string parameter containing a few characters from languages other than English eg. german,

swedish etc. receives a com.sybase.jdbc2.tds.TdsDataOutputStream exception when the

length is around 255 characters.
Target Version
 To Be Determined
Review Status
 Reviewed June 2004. CR is still under review by engineering.



CR:345869
CR Number:   345869
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2004 Fixed
Description
ODBC: Raiserror was always returning as SQL_SUCCESS_WITH_INFO in stored procedure call. To provide flexibility a new connection property has been added: SybaseWorkArounds. The following details provide the information on the option:



Connection String name for SybaseWorkArounds

Long Name: SybaseWorkArounds

Short Name: SWA



Possible Values of SybaseWorkArounds for RaiseError:

0 RaiseError as Warning, the default

1 RaiseError as Error



CR:345978
CR Number:   345978
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2004 Fixed
11 Mar 2004 Fixed
21 Apr 2004 Fixed
03 Aug 2004 Fixed
12 Aug 2004 Fixed
06 Oct 2004 Fixed
27 Feb 2005 Fixed
Description
CPRE: An ESQL/C application continuously creating new threads to connect and disconnect to ASE may show an increase in using memory. 'EXEC SQL THREAD_EXIT' can be used before the end of a thread to help to reduce the memory consumption.
Target Version
 12.5.1
Review Status
 Reviewed June 2004. The fix is targeted for (but not committed to) 12.5.1 ESD #5 or ESD #6 scheduled for release in Q3 2004.



CR:346111
CR Number:   346111
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2004 Fixed
Description
A new option called CMON_WAITFOR_DELAY has been introduced. The value for this should be entered in number of seconds. The default is 3600 (1 hour). This can be configured in the OpenSwitch.cfg file. The purpose for this flag is to enable the user to configure the delay period for the waitfor delay command that the cmon connection issues. This will enable a user to set the value much lower than the default so that when the user wishes to shutdown the ASE gracefully it will occur in a timely manner. It is highly recommended that the cmon username not be an administrator.
Workaround Description
 kill the SPID used by CMON (identification of this SPID is easier when a

designated login is used for CMON).



CR:346120
CR Number:   346120
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2004 Fixed
Description
ODBC: Cannot insert rows in Recordset if square brackets contain the table name in SELECT statement.
Target Version
 12.5.1
Review Status
 Reviewed June 2004. Case is actively being worked upon by Sybase, DataDirect & Microsoft.



CR:346122
CR Number:   346122
Product Name:   Connectivity Utilities
Product Component:   defncopy
Status:   Closed
OS:   AIX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2006 Fixed
21 Jun 2004 Presently Not Targeted For Any Future Release Of This Product
25 Apr 2006 Fixed
Description
DEFNCOPY: Defncopy should initialize the connection properties of host name and program name.
Workaround Description
 Customer really doesn't have a good workaround -- they will have to do something really

kloogey and constraining to get around this like make a special login to run defncopy from.



CR:346156
CR Number:   346156
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Fixed
Description
ADO.NET: The ASE ADO.NET Data Provider returns the count of cumulative rows affected by a query rather than only the number of rows directly affected by the query. For example if one row insert triggers another row to be updated, a count of 2 is returned.
Workaround Description
 Use "sp_configure 'send doneinproc tokens',0" to change the default on the ASE Server.



CR:346307
CR Number:   346307
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2004 Fixed
Description
CTLIB:ct_param sets maxlength greater than 255 even when version is less than CS_VERSION_125
Workaround Description
 Customer must recode all of their applications

to use a maxlength=255.



CR:346310
CR Number:   346310
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2004 Fixed
Description
ODBC: When executing a stored procedure with or without "EXEC" keyword, and application is using a query timeout (such as CommandTimeout in ADO application, or using QueryTimeout in ODBC API SQLSetStmtAttr call), when the timeout occurs, SQLExecDirect() returns SQL_SUCCESS. The message and SQL_ERROR return code was retrieved during SQLFetch(). This has been corrected so that the execute returns SQL_ERROR on the SQLExecDirect() API call.



CR:346439
CR Number:   346439
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)
25 Feb 2004 Fixed
Description
SRVLIB: Non-MacOSX 'isql' fails to connect to MacOSX Open Server applications.



CR:346598
CR Number:   346598
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 reproducible with latest version of the product available as of Resolution Date
Description
When ASE shuts down, OpenSwitch reports it is unable to lock opt_mtx



CR:346765
CR Number:   346765
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2004 Fixed
Description
ODBC: The ASE ODBC Driver 12.5.1 on Linux does not implement all Scalar functions as described in the ODBC specification. Request to implement NOW(), DATABASE(), USER_NAME & IFNULL() functions.
Workaround Description
 Call equivalent ASE functions instead.



CR:346906
CR Number:   346906
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2005 Fixed
03 Nov 2005 Fixed
01 Nov 2005 Fixed
01 Nov 2005 Fixed
08 Dec 2005 Fixed
Description
BLKLIB/DEFNCOPY: Square brackets in object names are supported now.
Target Version
 12.5.1
Review Status
 Reviewed June 2004. This CR is targeted for (but not committed) to 12.5.1 ESD #7 or ESD #8 scheduled for release in Q1 2005.
Workaround Description
 Don't put square brackets around the table name.



CR:346933
CR Number:   346933
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
005 21 Oct 2004 Workaround
Description
Incorrect error handling occurs for ISQL/CICS. See General Information and Technical Notes, item 3.



CR:347175
CR Number:   347175
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 MAP126_001 19 Jan 2005 Fixed
Description
The CICS RDO/PPT definitions of Sybase CICS Load Module SYBOPEN, common to both Mainframe Connect (MFC) Client Option (a.k.a. OCC) and Server Option (a.k.a. OSC), and SYCLOS, for OSC only, should have the EXECKEY parameter setting values of "CICS" not "USERS" as indicated in the OSC's Install & Admin Guide



Pls note that the RDO/PPT definitions supplied in the Installation JCL are corrected as of 12.50.01 (see CR 274424)



CR:347201
CR Number:   347201
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2004 Fixed
Description
ODBC: ODBC does not receive all Extended Error Data messages from PRINT statements in a stored procedure.
Workaround Description
 Use ODBC 4.10.0040.



CR:347227
CR Number:   347227
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Fixed
Description
OpenSwitch reports opt_mtx errors when CMON=0 and clients use TDS 4.6
Workaround Description
 There are two workarounds:

1) Set CMON=1 and make sure that CMON_USER/CMON_PASSWORD

are valid for your ASEs.

2) Force your DB-Library applications to use TDS 5.0 by

setting dbsetversion(DBVERSION_100).



CR:347471
CR Number:   347471
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.0 01 Sep 2004 Fixed
Description
The Sybase ASE ODBC Driver currently does not fully support the SQLBrowseConnect function call. The SQLBrowseConnect function is expected to prompt user for any missing connection information. The Sybase ASE ODBC Driver will return an error if required connection information is missing.
Workaround Description
 Provide the required connection information in the call to SQLBrowseConnect.



CR:347535
CR Number:   347535
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: MaxRecords not working with SelectMethod=Direct



CR:347603
CR Number:   347603
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)
07 Apr 2004 Fixed
Description
OLEDB: Releasing an OLEDB session does not close the connection to ASE.
Workaround Description
 None known.



CR:347640
CR Number:   347640
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)
04 Mar 2004 Fixed
08 Mar 2004 Fixed
Description
CTLIB: ct_poll is supposed to return CS_QUIET only if timeout is 0 and the passed-in context (or connection) has no pending I/O. If I/O is pending,then CS_TIMED_OUT should be returned.



CR:347683
CR Number:   347683
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Mar 2004 Fixed
Description
NETLIB: On some unix platforms such as AIX, SSL handshake may fail for certificate which has a null extension field.
Workaround Description
 use single level certreq/cerauth certificates



CR:347799
CR Number:   347799
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)
01 Apr 2004 Fixed
Description
OLEDB: Unable to get a message returned from a raiserror. Instead a generic message is raised "An unknown error has occurred".



CR:347990
CR Number:   347990
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2004 Fixed
Description
ADO.NET: The ASE ADO.NET Data Provider does not support setting the TextSize Connection property.



CR:347992
CR Number:   347992
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Fixed
Description
ADO.NET: Request to be able to send Client Hostname and Client Application Name etc in the ASE login record to track client processes in ASE.



CR:348141
CR Number:   348141
Product Name:   Open Server/Mainframe-Doc
Product Component:   Installation Guide
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
These params are require if customers want to override the Charset:

CCSID=850,CHARTYPE=A,CHARSIZE=1,PAD=20,

Full example listed below:



SYGWMCXL TYPE=INITIAL

SYGWMCXL TYPE=ENTRY,CHARSET=cp850,CHARSETBYTES=S, *

CCSID=850,CHARTYPE=A,CHARSIZE=1,PAD=20, *

A2E=(21=5A,5B=BA,5D=BB,5E=B0,7C=4F,AA=5F,BD=4A), *

E2A=(5A=21,BA=5B,BB=5D,B0=5E,4F=7C,5F=AA,4A=BD)



CR:348224
CR Number:   348224
Product Name:   Open ServerCONNECT for IMS and MVS
Product Component:   Open ServerCONNECT for IMS and MVS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2004 Not a Bug
Description
OSC and OCC 12.5.x IMS transactions abend with system 0C4 as a result of SYGWIMSS or SYGWIMSC attempting to call one of the following programs (to send or receive) after the required module, which was loaded at the transaction startup, gets deleted before the end of the IMS transactions.



The following modules are new in OSC and OCC 12.5 for IMS/MVS and must be preloaded under MVS before the IMS region is started:

+ LU62IMS, CPICIMS and TCPIMS
Workaround Description
 The following modules are new in OSC and OCC 12.5 for IMS/MVS and must be preloaded under MVS before the IMS region is started:

+ LU62IMS, CPICIMS and TCPIMS



CR:348329
CR Number:   348329
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Red Hat Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2005 Fixed
02 Mar 2005 Fixed
Description
EXAMPLES: Replace gets() function call with fgets() for ESQL/C and DBLIB samples.



CR:348349
CR Number:   348349
Product Name:   Open Server/Mainframe-Doc
Product Component:   Installation Guide
Status:   Open
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SYBCLOS was Modified, in OSC 4.0 EBFI0186 to be able to run ing the CICS (shutdown) PLTSD.

This now needs to be documented in the newer install Guides there is no mention in the 12.5 guides.



CR:348398
CR Number:   348398
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jul 2005 Not a Bug
Description
You cannot bind parameters and columns to variables of type SQL_C_WCHAR. No error is reported in such cases however the outcome is undefined.
Workaround Description
 Use SQL_C_CHAR as a bind type even for ASE datatype unichar and univarchar.



CR:348465
CR Number:   348465
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2004 Fixed
18 Apr 2004 Presently Not Targeted For Any Future Release Of This Product
Description
CPRE: cpre fails to parse recursively defined structures.
Target Version
 12.5.1
Review Status
 Reviewed June 2004. CR fixed and closed in 12.5.1 ESD #3.



CR:348550
CR Number:   348550
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)
11 Mar 2004 Fixed
09 Mar 2004 Fixed
Description
CTLIB: Using data confidentiality with wide columns can result in a TDS protocol error with ASE.



CR:348625
CR Number:   348625
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)
15 Aug 2004 Fixed
01 Nov 2004 Fixed
19 Aug 2004 Fixed
22 Aug 2004 Fixed
Description
ISQL:isql -o option does not support writing to 2GB files.
Target Version
 12.5.1
Review Status
 Reviewed June 2004. Fix is targeted (but not committed) for ESD #5 or ESD #6 for 12.5.1, scheduled for release Q3-Q4 '04.
Workaround Description
 Customer is redirecting their output to a file

with the ">" operator.



CR:348669
CR Number:   348669
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2004 Fixed
21 Mar 2005 Fixed
Description
EXAMPLE: In CTOS sample, cursor 'options' should be checked and set correctly to CS_DEALLOC or CS_UNUSED for ctos_curclose(), and either to CS_RESTORE_OPEN or CS_UNUSED for ctos_curopen().

They cannot be passed as zero, otherwise ct_cursor() call will fail.



CR:348684
CR Number:   348684
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)
03 Jun 2004 Fixed
Description
OLEDB: ASE char datatype that is nullable was not being padded when selected from the ASE.



CR:348688
CR Number:   348688
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2004 Fixed
19 Mar 2004 Fixed
Description
An encryption feature has been introduced to OpenSwitch and the CM to allow for password encryption of the username/passwords that reside in the OpenSwitch config file.



CR:348788
CR Number:   348788
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2004 Fixed
Description
ADO.NET: Attempt to insert large image data using variable of type VarBinary will result in error.
Workaround Description
 Use variable of type Image when data to be inserted is larger than the ASE Page size.



CR:349079
CR Number:   349079
Product Name:   jConnect
Product Component:   Jisql
Status:   Closed
OS:   Unknown
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Nov 2004 Fixed
29 Nov 2004 Fixed
Description
jisql: Jisql will not process all results after an exception is thrown. Jisql behavior processing results should not differ greatly from isql results processing. try/catch placement in results processing should allow multiple resultsets to be returned even when there are errors in one or more of the resultsets.
Review Status
 Reviewed June 2004. CR is still under review by engineering.
Workaround Description
 none



CR:349140
CR Number:   349140
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
bcp in of system tables fails with message 2812 (sp_serverinfo not found), when manually rebuilding ASE with buildmaster & bcp
Target Version
 To Be Determined
Review Status
 Reviewed June 2004. Not enough priority to commit this CR to an upcoming release as yet.
Workaround Description
 Defncopy sp_serverinfo from a working ASE and defncopy it into master.



CR:349385
CR Number:   349385
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)
03 Jun 2004 Fixed
Description
ODBC: When retrieving varbinary fields through an Open Server application, the ODBC driver was padding the fields to the max length of the defined varbinary field with 0x00. For example, if the driver was connecting to ASE through OpenSwitch, and the field was a varbinary(4), with the data 0x34 contained in the field, the ODBC driver would deliver 0x34000000 to the application instead of 0x34.



CR:349692
CR Number:   349692
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2004 Deferred
16 Nov 2004 Fixed
13 Jun 2006 Fixed
26 Jun 2006 Fixed
Description
BLKLIB: Dynamic version of bulk library is available.



CR:349897
CR Number:   349897
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
001 13 May 2004 Fixed
Description
Open ServerConnect 12.50.04 context handler issues GETMAIN for 32K+ CICS User Dynamic Storage from below the 16MB line.
Workaround Description
 N/A (avoid applying EBF 11591 until fix becomes available)



CR:349948
CR Number:   349948
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2004 Not a Bug
Description
RCM malfunctions after primary OpenSwitch fails are restarts.

Both the primary and redundant RCMs respond to the same login

request after they reestablish connectivity to primary OpenSwitch.



CR:349973
CR Number:   349973
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Mar 2004 Fixed
Description
ADO.NET: Using the "TextSize" Connection parameter may cause only partial contents of Text/Image database columns to be retrieved to the Client.
Workaround Description
 Do not use the TextSize connection parameter.



CR:350092
CR Number:   350092
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Sep 2005 Fixed
Description
jConnect: Request to support Savepoint feature as described in the JDBC 3.0 specifications.
Review Status
 Reviewed June 2004. CR is still under review by engineering.



CR:350094
CR Number:   350094
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
JDBC 3.0 provides Retrieval of parameter metadata support for stored procedures to JDBC. This feature request is a request to add this support to the Sybase jConnect driver.
Review Status
 Reviewed June 2004. CR is still under review by engineering.



CR:350095
CR Number:   350095
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2005 Fixed
Description
JDBC 3.0 provides for an implementation of named parameter support for Callable statements. This feature request is a request to add this support into the Sybase jConnect driver.
Review Status
 Reviewed June 2004. CR is still under review by engineering.



CR:350104
CR Number:   350104
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)
03 Jun 2004 Fixed
Description
OLEDB: {FN CONVERT(SQL_CHAR, columnName)} fails with syntax error.



CR:350358
CR Number:   350358
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 Oct 2004 Presently Not Targeted For Any Future Release Of This Product
Description
jConnect prevents developers from recieving ASE messages 5701, 5703, 5704 and 7326
Review Status
 Reviewed June 2004. CR is still under review by engineering.
Workaround Description
 There is no workaround. You cannot ever see these errors.



CR:350487
CR Number:   350487
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2004 Fixed
12 May 2004 Fixed
Description
ISQL: isql returns nothing when LANG=ja(jpn) for select current_time/select convert(time,getdate()) queries
Target Version
 12.5.1
Review Status
 Reviewed June 2004. Fixed in 12.5.1 ESD #3.



CR:350614
CR Number:   350614
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2004 Fixed
Description
Calls to SQLGetData will continue to return SQL_SUCCESS indefinetely instead of SQL_NO_DATA after an intial SQL_SUCCESS when the underlying bound column contains NULL data.
Workaround Description
 Check for SQL_NULL_DATA in the StrLen_or_IndPtr parameter in addition to the return value of the SQLGetData.



CR:350685
CR Number:   350685
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2004 Fixed
01 Jul 2004 Fixed
Description
SRVLIB: srv_rpcname() cannot be called from a service thread.
Target Version
 12.5.1
Review Status
 Reviewed June 2004. CR is targeted (but not committed to) 12.5.1 ESD #4.



CR:350716
CR Number:   350716
Product Name:   ADO.NET Data Provider
Product Component:   Install
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The "trusted roots" file (%SYBASE%/ini/trusted.txt) is not installed if you choose to install only the Sybase ASE ADO.NET Data Provider and do not install the Connectivity libraries.
Workaround Description
 Install the "Open Client" Connectivity Library component or manually create the trusted roots file.



CR:350717
CR Number:   350717
Product Name:   Organic ODBC Driver
Product Component:   Install
Status:   Open
OS:   Red Hat Enterprise Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The "trusted roots" file ($SYBASE/config/trusted.txt) is not installed if you choose to install only the Sybase ASE ODBC Driver and do not install the Connectivity libraries.
Workaround Description
 Install the "Open Client" Connectivity Library component or manually create the trusted roots file.



CR:350832
CR Number:   350832
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2004 Fixed
07 Apr 2004 Fixed
Description
SRVLIB: Open Server failed to handle new CS_DATE and CS_TIME datatype due to capability bits of CS_DATA_NODATE and CS_DATA_NOTIME turned off.



CR:350956
CR Number:   350956
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 22 Jun 2005 Fixed
05 Jul 2005 Fixed
Description
OpenSwitch reports 1205 message when SHOW_SPID=0 and CMON=0



CR:351006
CR Number:   351006
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.05 002 07 May 2004 Fixed
Description
Customer needs a way to simulate a gateway security check in a gatewayless environment. See General Information and Technical Notes, item 2, for a resolution to this issue.



CR:351191
CR Number:   351191
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2004 Fixed
Galaxy 05 May 2004 Fixed
Description
EXAMPLES: ctos sample program bulk.c has no provisions for dealing with slice info when parsing the "insert bulk db..table:slice_num" string.



CR:351218
CR Number:   351218
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
001 13 May 2004 Fixed
Description
A HOSTNAME parameter with a length of 24 bytes causes a compile error.



CR:351219
CR Number:   351219
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)
03 Jun 2004 Fixed
Description
OLE-DB: OLE-DB driver 2.70.0032 hangs in MultipleResults->GetResult when it should return DB_S_NORESULT to indicate that no more pending results exist.
Workaround Description
 Use driver 2.70.0029 or earlier.



CR:351227
CR Number:   351227
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2004 Fixed
12 May 2004 Fixed
Description
NETLIB: Open Server should set file descriptor limit to the maximum (hard) limit.
Workaround Description
 Increase your soft limit to equal the hard limit

with the "ulimit" or "limit" commands prior to

starting the process.



CR:351265
CR Number:   351265
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The driver does not support SQLAllocHandle for handle type SQL_HANDLE_DESC.
Workaround Description
 Use implicit descriptors by calling SQLGetStmtAttr for SQL_ATTR_IMP_PARAM_DESC, SQL_ATTR_IMP_ROW_DESC, SQL_ATTR_APP_PARAM_DESC, SQL_ATTR_APP_ROW_DESC.



CR:351270
CR Number:   351270
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.05 001 07 May 2004 Fixed
Description
PLI INCLUDE module SYGWPLI causes PLI programs not to compile cleanly.



CR:351488
CR Number:   351488
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.05 003 07 May 2004 Fixed
Description
ISQL/CICS abends with 0C4 at offset 944A for OCC CICS 12.5 and at offset 9AAE for OCC 12.50.04.



CR:351541
CR Number:   351541
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2004 Fixed
Description
ASE.NET: Customer requests idle connection timeout with connection pooling



CR:351549
CR Number:   351549
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Sep 2004 Fixed
Description
jConnect: Cloning a PreparedStatement using SybConnection.copyPreparedStatement() also copies the MaxRows property from the previous PreparedStatement executed on the connection.
Workaround Description
 Call setMaxRows() everytime you clone a statement to reset the MaxRows property



CR:351558
CR Number:   351558
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2004 Fixed
22 Jul 2004 Fixed
30 Jun 2004 Fixed
20 Jul 2004 Fixed
Description
DBLIB: New Feature of run-time configuration of dblib version level.



CR:351661
CR Number:   351661
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2004 Fixed
20 Apr 2004 Fixed
16 Apr 2004 Fixed
07 May 2004 Fixed
Description
EXAMPLE: new CTLIB sample program id_update.c that demonstrates the use of 'identity_update' option.



CR:351776
CR Number:   351776
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Apr 2004 Fixed
Description
The OSwitch internal default for CONNECTIONS has been changed from 100 to 1000.



CR:351831
CR Number:   351831
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.05 003 11 May 2004 Fixed
Description
The Open ServerConnect CICS context handler allocates 4K memory blocks for use with parameters but frees them only at client logoff. This is a problem for long-running transactions.



CR:351900
CR Number:   351900
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Red Hat Enterprise Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2005 Fixed
Description
The ASE ODBC Driver does not support the LDAP functionality as documented in the User's Guide. If you specify an LDAP URL for the connection information, an error will be returned.



CR:352033
CR Number:   352033
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2004 Fixed
29 Jun 2004 Fixed
Description
EXAMPLES: 12.5.1 Open Server returns date and time datatypes to pre-12.5.1 clients
Workaround Description
 Use a 12.5.1 client.



CR:352080
CR Number:   352080
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Tested and reproduced with isql 12.5.1.

Customer would like the ability to format the footer divisions and spaces between values for the compute clause in isql.



CR:352097
CR Number:   352097
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   HP-UX
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 May 2004 Duplicate
Description
Openclient/openserver initialization of poll control structure will fail in netp_init_poll() if the number of max. file descriptors is odd. The affects 12.0 and 12.5 OCS programs.
Workaround Description
 Have the customer configure an even number of max file descriptors via ulimit command. ulimit -a should show even number of file descriptors. e.g. 1023 will fail but 1024 will work.



CR:352134
CR Number:   352134
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
329 03 Jun 2004 Fixed
Description
ADO.NET: The precision and scale for a Decimal AseParamater object is recalculated based on the values assigned to the parameter. If you set a value of higher scale than specified in the AseParameter, it retains the higher scale. This could subsequently cause data overflow exception for values within the original precision and scale.



CR:352273
CR Number:   352273
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)
18 Aug 2004 Fixed
Description
OLEDB: Raiserror messages in update triggers are not seen in ADO applications.
Workaround Description
 Use ODBC instead.



CR:352340
CR Number:   352340
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)
18 Aug 2004 Fixed
Description
ODBC: If the sql.ini file is flagged as read-only on a windows share, a Windows98 ODBC client is unable to access the file when attempting to connect to ASE.
Workaround Description
 You will need to set rights as Full Control or store the SQL.INI on the system locally.



CR:352438
CR Number:   352438
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide jConnect class tracing in the debug jar via System Property. So e.g. "java -D"sybDebug=SybDataSource:SybConnection" would activate the same tracing that is currently provided via SybDriver.getDebug() Debug object.



Eliminate the need to activate the tracing programmatically in the jconn2d.jar



CR:352441
CR Number:   352441
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Provide a non-programmatic method for trace activation in line with current Java and JDBC standards and practices. This would only be relevant for jConnect 6,0+ and JVM 1.4 and up. Utilize %JAVA_HOME%\jre\lib\logging.properties file for settings.



CR:352536
CR Number:   352536
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2004 Duplicate
Description
jConnect: Incorrect Database meta-data information (such as MAXBATCHPARAMS) returned for ASE 12.0.
Workaround Description
 None.



CR:352685
CR Number:   352685
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Apr 2004 Fixed
Description
If a user issues the "rp_cfg" command while there are a large number

of concurrent connections, OpenSwitch will report error:

OpenSwitch error cfg_read: Unable to open 'OpenSwitch.cfg': Too many open files



CR:352699
CR Number:   352699
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2005 Fixed
04 Aug 2005 Fixed
11 Aug 2005 Fixed
Description
BCP/ISQL: Added new option for both isql and bcp; -x trusted.txt_file: specifiy the alternative name and location of the trusted.txt for SSL.



CR:352819
CR Number:   352819
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2004 Fixed
Description
ADO.NET: The ADO.NET Data Provider corrupts the stream of data it sends to ASE when the blob data exactly matches the buffer size. When this occurs you will receive "Internal error 30002".
Workaround Description
 Using Parameter placeholders instead of Named parameters in the call may help prevent this error.



CR:352868
CR Number:   352868
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.05 002 11 May 2004 Fixed
Description
Extra data is being passed to the client in a column due to an incorrect length field on a row token.



CR:352877
CR Number:   352877
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.05 005 24 May 2004 Fixed
Description
More information is needed on the functionality provided for fix 300389. See General Information and Technical Notes, SYGWHOST TCP address space name enhancement.



CR:352911
CR Number:   352911
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.50.05 005 24 May 2004 Fixed
Description
This is an enhancement introducing a new CICS abend handling module that may be used by any Open ServerConnect for CICS application. See General Information and Technical Notes, item 4.



CR:352954
CR Number:   352954
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)
18 Aug 2004 Fixed
Description
OLEDB: Empty result set in batch command from ASE not populating ADO Recordset when NOCOUNT is set.





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