远程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:745337
CR Number:   745337
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 24 Sep 2013 Fixed
Description
ODBC Driver by Sybase: SQLNumParams returns incorrect number of parameters causing SQLDescribeParam call to crash.
Workaround Description
 WorkAround:

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

Customer has to use OEM driver.



CR:745339
CR Number:   745339
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 22 Nov 2013 Fixed
Description
ODBC Driver by Sybase: With quoted identifiers enabled, Dynamic SQL execution fails with "Dynamic SQL error - Prepared statement '0' does not exist." for sole older ASE releases.
Workaround Description
 WorkAround:

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

Turn off quoted identifiers



CR:745412
CR Number:   745412
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 23 Sep 2013 Fixed
Description
ODBC Driver by Sybase: The username and password fields in the user specified connection strings are visible in the OutConnectionString of SQLDriverConnect.
Workaround Description
 WorkAround:

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

Can't get around this without causing other problems.



CR:745443
CR Number:   745443
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 08 Nov 2013 Fixed
15.7 SP120 14 Jul 2014 Fixed
Description
ADO.NET: Multi-byte data retrieved from text columns contains trailing blanks when ASE is configured with charsets such as utf8.



CR:745541
CR Number:   745541
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2014 Fixed
Description
jConnect: PreparedStatement ParameterMetaData processing is substantially slower than previous releases.
Workaround Description
 No workaround has been found that provides the same performance as the old driver.



CR:745916
CR Number:   745916
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   NA
Original Version:   15.7 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Odbc driver fail to convert some of the cp1251 character correctly.



CR:745973
CR Number:   745973
Product Name:   Open Client
Product Component:   cslib
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2013 Fixed
Description
CSLIB: In Japanese environment, after applying ESD#7 or later, cs_convert() may fail to convert from CS_CHAR to CS_DATETIME with an error "The conversion/operation was stopped due to a syntax error in the source field."



CR:746274
CR Number:   746274
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 30 Sep 2013 Consult Complete
Description
ADO.NET: Exception occurs in a multi-threaded application using Microsoft.Practices.Enterprise Library with Sybase ADO.NET provider.



CR:746483
CR Number:   746483
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.7 SP200
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2013 Fixed
04 Dec 2013 Fixed
09 Dec 2013 Fixed
29 Jan 2014 Fixed
20 Jun 2014 Fixed
Description
SSL FILTER: Provide ability to set FIPs mode for OpenSSL.



CR:746558
CR Number:   746558
Product Name:   Open Client
Product Component:   blklib
Status:   Open
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
blk_describe() to set 憇tatus field in datafmt for BCP IN.



CR:746772
CR Number:   746772
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 25 Sep 2013 Fixed
Description
ADO.NET: Microsoft IIS applications using ADO.NET provider fails with Type Initializer exception when more than one IIS application pool is configured on the same IIS server.
Workaround Description
 WorkAround:

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

It is possible to apply Full Control in the Windows\TEMP\Sybase.AdoNet4.AseClient.... fodler and all apps can access these DLLs.

In this particular case customer is unwilling to do so.



CR:747255
CR Number:   747255
Product Name:   ESQL
Product Component:   Cobol
Status:   Closed
OS:   AIX
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2014 Fixed
01 May 2014 Fixed
Description
ESQL Cobol: Output parameter value (int) not populating parameter buffer.
Workaround Description
 WorkAround:

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

Edit the sybhesql64.cbl file, search for SQL--DFMTDFMT-NAME.:



01 SQL--DFMTDFMT-NAME.

05 SQL--NM PIC X(256).

05 SQL--NMLEN PIC S9(9) comp value is 0.

05 SQL--DATATYPE PIC S9(9) comp value is 100.

05 SQL--FORMAT PIC S9(9) comp value is 1.

05 SQL--MAXLENGTH PIC S9(9) comp value is 0.

05 SQL--SCALE PIC S9(9) comp value is 0.

05 SQL--PRECISION PIC S9(9) comp value is 18.

05 SQL--STTUS PIC S9(9) comp value is 0.

05 SQL--COUNT PIC S9(9) comp value is 1.

05 SQL--USERTYPE PIC S9(9) comp value is 0.

05 SQL--LOCALE PIC S9(18) comp value is 0.



When the SQL--NM attribute dimension is 256 this problem occurs. Change it to 255 and the app will start to work, after rebuild:



Check ret1 values:



1> select * from ret1

2> go

c1 c2 c3

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

BLEI 24 1





outparm





STARTING ZB995

CONNECT+000000000000000000

USE +000000000000000000





INITIAL VALUE OF BLEI_CK = +000000009

NEW c2 FROM FACETS = +000000025





1> select * from ret1

2> go

c1 c2 c3

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

BLEI 25 1



CR:747436
CR Number:   747436
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 07 Oct 2013 Consult Complete
Description
ODBC Driver by Sybase: Performance regression observed when calling SQLExecute that executes successfully followed by a SQLCancel in a loop.



CR:747529
CR Number:   747529
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2013 Fixed
31 Oct 2013 Fixed
Description
ISQL/BCP: Output files created with restrictive permissions.
Workaround Description
 WorkAround:

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

Customer can manually apply rights but have lots of processes and this is causing major hardship



CR:747557
CR Number:   747557
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Aug 2014 Already Fixed by Another CR
Description
Performance Jconnect 7 is six times slower than Jconnect 6.05



CR:748004
CR Number:   748004
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP200 03 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Microsoft Access applications receiving error #3407 "The server's MSysConf table exists, but is in an incorrect format. Contact your system administrator" when failing to create a new linked table, if "IgnoreErrorsIfRSPending" connection property is set.
Workaround Description
 1. Set UseCursor to 1.



Or



2. Set IgnoreErrorsIfRSPending to 0 if possible.



Or



3. Create MSysConf table.



create table MSysConf (

Config smallint not null,

chValue varchar(255) null,

nValue int null,

Comment varchar(255) null

)

go



insert into MSysConf values (101, NULL, 0, NULL)

go



grant all on MSysConf to public

go



CR:748011
CR Number:   748011
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Product: ADO.NET Provider 15.7 SP110 (both 32 and 64-bits)



New Feature request:

Customer would like a new Feature Request to implement the Session State Providers interface on our ADO.NET driver.



Details about the MS interface:



http://msdn.microsoft.com/en-us/library/aa478952.aspx



CR:748241
CR Number:   748241
Product Name:   Other - Docs: Connectivity
Product Component:   SDK
Status:   Closed
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2014 Fixed
Description
The "select @@identity" works differently with DYNAMIC_PREPARE true or false this need to be documented in the JConnect documentation.



CR:748462
CR Number:   748462
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP200 02 May 2014 Diagnostic Provided
16.0 sp01 02 May 2014 Fixed
16.0 14 Feb 2014 Bundled Request
Description
ADO.NET: IIS web application under load periodically receives unable to establish connection errors during application pool recycling.
Workaround Description
 WorkAround:

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

Not sure if there is one. Customer can use 15.5 Provider but runs into issues with exceptions when app pool is recycled (CR 733490) or other possible problems (CR 744973 CloseWait)



CR:748904
CR Number:   748904
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP200 27 Dec 2013 Fixed
Description
SQLCancel should not send a cancel if there is nothing on the statement handle to cancel.



CR:749006
CR Number:   749006
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP200 20 Jan 2014 Fixed
16.0 06 May 2014 Already Fixed by Another CR
Description
ADO.NET: AccessViolationException periodically encountered in AseConnection.Close on a multi-threaded IIS application after connection to ASE times out.
Workaround Description
 WorkAround:

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

This doesn't occur using 15.5 ESD#8+ version of the Provider, but this version has other issues related to problems related to spids behaving in

unexpected ways on ASE.



CR:749174
CR Number:   749174
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 May 2014 Fixed
22 May 2014 Fixed
26 May 2014 Fixed
27 May 2014 Fixed
Description
jConnect: With HOMOGENEOUS_BATCH enabled, incorrect decimal values may be inserted if the first batch element is set to a NULL value.
Workaround Description
 Disable homegenous batch.



CR:749382
CR Number:   749382
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP200 22 Jan 2014 Not a Bug
Description
Linked server RPC call to ASE does not work with OLEDB driver for some of valid syntax.



CR:749732
CR Number:   749732
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2014 Fixed
Description
Compiler errors were noticed when C++ application is built with CM libraries using C++/g++ compiler.
Workaround Description
 WorkAround:

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

Haven't found one yet. CM stuff isn't ready for C++.



CR:749931
CR Number:   749931
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Msg 7306 in Microsoft sqlserver Linked Server with oledb driver ASEOLEDB.



CR:750053
CR Number:   750053
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Mar 2014 Fixed
16 Apr 2014 Fixed
Description
CTLIB: ct_setloginfo() could leak memory.
Workaround Description
 WorkAround:

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

15.0 ESD#18 did not leak but not sure this is viable



CR:750427
CR Number:   750427
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP200 02 Dec 2013 Diagnostic Provided
15.7 SP200 27 Jan 2014 Fixed
Description
ODBC Driver by Sybase: After SQLColAttribute() is called with an invalid identifier, subsequent calls to the function continue to fail for valid identifiers as well.



CR:750920
CR Number:   750920
Product Name:   ADO.NET Data Provider
Product Component:   Builds
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP200 19 Nov 2013 Fixed
15.7 SP200 19 Nov 2013 Fixed
15.7 SP200 19 Nov 2013 Fixed
15.7 SP200 19 Nov 2013 Fixed
Description
Internal Only : Build Enhancements



CR:750971
CR Number:   750971
Product Name:   Connectivity Utilities
Product Component:   dsedit
Status:   Closed
OS:   AIX
Original Version:   cepheus beta2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2013 Fixed
Description
internal only: regression from bug fix.



CR:750999
CR Number:   750999
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2014 Fixed
12 Nov 2014 Fixed
Description
jConnect: When a host was configured to have multiple addresses, jConnect was unable to connect to it if the dataserver was listening on any address other than the fist one in the network interface.



CR:751147
CR Number:   751147
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.7 SP60
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2013 Fixed
21 Nov 2013 Fixed
13 Dec 2013 Fixed
Description
CTLIB: Login packet is incorrectly generated during login redirection and HA failover.



CR:751451
CR Number:   751451
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 30 Jan 2014 Fixed
15.7 SP130 30 Jan 2014 Fixed
15.7 SP130 29 Jan 2014 Fixed
15.7 SP130 30 Jan 2014 Fixed
15.7 SP130 17 Feb 2014 Fixed
Description
ODBC Driver by Sybase: Add support new diagnostic fields in SQLGetDiagField() API which will report fields from EED token.



CR:752961
CR Number:   752961
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 29 Jan 2014 Fixed
Description
ODBC Driver by Sybase: Stack trace does not look meaningful when crash occurs in ODBC application. Request to ship PDB(debug database files) with the ODBC driver.



CR:754157
CR Number:   754157
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 29 Jan 2014 Fixed
15.7 SP130 29 Jan 2014 Fixed
Description
ODBC Driver by Sybase: Values for nullable smallmoney user defined type (UDT) displayed incorrectly.
Workaround Description
 WorkAround:

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

Use ADO.NET Provider or don't allow null in table



CR:754291
CR Number:   754291
Product Name:   Other - Docs: Connectivity
Product Component:   SDK
Status:   Open
OS:   NA
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SSL_TRUST_ALL_CERTS is not documented in the jConnect manual.



CR:754321
CR Number:   754321
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP131 10 Sep 2014 Fixed
Description
ADO.NET: Executing a stored procedure with output parameters of varchar type results in an exception.
Workaround Description
 WorkAround:

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

None that we know of



CR:754396
CR Number:   754396
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
StringIndexOutOfBoundsException in com.sybase.jdbc4.utils.LogUtil.logObject(LogUtil.java:128).

This only occurs when log level is set to FINEST (or ALL).



CR:754609
CR Number:   754609
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jun 2014 Fixed
02 Jun 2014 Fixed
04 Jun 2014 Fixed
03 Jun 2014 Fixed
Description
CTLIB: Memory leak in ct_connect, ct__api_translate_servername() when re-using same connection handle.



CR:754967
CR Number:   754967
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Linux
Original Version:   16.0 sp03
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2014 Fixed
21 May 2014 Fixed
14 Apr 2014 Fixed
16 Apr 2014 Fixed
23 Apr 2014 Fixed
16 May 2014 Fixed
Description
ISQL: Using the --URP flag fails with > 30 character remote passwords.



CR:754996
CR Number:   754996
Product Name:   ADO.NET Data Provider
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 07 Jul 2014 Fixed
Description
ADO.NET : Template DDL folder for EDM not being created by ADO.NET installer.
Workaround Description
 WorkAround:

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

It is possible to create the template folder under %SYBASE%\DataAccess\ADONET\template and copy the files (these are not readily available, PSE gets them from ADO.NET 4 source code).

Then run the AdoNetRegistrar4 utility from the ADONET\dll directory and files are copied to appropraite msdev 2010 locations as specified in the word doc:



The file SSDLToAse155.tt is copied to C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Extensions\Microsoft\Entity Framework Tools\DBGen and file GenerateAseTSQL.Utility.ttinclude is copied to C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\Extensions\Microsoft\Entity Framework Tools\Templates\Includes



CR:755521
CR Number:   755521
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2014 Bundled Request
Description
jConnect: When ENABLE_BULK_LOAD is enabled, setting NULL values on trailing compressed columns can lead to errors in dbcc checktable().
Workaround Description
 REORG REBUILD will correct the data.

(As will SELECT INTO).



CR:755548
CR Number:   755548
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 05 Mar 2014 Fixed
Description
ADO.NET: The AseBulkCopy class does not pad the data with spaces when destination column length is greater than source column. Also it does not trim the data when destination column length is lesser than source column.
Workaround Description
 WorkAround:

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

src < dest this will work:



string sourceCmdSQL = "select convert(char(40), c1) as c1, c2, c3 from " + sourceName;



src > dest



string sourceCmdSQL = "select convert(char(34), c1) as c1, c2, c3 from " + sourceName;



CR:756424
CR Number:   756424
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Missing module, SYPGCICS, and alias, SYGWCAI2.



CR:756499
CR Number:   756499
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 20 Feb 2014 Fixed
15.7 SP130 14 Feb 2014 Fixed
15.7 SP130 17 Feb 2014 Fixed
Description
ODBC Driver by Sybase: Multi-threaded applications observing periodic crashes with invalid pointer access in memcpy.



CR:756815
CR Number:   756815
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 02 Mar 2014 Fixed
Description
ODBC Driver by Sybase: Incorrect values fetched for negative money values when bound as SQL_C_DOUBLE.
Workaround Description
 WorkAround:

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

Bind to SQL_C_NUMERIC, or you can convert money field to numeric(19,4)



"select convert(numeric(19,4),col1) as c1 from dt_money where id=8"



Select stmt: select convert(numeric(19,4),col1) as c1 from dt_money where id=8

Executed statement

In SQLBindAndFetch.

col1 value(SQL_C_DOUBLE): -1

col1 value(SQL_C_DOUBLE)[no exp]: -1.0000

col1 value(SQL_C_DOUBLE): -1e+011

col1 value(SQL_C_DOUBLE)[no exp]: -100000000000.0000

col1 value(SQL_C_DOUBLE): 1

col1 value(SQL_C_DOUBLE)[no exp]: 1.0000

col1 value(SQL_C_DOUBLE): 1e+011

col1 value(SQL_C_DOUBLE)[no exp]: 100000000000.0000



CR:756861
CR Number:   756861
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2014 Fixed
Description
NullPointerException when enable SLL and use one of SybConnectionDataSource Classes.



CR:757053
CR Number:   757053
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 24 Feb 2014 Deferred
Description
ODBC Driver by Sybase: On Windows 2008R2 operating systems a VB application that sends text / image data may fail with a multi-step operation error.



CR:757056
CR Number:   757056
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 12 May 2014 Fixed
Description
ODBC Driver by Sybase: Calling SQLNumResultCols() throws error on queries such as "SELECT * INTO ...".
Workaround Description
 It is possible to handle the exception in .NET and bypass, temp table is created and

application can therefore select or do whatever it wants with the temp table in the session.



CR:757836
CR Number:   757836
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 25 Feb 2014 Fixed
16.0 sp01 17 Feb 2014 Fixed
16.0 sp01 20 Feb 2014 Fixed
16.0 sp01 26 Feb 2014 Fixed
16.0 sp01 20 Mar 2014 Fixed
16.0 sp01 06 Mar 2014 Fixed
16.0 sp01 20 Mar 2014 Fixed
16.0 sp01 04 Jun 2014 Fixed
16.0 sp01 04 Jun 2014 Fixed
Description
ODBC Driver by Sybase: Request to improve performance of parameter array operations.



CR:757975
CR Number:   757975
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP140 02 Sep 2014 Fixed
Description
ODBC Driver by Sybase: On Windows OS where both SAP ASE ODBC driver and the other vendor's ODBC driver have been installed, SAP ASE ODBC driver with a System DSN works but the other ODBC driver may fail to find a User DSN.



CR:758006
CR Number:   758006
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   cepheus
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2014 Fixed
09 May 2014 Already Fixed by Another CR
07 Apr 2014 Fixed
Description
CTLIB/SRVLIB: Correct initialization of TLS/SSL properties.



CR:758448
CR Number:   758448
Product Name:   ADO.NET Data Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 27 Feb 2014 Fixed
Description
ADO.NET: User interface controls do not render correctly on VS2005, VS2010 and VS2012.



CR:758776
CR Number:   758776
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Abend OC1 in the new socket handler, SYBSOCKH.



CR:758792
CR Number:   758792
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASRA in module SYGWCICS, CSECT TDACCEPT.



CR:759103
CR Number:   759103
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 04 Apr 2014 Fixed
Description
ADO.NET: Request to improve SAP Sybase ASE to Microsoft SQL Server transfer performance using SSIS.



CR:759274
CR Number:   759274
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 04 Jun 2014 Fixed
16.0 sp01 04 Jun 2014 Fixed
16.0 sp01 04 Jun 2014 Fixed
16.0 sp01 04 Jun 2014 Fixed
16.0 sp01 10 Jun 2014 Fixed
16.0 sp01 10 Jun 2014 Fixed
Description
ODBC Driver by Sybase: For ODBC connections with EncryptPassword set to 2, under some login failure conditions, ASE ODBC driver retries login with plain text password even if ASE support password encryption.



CR:759457
CR Number:   759457
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2014 Fixed
28 May 2014 Fixed
Description
jConnect: If PROTOCOL_CAPTURE is suspended and resumed during life of a connection, translation of the TDS file may encounter errors.



CR:759506
CR Number:   759506
Product Name:   ADO.NET Data Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 12 May 2014 Fixed
Description
ADO.NET: The DDEX configuration UI fails loading with TypeInitializerException.



CR:759517
CR Number:   759517
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   16.0 SP10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2014 Fixed
21 Mar 2014 Fixed
02 Apr 2014 Fixed
24 Mar 2014 Fixed
Description
jConnect: An error message in reported on calling DatabaseMetaData.supportsTransactionIsolationLevel() function when connected to SAP ASE version 16.0 servers.



CR:759952
CR Number:   759952
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   15.7 SP102
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2014 Fixed
Description
jConnect: A numeric overflow error may be reported when calling DatabaseMetaData.getIndexInfo() function against a table with a very large number of rows.



CR:760021
CR Number:   760021
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2014 Fixed
Description
Product: SDK 15.7 SP110

OS: AIX 7.1 with XLC 12 compiler



Customer: BANCO HSBC S/A (LOSANGO)

Subcase: 11812289-11



Customer would like to have an official certification timeframe of SDK 15.7 products on XLC 12 IBM compiler.



CR:760063
CR Number:   760063
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   RedFlag Linux
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 06 May 2014 Consult Complete
16.0 sp01 07 May 2014 Fixed
16.0 sp01 21 May 2014 Fixed
Description
ODBC Driver by Sybase: Under some situations, calling SQLCancel causes the driver to hang.



CR:760076
CR Number:   760076
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 31 Mar 2014 Fixed
15.7 SP130 21 Mar 2014 Fixed
16.0 sp01 22 Mar 2014 Fixed
16.0 sp01 24 Mar 2014 Fixed
Description
ODBC Driver by Sybase: An UNION query with untyped NULL value for the first row may return incorrect values for subsequent non NULL values.
Workaround Description
 WorkAround:

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

Use 15.7 GA driver or earlier



CR:760136
CR Number:   760136
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP123 31 Mar 2014 Fixed
15.7 SP123 04 Apr 2014 Fixed
15.7 SP123 04 Apr 2014 Fixed
15.7 SP123 05 Apr 2014 Fixed
15.7 SP123 06 May 2014 Fixed
Description
Internal Only :
Performance enhancements



CR:760448
CR Number:   760448
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 13 Apr 2014 Fixed
15.7 SP130 31 Mar 2014 Already Fixed by Another CR
15.7 SP130 13 Apr 2014 Fixed
Description
OLE DB Provider by Sybase: Performance regression observed in SAP ASE OLE DB Provider when transferring data from ASE to Microsoft SQL Server using SSIS.
Workaround Description
 WorkAround:

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

None - other than staying with older 15.5 ASEOLEDB. This poses some risk in that detected bugs will require 15.7 migration.



CR:760536
CR Number:   760536
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
CP/IP Stack Shut down Listener repeats SYBTP09,SYBTP17 message



CR:760771
CR Number:   760771
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 31 Mar 2014 Fixed
15.7 SP110 18 Apr 2014 Fixed
Description
ODBC Driver by Sybase: TDS response errors observed with SSL connections to ASE.



CR:761343
CR Number:   761343
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.7 SP123
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 12 May 2014 Fixed
16.0 sp01 Fixed
16.0 sp01 04 Jun 2014 Fixed
Description
ODBC Driver by Sybase: ODBC driver fails to connect to ASE if there are any extra spaces in in sql.ini file.



CR:761488
CR Number:   761488
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Apr 2014 Fixed
11 Nov 2014 Fixed
26 May 2014 Fixed
Description
jConnect: Loss of scale for float data types when setting them as Decimal values on PreparedStatement and CallableStatement.



CR:761887
CR Number:   761887
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 27 Apr 2014 Fixed
Description
ADO.NET: The ASE ADO.NET Provider throws exception when GetSchema() API is used in a multi-threaded application.



CR:762055
CR Number:   762055
Product Name:   ESQL
Product Component:   Cobol
Status:   Closed
OS:   NA
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2014 Fixed
28 May 2014 Fixed
28 May 2014 Fixed
05 Jun 2014 Not a Bug
Description
ESQL Cobol: Output parameter value (int) not populating parameter buffer.
Workaround Description
 WorkAround:

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

Edit the sybhesql64.cbl file, search for SQL--DFMTDFMT-NAME.:



01 SQL--DFMTDFMT-NAME.

05 SQL--NM PIC X(256).

05 SQL--NMLEN PIC S9(9) comp value is 0.

05 SQL--DATATYPE PIC S9(9) comp value is 100.

05 SQL--FORMAT PIC S9(9) comp value is 1.

05 SQL--MAXLENGTH PIC S9(9) comp value is 0.

05 SQL--SCALE PIC S9(9) comp value is 0.

05 SQL--PRECISION PIC S9(9) comp value is 18.

05 SQL--STTUS PIC S9(9) comp value is 0.

05 SQL--COUNT PIC S9(9) comp value is 1.

05 SQL--USERTYPE PIC S9(9) comp value is 0.

05 SQL--LOCALE PIC S9(18) comp value is 0.



When the SQL--NM attribute dimension is 256 this problem occurs. Change it to 255 and the app will start to work, after rebuild:



Check ret1 values:



1> select * from ret1

2> go

c1 c2 c3

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

BLEI 24 1





outparm





STARTING ZB995

CONNECT+000000000000000000

USE +000000000000000000





INITIAL VALUE OF BLEI_CK = +000000009

NEW c2 FROM FACETS = +000000025





1> select * from ret1

2> go

c1 c2 c3

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

BLEI 25 1



CR:762132
CR Number:   762132
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2014 Fixed
18 Jul 2014 Fixed
Description
jConnect: A scale of zero is used for Decimal parameters when setObject(int parameterIndex, Object x, int targetSqlType) method on PreparedStatement and CallableStatement classes is used with SQL Type Types.DECIMAL.



CR:762595
CR Number:   762595
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2014 Fixed
24 Apr 2014 Fixed
24 Apr 2014 Fixed
24 Apr 2014 Fixed
02 May 2014 Fixed
16 May 2014 Fixed
14 May 2014 Fixed
Description
SRVLIB:When running a select query in dynamic mode (with ct_dynamic) on an IDENTITY column through OpenServer CTOS sample program,

the OpenServer is not able to describe the IDENTITY column for the Open Client client.



OpenServer raises a srv_descfmt() message:

srv_descfmt(): Invalid status (0x85c0) in CS_DATAFMT



CR:762651
CR Number:   762651
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2014 Fixed
Description
OpenSwitch aborts query with identity column with Msg Number 16159



CR:763064
CR Number:   763064
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2014 Fixed
22 Jul 2014 Fixed
Description
jConnect: A SQLException may be encountered when executing a batch on CallableStatement with literal parameters in the SQL text.



CR:763109
CR Number:   763109
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 05 Jun 2014 Fixed
15.7 SP130 05 Jun 2014 Fixed
16.0 sp01 19 Jun 2014 Fixed
Description
ODBC Driver by Sybase: SQLDescribeParam call does not return valid error messages or crashes application on certain insert sql statements with nested select and long table names.
Workaround Description
 WorkAround:

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

Customer can use OEM driver but this is way EOL.



CR:763324
CR Number:   763324
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Linux
Original Version:   15.7 SP110
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 May 2014 Fixed
16 May 2014 Fixed
23 May 2014 Fixed
23 May 2014 Fixed
23 May 2014 Fixed
Description
CTLIB/ESQL: CS_NUMERIC/CS_DECIMAL precision/scale can be incorrect when parameterformat suppression is active for dynamic SQL statements.
Workaround Description
 WorkAround:

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

Customer hasn't completely proved but I suspect changing the OCS vresion to 155 will get

around the problem as the PARAFMT are always sent to the backend.



Make change in cspublic.h:



#define CS_CURRENT_VERSION CS_VERSION_155



And rebuild the application



DYNAMIC2 Token (0x62); variable length

Length [4]: 25

Type [1]: DYN_EXEC (0x02)

Status [1]: DYNAMIC_HASARGS (0x01)

Name Length [1]: 18

Name [18]: "CADetailUpdByDtlId"



Param 14

Name Length [1]: 0

Status [1]: <unrecognized> (0x00)

User Type [4]: 0

Data Type [1]: NUMN

Length [1]: 33

Precision [1]: 19

Scale [1]: 6

Locale Length [1]: 0



Param 14

Length [1]: 9

Param data [9]: 10.500000



CR:763344
CR Number:   763344
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Unknown
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2014 Fixed
17 Jun 2014 Fixed
Description
ISQL: Remove default client limit of 32KB in isql for text/image data.



CR:763566
CR Number:   763566
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 May 2014 Fixed
09 Jun 2014 Fixed
Description
CTLIB: Race condition exists in full asynchronous mode between completion callback and initiation of new API routine in separate thread.



CR:763622
CR Number:   763622
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2014 Duplicate
Description
CallableStatement using batch interfaces with property "HOMOGENEOUS_BATCH" set to "false" generate error JZ0BE: BatchUpdateException: Error occurred while executing batch statement: Incorrect syntax near 'procedurename'.
Workaround Description
 Make sure property HOMOGENEOUS_BATCH is true.



CR:763626
CR Number:   763626
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.7 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 09 Jun 2014 Fixed
Description
ADO.NET: The ASE ADO.NET provider inserts negative Money value as positive when using AseBulkCopy class.
Workaround Description
 Customer is now using ASE Decimal datatype to workaround the issue, but he will need to use Money datatype instead, as per his standards.



CR:763713
CR Number:   763713
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   all
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 12 May 2014 Fixed
Description
ODBC Driver by Sybase: While connecting with a DSN the driver returns a "Null ini file or ini file not found" even though the environment variable SYBASE or ODBCINI is set correctly.



CR:763805
CR Number:   763805
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2014 Fixed
21 Aug 2014 Fixed
Description
jConnect: A call to Connection.close() may result in "java.io.IOException: Stream closed" stack trace being printed.



CR:763991
CR Number:   763991
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP123
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 30 Jun 2014 Fixed
16.0 sp01 25 Jun 2014 Fixed
16.0 sp01 27 Jun 2014 Fixed
Description
ODBC Driver by Sybase: SQLGetData() with SQL_C_CHAR does not return correct double-byte character data.



CR:764140
CR Number:   764140
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP123
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP123 03 Jun 2014 Fixed
Description
ODBC/ADO.NET/OLE DB: With password encryption enabled in a multi-threaded environment some connection attempts fail.
Workaround Description
 WorkAround:

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

Adding sleep can potentially resolve but customer using IIS in Production with 80-100 concurrent and tries to set sleep time and encounters this problem several times on intialization



CR:764227
CR Number:   764227
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 03 Jun 2014 Fixed
Description
ADO.NET: In multi-threaded applications using connection pooling, when ASE is unresponsive bad connections are left in the connection pool resulting in 300004 "Connection Does not Exist" exceptions that render the application unstable.
Workaround Description
 No workaround know to prevent this from happening.



CR:764275
CR Number:   764275
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 26 Jun 2014 Fixed
Description
ODBC Driver by Sybase: Microsoft Query does not show a list of databases correctly because a 911 error occurs when ODBC Driver runs "%..sp_odbc_tables" to get a list of databases.
Workaround Description
 create database [%] on dummy_device = 10

go

use [%]

go

sp_adduser <user name>

go



CR:764500
CR Number:   764500
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.7 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 02 Jun 2014 Fixed
Description
ODBC Driver by Sybase: Driver reports SQL30292:HY000 Attempting to read past stream EOM when fetching a cursor and no rows returned after a warning.



CR:764514
CR Number:   764514
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2014 Fixed
23 Jul 2014 Fixed
Description
jConnect: Using parameter names to set parameter values for CallableStatement results in SQLExeception JZ0BE.
Workaround Description
 jConnect : A JZ0BE error message may be reported when using CallableStatement with setInt() to declare the parameters.



CR:765442
CR Number:   765442
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7 SP123
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 18 Jun 2014 Fixed
Description
ODBC Driver by Sybase: When fetching a negative float value as SQL_C_CHAR or SQL_C_WCHAR it is returned in scientific notation.
Workaround Description
 WorkAround:

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

None other than to use 15.7 GA or earlier release.



CR:765499
CR Number:   765499
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   16.0 sp01
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Dec 2014 Fixed
12 Dec 2014 Fixed
13 Jan 2015 Fixed
14 Jan 2015 Fixed
13 Jan 2015 Fixed
14 Jan 2015 Fixed
Description
CTLIB/SRVLIB: Add support for On Demand Command Encryption.



CR:765836
CR Number:   765836
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP123
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 07 Jul 2014 Fixed
Description
ODBC Driver by Sybase: Calling SQLNumResultCols after SQLPrepare may fail for backend type Gateway (TRS or Gatewayless).
Workaround Description
 WorkAround:

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

Customer using OEM Driver on Windows platform.

It is possible to write langauge handler to deal with the situation. However FDR charges for application modifications and Nordstroms is not going to pay for this.



CR:766002
CR Number:   766002
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Linux
Original Version:   15.7 SP123
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP130 26 Jun 2014 Fixed
Description
ODBC Driver by Sybase: If a server is not listening or reachable at the specified host:port address the ODBC Driver performs multiple redundant connection attempts for the duration of the timeout.
Workaround Description
 WorkAround:

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

The amount of packets sent can be reduced using retry properties:



RetryCount=2

RetryDelay=9000

LoginTimeOut=3



This will reduce the number of network packets exchanged



CR:766039
CR Number:   766039
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   7.07 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2014 Fixed
18 Jul 2014 Fixed
18 Jul 2014 Fixed
18 Jul 2014 Fixed
Description
jConnect: When ENABLE_BULK_LOAD is enabled, setting NULL values for variable length columns can lead to SQLException or DBCC CHECKSTORAGE reporting consistency errors.



CR:766090
CR Number:   766090
Product Name:   OCS Extension module for Python
Product Component:   sypydb
Status:   Closed
OS:   all
Original Version:   15.7 SP130
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Nov 2014 Fixed
24 Nov 2014 Fixed
Description
PYTHON: Failure in discarding resultsets and incorrect exception location.



CR:766200
CR Number:   766200
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   7.07 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jul 2014 Fixed
Description
jConnect: Error 213 may be reported when calling DatabaseMetaData.getIndexInfo() function.



CR:766206
CR Number:   766206
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   7.07 SP120
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2014 Fixed
18 Jul 2014 Fixed
Description
jConnect: RTRIM_FOR_ENABLE_BULK_LOAD does not work correctly when connection property DYNAMIC_PREPARE is set to 'false'.



CR:766285
CR Number:   766285
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 SP100
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2014 Fixed
21 Aug 2014 Fixed
Description
jConnect: Debugging utility class - com.sybase.jdbc4.utils.Debug - fails to print debug information when used with "ALL" flag.



CR:766591
CR Number:   766591
Product Name:   Open Client
Product Component:   cslib
Status:   Open
OS:   all
Original Version:   15.7 SP123
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If ocs.cfg exists and an application name contains both a space and a hyphen, CT-Library programs may not be able to connect to ASE with a common library error "Configuration file syntax error line NN near (-)."



CR:766668
CR Number:   766668
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2014 Fixed
18 Jul 2014 Fixed
Description
COMNLIB: multi-threaded programs could see login failures due to encryption errors.





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