远程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:672383
CR Number:   672383
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.5 ESD 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 23 Jan 2013 Fixed
Description
ODBC Driver by Sybase: Driver hangs in SQLDriverConnect when password contains a closing bracket.
Workaround Description
 WorkAround:

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

Don't create password with closing bracket.



CR:673507
CR Number:   673507
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Update the Open Server components of OpenSwitch Server

to provide essential Open Server vulnerability fixes.



CR:673849
CR Number:   673849
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ADO.NET Provider 15.5 ESD#9



Customer would like feature request to be implemented for LINQ (please refer to: http://msdn.microsoft.com/en-us/netframework/aa904594)



Currently, LINQ's Skip method is not supported. When invoking a code like below:





var posts = context.Posts.Include(p => p.Author).Where(p => p.Blog.Id == blog.Id).OrderBy(p => p.Title).ThenBy(p => p.Id).Skip(4).Take(4);





The following exception is generated at System.Data.EntityCommandCompilationException, as System.NotSupportedException when executing method Sybase.Data.AseClient.SqlGenerator.Visit(DbSkipExpression e).



CR:673851
CR Number:   673851
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ADO.NET Provider 15.5 ESD#9



Customer would like feature request to be implemented for LINQ (please refer to: http://msdn.microsoft.com/en-us/netframework/aa904594)



Currently, LINQ's DDL generation is not supported. They would like it to be supported.



CR:674310
CR Number:   674310
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#7 21 Nov 2012 Fixed
Description
ODBC Driver by Sybase: Visual Basic or Visual C++ application using ADO library and enabling the DynamicPrepare option observe memory leak.



CR:674432
CR Number:   674432
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Calling ResultSetMetaData.getTypeName on large result set throwing out of memory errors.
Workaround Description
 WorkAround:

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

We can use code that does "select * from Table where 1=2



OR



If table has unique index open select as a cursor (like stmt.setFetchSize(X)) -> look at RSTypeNameTest_cur.java for example



CR:674534
CR Number:   674534
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   AIX
Original Version:   15.5 ESD 9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Products:



ASE 15.5 ESD#3

ISQL 15.5 ESD #7

ISQL 12.5.1 EBF13166 ESD #1

SQL Advantange 12.5.3 EBF 12338



Problem Description:



Customer reports that ISQL does not report as much detailed message compared with SQL Advantage.



As SQL Advantage is deprecated customer is requesting FR to be implemented.



This repro can be performed in any platform.



CR:675019
CR Number:   675019
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Nov 2011 Fixed
Description
A client application can't close and re-open a cursor

after ct_fetch() fails. For example, when a deadlock

happens from a client application.
Workaround Description
 Set API_CHECK to 0 in the OpenSwitch config file.

Or set FULL_PASSTHRU to 1 if possible.



CR:675025
CR Number:   675025
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   NA
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2011 Fixed
18 Aug 2011 Fixed
Description
CTLIB: In deferred asynchronous mode, a completion callback routine should only be called after ct_poll() has been called. The fix for CR 639664 is available again.



CR:675144
CR Number:   675144
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 20 Aug 2012 Duplicate
Description
jConnect: Using large number of parameters in PreparedStatement causes SQLExceptions like "Message empty." and/or "The token datastream length was not correct. This is an internal protocol error."
Workaround Description
 WorkAround:

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

Set DYNAMIC_PREPARE=false



CR:675443
CR Number:   675443
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Please document the StripBlanks property that was introduced.

(see eg. CR 558978).



CR:675631
CR Number:   675631
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 11 06 Oct 2011 Fixed
Description
ADO.NET: Query timeout causing incorrect results to be returned under certain situations.
Workaround Description
 WorkAround:

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

None - when the problem occurs, things slow down , results are messed up and they need to restart the application/web servers



CR:675832
CR Number:   675832
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   Unknown
Original Version:   15.5 ESD 13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currently the connectivity utilities do not support the syntax for servername identical to the isql program. This feature request is to support the use of -S<host>:<port> in the utiltity syntax.



CR:676095
CR Number:   676095
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   Solaris
Original Version:   15.5 ESD 8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
As distributed the 64 bit version of OCS is softlinking the libtcl64.cfg to libtcl.cfg This causes problems because the libraries must be 64 or 32 bit in their respective configuration files.
Workaround Description
 Remove the softlink from libtcl64.cfg to libtcl.cfg.



CR:676365
CR Number:   676365
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   HP-UX
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2011 Fixed
Description
In a Mutual Aware OpenSwitch setup, OpenSwitch

might not disconnect the heartbeat connection between

OpenSwitch and ASE properly in the TCP layer when the

ASE network goes offline. These connections are established

when OpenSwitch is started initially to check and

monitor the health of the participating ASE servers.



CR:676471
CR Number:   676471
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLE DB Provider:



First parameter is not past with parameterised query in .net application

connecting with OLE DB or Ado.Net



CR:676855
CR Number:   676855
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Linked server failure when selecting table via four part naming convention when connection is configured for utf8 charset, whether ASE is default of utf8 and client uses ServerDefault or the client is specifically set for utf8.
Workaround Description
 WorkAround:

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

Set charset of the Provider Data Source to iso_1, cp850, not utf8



OR use



SELECT * from OPENQUERY()



CR:677025
CR Number:   677025
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2011 Fixed
Description
ADO.NET: Client program receives "Internal error" when multiple raiserrors follow a SELECT result.
Workaround Description
 WorkAround:

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



Customer using older 1.15.4110.0 Provider.



CR:677205
CR Number:   677205
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A client application can not re-open a cursor after ct_fetch() fails due to a deadlock and ASE 15.x automatically closes the cursor.
Workaround Description
 Set FULL_PASSTHRU to 1 if possible.



CR:677728
CR Number:   677728
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OSW to support login redirection feature



CR:677963
CR Number:   677963
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Aug 2011 Fixed
Description
ODBC Driver by Sybase: Executing stored procedures with fully qualified / multi-part names produces syntax errors.



CR:678260
CR Number:   678260
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2011 Fixed
Description
NETLIB: Using interfaces file entries having hostnames and SSL server certificate commonNames which both exceed 30 characters are not working properly with directory services. The commonName from the SSL certificate appears to be garbled. Error is Network error - Failed to install network filter.
Workaround Description
 Use a shorter hostname on the entries or the IP address for the hostname in the interfaces files.



CR:678477
CR Number:   678477
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 16 Aug 2012 Fixed
Description
ADO.NET: AseBulkCopy throws exception when inserting values in Numeric Identity columns.
Workaround Description
 WorkAround:

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

None found - I think this works on older 1.1 Provider.



CR:678678
CR Number:   678678
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 21 Jun 2012 Fixed
Description
ADO.NET: AseBulkCopy fails on numeric columns with InvalidCaseException.
Workaround Description
 WorkAround:

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



None - we tried EnableBulkLoad = 0 and run into CR 678477



CR:679678
CR Number:   679678
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2012 Fixed
Description
CTLIB: A new connection property CS_PROP_BRACKETED_IDENT is added to Client-Library. When this property is enabled, object names retrieved by calling Client-Library APIs, such as ct_data_info() and ct_describe() are bracketed.



CR:679782
CR Number:   679782
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   auriga fs3+
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2011 Fixed
09 Aug 2011 Fixed
10 Aug 2011 Fixed
Description
jConnect: Login with password encryption enabled may hang if default network packet size is set to greater than 512KB.



CR:679821
CR Number:   679821
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   15.5 ESD 11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jul 2012 Fixed
09 Jul 2013 Fixed
06 Aug 2013 Fixed
Description
SRVLIB: Provide a new server property SRV_S_ADJUSTRECVPARAMLEN to support adjusting maxlength of parameter upon charset conversion (multi-byte) between client and Open Server gateway applications.



CR:679853
CR Number:   679853
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 11 06 Oct 2011 Fixed
Description
ODBC Driver by Sybase: Memory leak observed in multi-threaded application performing SELECT queries.
Workaround Description
 WorkAround:

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

Customer can use their 15.0.0.349 build but this prevents them from upgrading to keep up and if there are fixes they require in current releases.



CR:680395
CR Number:   680395
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 09 Aug 2012 Fixed
Description
OLE DB Provider by Sybase: The sp_oledb_datatype_info stored procedure performs slower as compared to sp_odbc_datatype_info.
Workaround Description
 WorkAround:

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

There isn't any unless you comment out the syscolumns table reference in the 2 queries involved in the UNION

[see Observations in CR description]



CR:681179
CR Number:   681179
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   SunOS
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2011 Fixed
Description
Added zh_CN.GB18030 in the [sun_svr4] section of locales.dat.



CR:681442
CR Number:   681442
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 03 02 Mar 2012 Fixed
Description
Add new parameter to the listener to allow RPC's sent via a Direct Connect gateway to run using the DC Service Name as the userid. This will require the new "sendservicename" parameter being introduced in Direct Connect 15.0 ESD7.



CR:681990
CR Number:   681990
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Would like to see OCS Directory Services augment an interfaces file on the fly as LDAP entries are accessed by client usage.



CR:682239
CR Number:   682239
Product Name:   Connectivity Utilities
Product Component:   dsedit
Status:   Closed
OS:   NA
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2011 Fixed
21 Jan 2014 Fixed
22 Jan 2014 Fixed
Description
DSEDIT: Stop ship old dsedit_dce helper files for UNIX platforms.



CR:683621
CR Number:   683621
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature Request, ct_param, ct_dynamic to support array binding.



CR:683748
CR Number:   683748
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#4 19 Jun 2012 Fixed
Description
ADO.NET: Unable to connect to Adaptive Server with roman8 character set from Microsoft Visual Studio DDEX plugin.
Workaround Description
 WorkAround:

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

Customer is using OLE DB Provider which is working. They would like to move to the native Provider at some point.



CR:684306
CR Number:   684306
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2011 Fixed
Description
ADO.net provider:



Memoryleak when using AseCommand.ExecuteReader to call a stored procedure returning a resultset



CR:684626
CR Number:   684626
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows Vista
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 16 Aug 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
ADO.NET: DataReader does not work with a new connection if the original connection is killed.
Workaround Description
 WorkAround:

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

Adding the first line in the catch block resolves this problem:



selectAuthors = new AseCommand("select * from authors", new AseConnection(CONNECTIONSTRING));

selectAuthors.Connection.Open();

selectAuthors.Connection.ChangeDatabase("pubs2");

//After the connection is open and we change the database re-execute.

try

{

AseDataReader authorsReader = selectAuthors.ExecuteReader(); //<-- Access Violation



CR:684706
CR Number:   684706
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   Microsoft Windows
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Oct 2011 Fixed
Description
CTLIB: A Client-Library application may crash if it calls ct_config(CS_USER_ALLOC) and ct_config(CS_USER_FREE) to install user defined memory allocation and free routines and then calls ct_config(CS_IFILE) to set new interfaces file.



CR:685112
CR Number:   685112
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD 10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2012 Fixed
Description
ESQL: cpre does not print Japanese error messages even if the LANG environment variable is set to ja.



CR:685357
CR Number:   685357
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 May 2012 Fixed
Description
Internal Only:



Re-align the codepath where current CM

is the CM to be disconnected and make

it handle for both regular and refreshed

CM cases.



CR:685876
CR Number:   685876
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for data source lookup table from SSIS when creating connection
Workaround Description
 WorkAround:

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

None - just enter known data source



CR:685980
CR Number:   685980
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#13 27 Oct 2011 Fixed
15.7 ESD#1 27 Oct 2011 Fixed
Description
ADO.NET: Entity Data Model entities incorrectly mapped when using ASE user datatypes.



CR:686147
CR Number:   686147
Product Name:   Open Client/Open Server-Doc
Product Component:   Programmer's Supplement
Status:   Closed
OS:   all
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2014 Fixed
Description
Even if bcp in with -e raises an overflow error on character types columns, an error file is not created. This is expected behavior, but Open Client and Open Server Programmers Supplement has the opposed explanation.



CR:686570
CR Number:   686570
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#3 28 Mar 2012 Bundled Request
Description
ADO.NET: Executing a statement with parameters where the statement's SQL text begins with "CREATE" fails with "Must declare variable '<parameter name>'" error.
Workaround Description
 WorkAround:

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

If the code is wrapped in stored procedure it'll work. However, this customer has to deal with TEXT columns and on ASE 15.5 can't do this.

Not ready for 15.7 at this time!



Also, you might say - add something before "CREATE TABLE"



With 15.0 ESD#09

I can add "declare @a int" as some bogus stmt and the batch works



However, not with 15.0 ESD#10 or 5.7 - still fails the same and I have no idea why.

There is some other change in the parser between ESD09 and ESD10.



CR:687285
CR Number:   687285
Product Name:   ESQL
Product Component:   Cobol
Status:   Closed
OS:   Solaris
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2011 Not a Bug
Description
Our customer Caixa Economica Feredal will migrate the following env:



OC and ESQL/Cobol 11.1.1

ASE 11.9.2.3

Sun Solaris 5.8 32Bits

MF Cobol 4.1



TO:



OCS and ESQL/Cobol 15.5 ESD#4

ASE 15.5

Sun Solaris 5.10 64Bits

MF Cobol 5.1





Customer reported 2 errors during migration process, on specific fields below:



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



For the field WH-EM85-NR-CCDEBI defined as 揚IC 9(012) COMP he got the error: An integer had too many digits for the PIC of the data item was fetched into"



The table datatype on ASE is a Numeric (12). He was able to solve the error by changing the code 揚IC 9(012) COMP to 揚IC 9(013) COMP



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



The other error was reported on the WH-EM01-CDCLIENT-F field, defined as 揚IC 9(011) COMP that report the error: The conversion/operation resulted in overflow"



The table datatype on ASE is a Numeric (11). He was able to solve the error changing the code 揚IC 9(011) COMP to 揚IC 9(011)



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



Customer needs to know whether this kind of behavior is now default in new OCS 15.5 version, or it is an issue related to SDK (ESQL/Cobol) or Microfocus Cobol.
Workaround Description
 See case description.



CR:687423
CR Number:   687423
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#3 28 Mar 2012 Fixed
Description
ADO.NET: Cannot execute a statement with SQL text that includes "DECLARE" keyword, receive "invalid amount of parameters" error.
Workaround Description
 WorkAround:

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

Use ESD#09 - but if you need ESD#10 or higher than there is no workaround.



CR:688158
CR Number:   688158
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#3 28 Mar 2012 Duplicate
Description
jConnect: Request to implement getClientInfo() and setClientInfo() API on the Connection object.



CR:688267
CR Number:   688267
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
auriga 12 Jan 2012 Not reproducible with latest version of the product available as of Resolution Date
Description
ASE ODBC Driver Data Overflow when login uses kerberos ticket size >8K



CR:688565
CR Number:   688565
Product Name:   SDK
Product Component:   Java
Status:   Open
OS:   all
Original Version:   5.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Java SDK: several Stream methods are not documented



CR:689183
CR Number:   689183
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2012 Fixed
Description
CSLIB: A truncation error may be reported during unichar to char conversion.
Workaround Description
 Change the sample.



CR:689186
CR Number:   689186
Product Name:   OCS Extension module for Python
Product Component:   sypydb
Status:   Open
OS:   all
Original Version:   2.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
New Feature Request for Sybase Python module to support current stable versions of Python 2.7 and 3.2 on 32 & 64-bit.
Workaround Description
 None known.



CR:689201
CR Number:   689201
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.5 ESD 11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2011 Fixed
Description
CTLIB: Program version in TDS login package does not match with ESD version.



CR:689221
CR Number:   689221
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2011 Fixed
18 Jan 2012 Fixed
09 Dec 2011 Fixed
10 Jan 2012 Fixed
Description
Introduce randomization in TDS login protocol.



CR:689515
CR Number:   689515
Product Name:   ADO.NET Data Provider
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#1 14 Dec 2011 Duplicate
Description
SDK 15.5 ESD#11 installer is not registering 2.0 Provider in the GAC.



CR:689846
CR Number:   689846
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2011 Fixed
Description
BCP: bcp does not work with ASE version 12.5.4 or earlier.



CR:690143
CR Number:   690143
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Nov 2011 Fixed
Description
EXAMPLE: Ctlibrary sample "lobrpc" requires input file "lopsum.txt".



CR:690228
CR Number:   690228
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   7.07 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#3 13 Mar 2012 Fixed
14 Mar 2012 Fixed
Description
jConnect: Request to provide an option to have Adaptive Server char() nullable column values not to be blank padded.
Workaround Description
 From ASE:

Use the rtrim() function to strip whitespaces.



From Java:

Use ResultSet.getString(x).trim() to strip whitespaces prior to string storage/usage.



CR:691029
CR Number:   691029
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Unknown
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Oct 2012 Fixed
15 Oct 2012 Fixed
15 Oct 2012 Fixed
07 Nov 2012 Fixed
20 Nov 2012 Fixed
Description
SRVLIB: Native support for password encryption.



CR:691030
CR Number:   691030
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 02 Mar 2012 Fixed
Description
SYBLSTNR - BACKLOG Param Hard coded as 5, does not pick up the CFG #



CR:691044
CR Number:   691044
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#3 16 Mar 2012 Fixed
16 Mar 2012 Fixed
27 Mar 2012 Fixed
07 Mar 2014 Fixed
Description
jConnect: The getGeneratedKeys() call to fetch generated keys does not work if called after Statement.execute().
Workaround Description
 Use PreparedStatement.executeUpdate()



CR:691188
CR Number:   691188
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2011 Fixed
14 Dec 2011 Fixed
14 Dec 2011 Fixed
14 Dec 2011 Fixed
Description
jConnect: Introduce randomization in TDS login protocol.



CR:691288
CR Number:   691288
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Linux
Original Version:   16.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16.0 sp01 18 Aug 2014 Fixed
16.0 sp01 18 Aug 2014 Fixed
16.0 sp01 04 Aug 2014 Fixed
16.0 sp01 18 Aug 2014 Fixed
16.0 sp01 12 Aug 2014 Fixed
Description
ODBC Driver by Sybase: When Dynamic Prepare is enabled and SQLPrepare fails due to a fatal error such as a table does not exist, the Driver does not propagate this error back to the application and executes the statement as SQL language command instead.



CR:691462
CR Number:   691462
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2012 Fixed
Description
In a Mutual Aware OpenSwitch setup, OpenSwitch couldn't

handle the ASE failure properly because of ASE network

glitches (where ASE host machine goes offline and back

online more frequently.)



CR:692352
CR Number:   692352
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD 11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2012 Fixed
Description
BCP: BCP includes a new command line option --clienterr errorfile. The functionality of this option is the same as -e option in OCS 15.0 ESD #8 and earlier.
Workaround Description
 WorkAround:

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

None for 15.5/15.7, other than to keep using 12.5.1



CR:692433
CR Number:   692433
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect: Meta-data stored procedure sp_jdbc_getindexinfo, called by javax.sql.getindexinfo(), fails if the table has more than 2 billion rows. This limitation is part of the JDBC specification as CARDINALITY is defined as "int => When TYPE is tableIndexStatistic, then this is the number of rows in the table..."
Workaround Description
 Can possibly 'edit' the stored procedure 'sp_jdbc_getindexinfo'.



CR:692441
CR Number:   692441
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 02 Mar 2012 Fixed
Description
Customer would Like Listener to WTO when ever the Listener Shuts down



CR:692448
CR Number:   692448
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Open
OS:   all
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC/OLE DB/ADO.NET: Introduce randomization in TDS login protocol.



CR:692758
CR Number:   692758
Product Name:   ADO.NET Data Provider
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 08 Mar 2013 Duplicate
Description
ADO.NET: The ASE ADO.NET Providers no longer appear in Add References dialog under Visual Studio.
Workaround Description
 WorkAround:

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

Browse for the Provider of your choice



or manually add information to Windows registry for this to work. Check word doc adonet4_register_list.docx attached to CR for details



CR:693036
CR Number:   693036
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.5 ESD 11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#3 28 Mar 2012 Fixed
Description
ODBC Driver by Sybase: In the SQLBindParameter()API, the ODBC Driver checks the columnSize specified for SQL_BIGINT columns. This is a fixed length column and as per ODBC specification, the columnSize should not be checked.



CR:693500
CR Number:   693500
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#3 12 Jan 2012 Fixed
Description
ADO.NET: A Decimal parameter with value of null and implicit Precision/Scale is sent with Precision = 0, this query fails if ASE statement cache is enabled with message "Length or precision specification 0 is not within the range of 1 to 255."
Workaround Description
 WorkAround:

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

Don't use the statement cache or check CR 662048 for alternatives



CR:693767
CR Number:   693767
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD 9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Feb 2012 Fixed
Description
BCP:Increase the number of rows that bcp can handle to the max of an unsigned 64bit integer(18446744073709551615).



CR:693965
CR Number:   693965
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Fix manual: "Ping Server" parameter is false by default in 15.5 ESD#11



The information at URL below needs to be changed:



http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc20066.0215/html/adonet2155/Asaconnection_apiref.htm



Manual states Ping Server=true by default. However, according to our tests, the "select 42" produced by the Ping Server in ADO.NET 15.5 ESD#11 is returned only when we explicitly write "Ping Server=true" in connection string. By default Ping Server is assumed false in 15.5 ESD#11.



CR:694021
CR Number:   694021
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#4 20 Jun 2012 Fixed
Description
OLE DB Provider by Sybase: Stored Procedure output parameters of varchar type are corrupted if length exceeds 4095 bytes.
Workaround Description
 WorkAround:

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

ADO.NET Provider works, but none found for OLE DB Provider



CR:694329
CR Number:   694329
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
To assign severity levels on OSW error messages



CR:694698
CR Number:   694698
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   all
Original Version:   15.5 ESD 11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2012 Fixed
19 Oct 2012 Fixed
16 Apr 2012 Fixed
05 Jul 2012 Fixed
06 Jul 2012 Fixed
Description
OCS: Request to use SYBOCS_TCL_CFG environment variable to specify the location of libtcl.cfg/libtcl64.cfg.



CR:694860
CR Number:   694860
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.5 ESD 11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#5 22 Oct 2012 Fixed
15.7 ESD#7 23 Oct 2012 Fixed
Description
OLE DB Provider by Sybase: SSIS OLEDB Component throws error "incorrect syntax near where 1=2", while moving data from ASE to MSSQL using SQLCommand that is a stored procedure.
Workaround Description
 WorkAround:

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

0. Create connections for ASE (Source) , MSSQL (Destination), another MSSQL (Source)

1. Create the Source using mssql server as the database. Make sure the same table and stored procedure are created here - I would do so in a test database, and just insert a few rows in the table.

2. In Advanced Edit for the ADO.NET|OLEDB Source, select "False" for "ValidateExternalMetadata".

3. Click the Column mappings and proceed to next step

4. Create the Destination to MSSQL Server target table, connect Source to this object

5. Go back to the Source and change connection to the ASE connection, using SQL Command and the "exec sprocName" for the command

6. Don't touch anything else on the Source, don't look at columns, no Preview, nothing

7. Run the application and check that the data transferred to the Destination MSSQL Server



CR:695334
CR Number:   695334
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2012 Fixed
Description
Mutual Aware setup :



In an architecture where site 1 has Primary OSW

and Secondary ASE with Repl. server and site 2

where Secondary OSW and Primary ASE runs,

if there is a network outage between these

two sites, both Primary and Secondary OSW's

might take independent decisions which is not

desirable.



CR:695607
CR Number:   695607
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 16 May 2014 Duplicate
Description
Object permission issue with ODBC driver 15.7 after drop/recreate stored procedures



CR:695797
CR Number:   695797
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Documentation CR for the changes made in 15.1 ESD#6.



CR:695803
CR Number:   695803
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2012 Fixed
Description
CPRE: precompiler throws argument inconsistency error when the variable used to represent a text column in a SELECT is defined as a pointer to CS_TEXT.
Workaround Description
 WorkAround:

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

If text data isn't too large you can use the static buffer, but if some text is rather large this becomes very inefficient as the pre-allocated amount of memory will be used for each SELECT.



CR:696129
CR Number:   696129
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Feb 2012 Fixed
Description
Mutual Aware setup:



Deprecate RCM's MONITOR_STANDBY_ASE config option.



Standby ASE's status was monitored conditionally

based on this option. With this fix, Standby ASE

is monitored and status changed at all times as

Primary ASE to be consistent and not to differentiate

between Primary and Secondary ASE's.



CR:696262
CR Number:   696262
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD 9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2012 Fixed
Description
BLKLIB: Applications may encounter memory leak during bulk copy of two or more text columns.
Workaround Description
 WorkAround:

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

There is none.



CR:696285
CR Number:   696285
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2008
Original Version:   15.5 ESD 8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#3 28 Mar 2012 Bundled Request
Description
ADO.NET: Executing a command with parameters where the SQL statement includes references Transact-SQL variables (such as @variable_name) produces errors like "must declare variable".
Workaround Description
 WorkAround:

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

There is no workaround - customer using NHibernate



CR:696562
CR Number:   696562
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Solaris
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC samples use incorrect compile & link flag on Solaris



CR:696568
CR Number:   696568
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2012 Fixed
Description
CPRE/COBPRE: precompiler may core dump when not all host variables have indicator variables specified.
Workaround Description
 WorkAround:

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

Use struct_name.member_name in SQL EXECUTE host variables



So if using struct like this:



struct

{

CS_CHAR c1[HOST_ARRAY_CAT_LEN][CATID_LEN];

CS_CHAR c2[HOST_ARRAY_CAT_LEN][CAT_NAME_LEN];

int c3[HOST_ARRAY_CAT_LEN];

CS_CHAR c4[HOST_ARRAY_CAT_LEN][2];

} this_c;



Instead of calling



EXEC SQL EXECUTE user_all_ySub_nShow_yPred

INTO :this_c, :c_flag indicator :c_flag_indic

USING :user_id_host, :user_id_host, :user_id_host;





Call it like



EXEC SQL EXECUTE user_all_ySub_nShow_yPred

INTO :this_c.c1, :this_c.c2, :this_c.c3, :this_c.c4, :c_flag indicator :c_flag_indic

USING :user_id_host, :user_id_host, :user_id_host;



CR:696736
CR Number:   696736
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
JConnect with OSW to have the same properties as with ASE with autocommit=false



CR:699038
CR Number:   699038
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   7.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 10 Oct 2012 Bundled Request
Description
jConnect: Request to support timestamp data type for Bulk Insert.



CR:699564
CR Number:   699564
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#3 15 Mar 2012 Fixed
15 Mar 2012 Fixed
Description
jConnect: Incorrect major and minor version reported by getMajorVersion and getMinorVersion functions in DatabaseMetaData and Driver classes. The same incorrect versions are passed in the TDS login packet to the Server.



CR:699567
CR Number:   699567
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#3 10 Apr 2012 Bundled Request
Description
jConnect: Request to add Debug or Normal string into Version string embeddded with the jConnect jar files to distinguish the type of build.



CR:699586
CR Number:   699586
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Linux
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#4 19 Jun 2012 Fixed
Description
ODBC Driver by Sybase: Request support for ODBC Driver Managers with 8-byte SQLLEN definition on Linux 64-bit platforms.
Workaround Description
 WorkAround:

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

For the pyodbc situation. You need to rebuild the pyodbc.so module.



1. On command line:



setenv CFLAGS -DBUILD_LEGACY_64_BIT_MODE



2. From the /usr/local/src/pyodbc-2.1.11 directory rebuild:



/usr/local/bin/python2.6 setup.py build



/usr/local/bin/python2.6 setup.py install



When you run the python script the output should be okay:



>>> import pyodbc

>>> cnxn = pyodbc.connect('DSN=pvxp1570;UID=sa;PWD=secret')

cursor = cnxn.cursor()

cursor.execute("select cast(12500000.000 as decimal(20,4)), cast(null as decimal(20,4)), null")

row = cursor.fetchone()

print 'c1: ', row[0]

print 'c2: ', row[1]

print 'c3: ', row[2]>>> cursor = cnxn.cursor()

>>> cursor.execute("select cast(12500000.000 as decimal(20,4)), cast(null as decimal(20,4)), null")

<pyodbc.Cursor object at 0x1df4d3f0>

>>> row = cursor.fetchone()

>>> print 'c1: ', row[0]

c1: 12500000.0000

>>> print 'c2: ', row[1]

c2: None

>>> print 'c3: ', row[2]

c3: None

>>>



** NOTE: In c/C++ you can add compile option:



-DBUILD_LEGACY_64_BIT_MODE



to resolve this.



CR:699889
CR Number:   699889
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect: Initial GA release for jConnect 7.07.



CR:700060
CR Number:   700060
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2012 Fixed
18 Apr 2012 Fixed
17 Apr 2012 Presently Not Targeted For Any Future Release Of This Product
Description
jConnect support for multiple bit columns when using Bulk Inserts for the Jdbc Batch Interface. (ENABLE_BULK_LOAD)



CR:700172
CR Number:   700172
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2008
Original Version:   15.7 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Error: 揅OUNT field incorrect occurs when executing stored procedure when using Microsoft Report Writer
Workaround Description
 WorkAround:

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

Code the text with ? placeholders and then add the parameter code to the Parameters section of the DataSet (per the word document pgs 10-12).



CR:700577
CR Number:   700577
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   15.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In certain scenarios involving a language based procedure call with named input

parameters it is possible that the driver may fail to send the bind value for the

first input parameter. This is caused by a missing PARAMFMT toekn (and child tokens).



CR:700592
CR Number:   700592
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#4 25 Apr 2012 Fixed
25 Apr 2012 Fixed
Description
jConnect: Calling PreparedStatement.clearParameters() before PreparedStatement.executeBatch() is executed clears previously added parameter sets.
Target Version
 7.07 ESD#4



CR:700609
CR Number:   700609
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2012 Fixed
04 Sep 2012 Fixed
25 Jul 2012 Fixed
27 Jul 2012 Fixed
Description
ISQL: Need a command line flag for ISQL to specify remote password.



CR:700628
CR Number:   700628
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#3 28 Mar 2012 Fixed
Description
ADO.NET: StackOverflowException using AddRange in AseParameterCollection
Workaround Description
 WorkAround:

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

Use List for now until the Array problem is resolved.



CR:700636
CR Number:   700636
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jul 2012 Fixed
21 Sep 2012 Fixed
16 Jul 2012 Fixed
30 Aug 2012 Fixed
25 Jun 2013 Fixed
15 Oct 2012 Fixed
07 May 2014 Presently Not Targeted For Any Future Release Of This Product
01 Jul 2013 Fixed
Description
CT-Library: Provide CS_PROP_INITIAL_DATABASE, CS_PROP_CURRENT_DATABASE, CS_PROP_USE_LAST_DATABASE to allow applications to connect to specified database at connection time.



CR:700838
CR Number:   700838
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
install_odbc_sprocs for ASE 12.5.0.3 fails with some syntax errors because odbc_mda_12503.sql contains the SET statement and the CAST function which are not supported in ASE 12.5.0.3.



CR:701464
CR Number:   701464
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.07
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.07 ESD#5 08 Aug 2012 Fixed
15 Oct 2012 Fixed
Description
jConnect: Executing PreparedStatement with the QUERY that contains more than 500 parameters fails with: java.sql.SQLException: Message empty.
Workaround Description
 Use fewer params.





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