提供7*24专业Sybase数据库远程及现场技术支持,Sybase ASE及Sybase SQL Anywhere数据库修复服务,
请联系电话: (微信),QQ: 289965371!
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371 联系我们获取数据库技术支持!
Email: 289965371@qq.com
扫描下方微信,联系我们:
扫描雨翰数据恢复官方微信获取专业数据库恢复服务

 

随着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:631480
CR Number:   631480
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jan 2011 Fixed
01 Feb 2011 Fixed
Description
ISQL: ISQL produces a truncation error when converting data of date, datetime or bigdatetime type to strings.
Workaround Description
 - convert date into datetime type inside query

- convert date into char inside query



CR:631646
CR Number:   631646
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Jun 2010 Duplicate
Description
SQLSETPOSIROW and SQLUPDATE fails with 102 syntax error.



CR:631714
CR Number:   631714
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.5 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2010 Fixed
08 Sep 2010 Fixed
Description
jConnect: Data from ASE using default character set “cp949” not correctly converted with jConnect.



CR:631780
CR Number:   631780
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 03 Aug 2010 Fixed
Description
OLE DB Provider by Sybase: Memory Leak observed with adExecuteNoRecords when the ActiveConnection of the command is set to Null.



CR:631926
CR Number:   631926
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2010 Not a Bug
15.7 SP100 30 May 2013 Fixed
Description
ODBC Driver by Sybase: Text parameters corrupted in MFC based applications under certain situations.
Workaround Description
 WorkAround:

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

None - other than change the RFX_Text nMaxLength field.



CR:632152
CR Number:   632152
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Want to use multiple oledb driver (ASEOLEDB) with the same version.



CR:632425
CR Number:   632425
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 28 Jun 2010 Fixed
Description
ODBC Driver by Sybase:

Error Message for null was not displayed in the dialog box.
Workaround Description
 WorkAround:

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

None



CR:632447
CR Number:   632447
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 28 Jun 2010 Fixed
Description
ODBC Driver by Sybase: SQLSetPos or SQLParamData not returning error text for duplicate key insert errors.



CR:632734
CR Number:   632734
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   RH
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2010 Fixed
Description
Write To CSV Socket Adapter: When the socket connection breaks or the server goes down, no error was being placed in the log file when using default logging level. The error is now being logged at the default level.



CR:632835
CR Number:   632835
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   RH
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2010 Fixed
Description
The Write To CSV Socket Adapter did not reconnect after a connection was lost during adapter execution and the server was restarted.



CR:632852
CR Number:   632852
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#4 19 Jun 2012 Fixed
Description
OLE DB Provider by Sybase: The Sybase Data Source Administrator (sybdrvadm.exe) crashes when used by a user without Administrator privileges.
Workaround Description
 Don't press the Options button if you're a non-admin user.



CR:632886
CR Number:   632886
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 08 Jul 2010 Fixed
Description
ADO.NET: Non-nexistent column error when not issuing Connection.ClearPool()



CR:633161
CR Number:   633161
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 21 Sep 2010 Fixed
Description
ADO.NET: Creating Update command with CommandBuilder kills current result set.
Workaround Description
 WorkAround:

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

None



CR:633395
CR Number:   633395
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#3 12 Jan 2012 Fixed
Description
ADO.NET: Executing a query that returns a column of type Java Integer results in error.
Workaround Description
 WorkAround:

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

select convert(int, retint.retint())



The conversion forces to return as int.



CR:633645
CR Number:   633645
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 26 Jul 2010 Fixed
Description
OLE DB Provider by Sybase: Calling stored procedure with long string argument causes "Implicit conversion from datatype 'TEXT' to 'VARCHAR' is not allowed" error.
Workaround Description
 WorkAround:

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

You can set size to 8192 or lower but this is not an option for the customer since they require this 9800 size for their data.



CR:633801
CR Number:   633801
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2010 Fixed
23 Jul 2010 Fixed
19 Jul 2010 Fixed
27 Jul 2010 Fixed
25 May 2011 Fixed
Description
LOCALE: CSI locale messages were incorrectly installed in $SYBASE/locales/unicode/csi/en_us instead of $SYBASE/locales/unicode/csi/en_US.



CR:633805
CR Number:   633805
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jul 2010 Fixed
Description
OLE DB Provider by Sybase: The statement "exec sp_a 1; exec sp_a 2; exec sp_a 3;" is sent to ASE with the semi-colons.
Workaround Description
 WorkAround:

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

Removing the ";" will resolve case #1 [This customer not willing to do this yet]



Case #2 - exec sp_a;1 1 exec sp_a 2 'TEST' exec sp_a 3 1.20 NO WORKAROUND



Case #3 - removing delimiting ";" results in the above command.



CR:633940
CR Number:   633940
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Generic
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Linux OpenSwitch log has references of 64

in the OCS version strings upon startup

though OCS libraries are built with mode

set to 32.



CR:633945
CR Number:   633945
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
8002 20 Mar 2011 Fixed
Description
ODBC Driver by Sybase: Runtime error received when sending a "create procedure" SQL from ODBC Driver.
Workaround Description
 WorkAround:

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

Customer can run this is they comment out the parameter names in the call to the stored procedure. At this point this might not be feasible if they execute many scripts with this format.



CR:634082
CR Number:   634082
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 9 20 22 Dec 2010 Fixed
Description
ODBC Driver by Sybase: When using "exec ? = <procedure_name> ( ?, ? )" syntax, SQLNumParams() returns incorrect number of parameters and SQLExecute() fails.
Workaround Description
 WorkAround:

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

This syntax will work:

{? = call JP_PR_ABC_TEST_DET (?,?,?,?) }



CR:634495
CR Number:   634495
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 9 01 Mar 2011 Fixed
Description
ODBC Driver by Sybase: Cannot retrieve stored procedure output parameters before calling SQLMoreResults from VB/RDO Application.
Workaround Description
 WorkAround:

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

In ODBC API use SQLMoreResults or process results.

In VB / RDO use MoreResults



CR:634539
CR Number:   634539
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Aug 2010 Fixed
Description
ODBC Driver by Sybase: Character data is still converted for INSERT statements when Charset=NoConversions is selected.
Workaround Description
 WorkAround:

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

Charset=ServerDefault;KeepOrgMultibyte=1;



However, we'd like NoConversion to not convert on the insert.



CR:634621
CR Number:   634621
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 08 Jul 2010 Fixed
Description
ODBC Driver by Sybase:

MFC application is crashing when the image data file is missing.



CR:634634
CR Number:   634634
Product Name:   Connectivity Utilities
Product Component:   defncopy
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2010 Fixed
22 Jul 2010 Fixed
Description
DEFNCOPY: defncopy reports error when it handles an identifier whose length is larger than 30.
Workaround Description
 Use flag 7717



CR:635039
CR Number:   635039
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2010 Not a Bug
Description
Socket Listener crashing with a Errno ECONNRESET



CR:635090
CR Number:   635090
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Red Hat Enterprise Linux
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 11 29 Aug 2011 Fixed
Description
ODBC Driver by Sybase: Prepared SQL queries that begin with "if exists" or "raiserror" or "waitfor" perform poorly.
Workaround Description
 Setting dynamicprepare=0 will work okay. Sends parameterized language statement.



CR:635827
CR Number:   635827
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#4 20 Jun 2012 Fixed
Description
ADO.NET: Request to ship source code for Microsoft Enterprise Library 4.1 adoption for Sybase Adaptive Server ADO.NET Data Provider.



CR:636198
CR Number:   636198
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 18 Aug 2010 Fixed
Description
ADO.NET: Adding a new parameter to Command.Parameters with the name spelled with the wrong case, results in "COUNT field incorrect" error.



CR:636449
CR Number:   636449
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#3 28 Mar 2012 Fixed
Description
ADO.NET: The native .NET data type used to retrieve decimal and numeric data cannot accommodate the full range of the underlying Adaptive Server data type causing overflow errors.
Workaround Description
 WorkAround:

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

A possible workaround is this query:



C:\Stuff\subcases\asenet\11582535-11\pseRepro\DecimalTest\DecimalTest\bin\Debug>DecimalTest pveroxp 1503 sa sybase odbc "ASE ADO.NET Provider"

"select col1, convert(decimal(29,28), round(col2, 28) ) from decimaltest29 where col1 = 2"

Values are 2, 2.1234567890123456789012345678



Notice we can use the precision 29, .NET limitation for the decimal type. If you go on notch up, the same failure does occur.



CR:636496
CR Number:   636496
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)
02 Nov 2010 Third Party Problem
Description
When inserting data using a PreparedStatement, jConnect truncates data under the following conditions:



- The column type is univarchar

- The first value inserted into the column is less than or equal to 128 characters in length.



If these two conditions are true, then every subsequent value inserted into the column will be truncated to 128 characters, if greater than 128 in length.

If the first value inserted into the column is greater than 128 characters, then no subsequent truncation occurs.



CR:636518
CR Number:   636518
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   6.5 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Under special circumstances invocation of CallableStatement.execute() can

lead to incorrect protocol data to be generated. The dataserver will

reject such protocol data with error 3814/16/2.



CR:636584
CR Number:   636584
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 12 Aug 2010 Fixed
Description
ODBC Driver by Sybase: RDO application displays ASE numeric type as money.
Workaround Description
 WorkAround:

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

You can use ADO to resolve, but this customer has too many applications to convert in teh time they need.



CR:636954
CR Number:   636954
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2011 Not reproducible with latest version of the product available as of Resolution Date
Description
dbopen() returns unknown os error 18446744073709551615 for 64bit db-library application when using a host name in the interfaces file > 32 characters.



CR:637213
CR Number:   637213
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When using Microsoft SSIS [from SQL Server Business Intelligence Development Studio 2005] and inserting data from flat table to an ASE target, using ASE OLE DB Provider, and the ASE target has an identity column, the insert column list omits first column and either NULL value is inserted, or error is thrown in the SSIS application due to attempt to insert null value in column that doesn't allow null values.
Workaround Description
 WorkAround:

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

I can use a SQL Command and then select by the columns that will insert:



"select dep_relation, client_dep_relation, last_name, first_name from members2"



CR:637273
CR Number:   637273
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 8 02 Dec 2010 Fixed
auriga fs2 02 Dec 2010 Fixed
Description
ADO.NET: The Scale or Precision may be not be set when recasting AseParameter class as IDbDataParameter.
Workaround Description
 Use AseParameter only



CR:637886
CR Number:   637886
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP100 26 Feb 2013 Fixed
15.7 ESD#8 27 Feb 2013 Fixed
15.7 ESD#3 14 Mar 2013 Fixed
Description
ODBC Driver by Sybase: Some queries with left outer joins return char(n) column data with whitespaces trimmed.
Target Version
 15.7 ESD#8
Workaround Description
 WorkAround:

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

I haven't found a workaround - the ASE is forcing this field to return as VARCHAR -

even if I convert the field in the query.



CR:638397
CR Number:   638397
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Aug 2010 Fixed
Description
When OpenSwitch is configured for non concurrent CM

(COORD_TIMEOUT = 0) and when CM application is

terminated, OpenSwitch wrongly decrements the

no. of coordinators twice.



CR:638658
CR Number:   638658
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 8 1024 02 Dec 2010 Fixed
Description
ODBC Driver by Sybase: Connections to MainframeConnect DB2 Access Service sends unrecognized sp_drv_typenfo stored procedure, resulting in errors.
Workaround Description
 WorkAround:

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

There is no workaround for the ASE ODBC Driver other than to not use it.



CR:638744
CR Number:   638744
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   7.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Improve NULL support for BIT Datatype with in Jconnect.
Workaround Description
 This is the work around.

But if you want the old jconn3.jar behavior use

jconn3.jar.



CR:638782
CR Number:   638782
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 8 1024 02 Dec 2010 Fixed
Description
ODBC Driver by Sybase: Semicolons in RSP calls to the mainframe are causing DC/zOS failure.
Workaround Description
 WorkAround:

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

No way to get around this problem.



CR:638917
CR Number:   638917
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2010 Fixed
Description
In a concurrent CM and network glitch case, OpenSwitch doesn't

maintain its internal CM list thereby notifications won't be

sent properly to the the CM in the list which is active.



CR:638962
CR Number:   638962
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#9 20 Mar 2011 Fixed
Description
OLE DB Provider by Sybase: Multiple versions of the OLEDB Provider cannot be installed on the same machine.



CR:638974
CR Number:   638974
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Solaris
Original Version:   6.5 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect driver to support Uppercase UTF8



CR:638994
CR Number:   638994
Product Name:   SDK
Product Component:   .Net
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   Coral8v5.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2010 Fixed
Description
.NET3 SDK in a web service application gets exception:

System.ArgumentException: exePath must be specified when not running inside a stand alone exe.



CR:639034
CR Number:   639034
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Solaris
Original Version:   15.0 ESD#28
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
FR: the ability to specify the TMPDIR on unix platforms for isql so that they have the option to shut off OS buffering.



CR:639096
CR Number:   639096
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
auriga fs1 02 Dec 2010 Fixed
15.5 ESD 8 02 Dec 2010 Fixed
Description
OLE DB Provider by Sybase: Retrieving text\image data containing NULL entries using ADODB.Recordset.MoveNext may suffer from poor performance



CR:639470
CR Number:   639470
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 10 31 Jan 2011 Not reproducible with latest version of the product available as of Resolution Date
Description
ADO.NET: Virtual memory used and not released when Client perform open connection, execute query, read results and close connection in a tight loop.



CR:639664
CR Number:   639664
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD 6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2011 Fixed
06 Dec 2010 Fixed
25 Jan 2011 Fixed
08 Feb 2011 Fixed
17 Apr 2011 Fixed
27 Jun 2011 Presently Not Targeted For Any Future Release Of This Product
Description
CTLIB: In deferred asynchronous mode, a completion callback routine should only be called after ct_poll() has been called.



CR:639715
CR Number:   639715
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 ESD#3 28 Mar 2012 Fixed
Description
ADO.NET: Cannot connect if Windows regional setting is set to "Turkish"
Workaround Description
 WorkAround:

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

Don't use literal string "UID" for user name, use "uid", or "User ID", etc...



CR:639816
CR Number:   639816
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
auriga 02 Dec 2010 Fixed
15.5 ESD 8 02 Dec 2010 Fixed
Description
ADO.NET: The behaviour of the method DataReader.read() in ADO.NET 2.0 provider has changed when there is a mismatch between data in the row read and the buffer allocated. The System.OverFlow execption is raised sooner preventing accessing further rows.



CR:639998
CR Number:   639998
Product Name:   SDK
Product Component:   C/C++
Status:   Open
OS:   all
Original Version:   4.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
C8SubscriberGetNextMessage() Error number: -4000 Error: exception while receiving messages



CR:640000
CR Number:   640000
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Solaris
Original Version:   ESD2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
HOSTPROC is the Open Switch not the the client.

Where as the Open Switch is acting like a client to the ASE

the value HOSTPROC is picking up the Open Switch.



We need to have an option where as the value for HOSTPROC is the true client process and

not OpenSwitch 15.1, feature request to support jConnect HOSTPROC connection property.



Currently, when customer looks at jConnect process going through OpenSwitch from sysproccesses, they see the hostprocess column populated by the OpenSwitch connection proccess ID instead of the jConnect HOSTPROC connection property:

client.
Target Version
 15.1



CR:640175
CR Number:   640175
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Oct 2010 Fixed
Description
OLE DB Provider by Sybase: Use of ADODB::FieldPtr->PutValue under ADODB::_RecordSet using ASEOLEDB with connection property UseCursor=1 could lead to Multiple-step OLE DB operation generated errors.



CR:640357
CR Number:   640357
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   6.5 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The message handler after jConnect6.0.5 ESD#10 ignores the duplicate key error of proxy table with a direct_connect class(Oracle). An exception is not caused within a Java program.

The duplication key error number of Oracle is "1." However, error number"1" is reserved at CT-Lib. jConnect will ignore error number"1."



CR:640657
CR Number:   640657
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Windows 2000
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2010 Fixed
Description
Upgrade to Visual Studio 2005/2008 compiler

============================================

You might notice similar warnings when

compiling your application with compiler version

14.00.50727.42 and linker:8.00.50727.42. Take

actions to correct these warnings.



Message: 'This function or variable may be unsafe.

Consider using strcpy_s instead. To disable deprecation,

use _CRT_SECURE_NO_DEPRECATE. See online help for details



CR:640936
CR Number:   640936
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   Linux
Original Version:   15.5 ESD 6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Open Server and Open Switch is acting like a client to the ASE

the value HOSTPROC is picking up the Open Switch or the Open Server Application such as ctos.



We need to have an option where as the value for HOSTPROC is the true client process and

not OpenSwitch 15.1, feature request to support jConnect HOSTPROC connection property.



Currently, when customer looks at jConnect process going through OpenSwitch from sysproccesses, they see the hostprocess column populated by the OpenSwitch connection proccess ID instead of the jConnect HOSTPROC connection property:

client.
Target Version
 To Be Determined



CR:641141
CR Number:   641141
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2010 Fixed
Description
Upgrade to Visual Studio 2005/2008 compiler

===========================================

You might notice similar warnings when compiling on

Visual Studio environment. Take actions to

correct these warnings in your application.



warning C4996: 'strdup' was declared deprecated

C:\Program Files\Microsoft Visual Studio 8\VC\include\string.h(205) :

see declaration of 'strdup'

Message: 'The POSIX name for this item is deprecated. Instead,

use the ISO C++ conformant name: _strdup. See online help for details.'



CR:641150
CR Number:   641150
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#8 1022 24 Sep 2010 Fixed
Description
ODBC Driver by Sybase: Statement batches, with semicolon statement delimiters, are incorrectly parsed by the ODBC driver, resulting in errors.
Workaround Description
 There is no workaround other than to use OEM driver.



CR:641224
CR Number:   641224
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2010 Fixed
Description
OLE DB Provider by Sybase: The OLE DB Provider from 15.5 release does incorrect conversion for CP932 to EUCJIS conversions. Same issue applies to the ODBC Driver.



CR:641476
CR Number:   641476
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 8 02 Dec 2010 Fixed
Description
ODBC Driver by Sybase: Use of ADO Data Control with DataGrid in Visual Basic 6.0 not displaying data
Workaround Description
 WorkAround:

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

There isn't a workaround, OLE DB works with Static, but there are other undisclosed issues, and customer prefers ODBC and is under a time crunch.



CR:641676
CR Number:   641676
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2010 Fixed
Description
Clients upon response timeout switches to sec. ASE

when it's not supposed to in a non Mutual Aware OSW.



CR:642218
CR Number:   642218
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Sep 2010 Fixed
Description
OpenSwitch built with OCS 15.5 ESD#7 core dumps in blk__make_bulkcmd()

when CTLib sample program uni_blktxt is executed. This is Linux specific.



CR:642595
CR Number:   642595
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Under some cases where OpenSwitch operations are CPU bound especially

when handling the [ASE] failures, CM applications falsely detects

the network between CM and OpenSwitch as faulty and closes the

connections even though the network is healthy.



If you turn on

DEBUG = f in OpenSwitch config file, you will see msgs. in the

OpenSwitch log file as below :



coord_rem: CM being removed, cmid: 1, appname is asriniva-sun:2017:p

coord_rem: The number of Coordination Modules connected to the OpenSwitch is 0.

coord_rem: Closing the Coordination Module connection from the OpenSwitch side since the network connectivity between OSW and Coordination Module could be down.



CR:643026
CR Number:   643026
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Open
OS:   Windows 2003
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Tested and reproduced with:

Workspace 2.5 Database Development

OS: Windows 2003 SP2



When editing big stored procedure script and saving changes back to database via Database Explorer, Workspace hangs



CR:643249
CR Number:   643249
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2010 Fixed
17 Oct 2010 Fixed
26 Jan 2011 Fixed
Description
CTLIB: event notifications might be lost when multiple event notifcations arrive at the same time.



CR:643501
CR Number:   643501
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2010 Fixed
Description
CM applications might throw an assertion failure

and core dump when run with debug libraris of

Open Client with the message.



assertion failed, file 'generic/ct/ctconpr.c' line 3481

Abort (core dumped)



CR:643586
CR Number:   643586
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP120 22 Nov 2013 Fixed
15.7 SP123 08 Nov 2013 Fixed
Description
ADO.NET/ODBC/OLE DB: Login failure encountered with ChangePassword connection property when the old password is null.
Workaround Description
 WorkAround:

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

Manually do it from ISQL



CR:643589
CR Number:   643589
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Tested and reproduced with:



Organic OLEDB Provider 15.5 ESD#5 and ESD#7

SQL Server 2000 with Data Transformation Services

ASE 15.0.3

OS: Windows 2003



Organic OLEDB Provider leaks memory when dealing with big amounts of data in SQL Server 2000 Data Transformation Services. Issue does not occur if using Organic ODBC Driver or old DataDirect OLEDB Provider instead.
Workaround Description
 Use Organic ODBC Driver 15.5 ESD#5 or old DataDirect OLEDB Provider.



CR:643601
CR Number:   643601
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Attempting to login to ASE with a jconn3.jar fails with error, JZ0P4.



CR:643714
CR Number:   643714
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2011 Not reproducible with latest version of the product available as of Resolution Date
Description
Core dump when doing a bcp in and the ASE and the ASE has set "select into" turned off,

BCP will generate a exception and a core file there may be other ways to reproduce this

issue I get a segv if the "-Y" parameter is used on the command.



looking for BCP to handle the condition better than it is. It really should

not stack trace or core. We would or at least be looking for an errors message.



NOTE: looking for BCP to handle the condition better than it is. It really should

not stack trace or core. We would be at least be looking for an errors message.

Need to look at the BCP error handaling in the CS_PUBLIC server messages
Target Version
 15.5 ESD 7



CR:643718
CR Number:   643718
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2010 Fixed
28 Oct 2010 Fixed
Description
COMNLIB: When converting a floating number with an exponential part into a string, some comnlib routines concatenate ".0" to the resultant string. For example, these routines convert 4e+132 to "4e+132.0". The correct result should be "4.0e+132".



CR:643938
CR Number:   643938
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2010 Fixed
23 Nov 2010 Fixed
23 Nov 2010 Fixed
Description
jConnect: When ENABLE_BULK_LOAD is true, executeUpdate() on statement with no parameters fails.
Workaround Description
 WorkAround:

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

For customer there really isn't since they use pooled connection and don't want to change code to use multiple pools.

They run their transaction under the same instance.



CR:644133
CR Number:   644133
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2010 Fixed
Description
Client connections fail to connect to secondary ASE

upon failure of primary ASE because of the failure

in pool_get_server() function.



This might happen when OpenSwitch is configured for Mutual Aware Support

and CFG_STORAGE is not set in the OpenSwitch configuration file.



CR:644331
CR Number:   644331
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)
12 Oct 2010 Not a Bug
Description
Gateway handler not closing Socket if Transaction Abend before the Takesocket cal,

Leaving DC connections Hanging.



CR:644825
CR Number:   644825
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Unknown
Original Version:   auriga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2013 Fixed
28 Jun 2013 Fixed
Description
COMNLIB: Allow conversion of non-unicode characters if CS_DATAFMT 'format' element has CS_FMT_SUBS_ILL_CHAR set.



CR:645006
CR Number:   645006
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2010 Fixed
Description
Open Server state errors in Concurrent CM setup. When

CM app's network is disconnected, state errors are noticed

in OpenSwitch log file.



spid 16: srvlib_error: N16236: srv_sendinfo(): State error (0x5a024)



CR:645780
CR Number:   645780
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   7.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add a method on Jconnect Jdbc connection object to see transaction status.



CR:646561
CR Number:   646561
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   MacOS
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Request Open Client SDK 32 bit be ported over to 64 bit for the MacOS. *** Currently no plans to do this port ***



CR:647085
CR Number:   647085
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Nov 2010 Fixed
13 Dec 2010 Fixed
Description
jConnect: When using BigDateTime column, specific date and time columns are returned incorrectly.
Workaround Description
 WorkAround:

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

JCONNECT_VERSION = 6 (only if you don't need 7 features)



CR:647214
CR Number:   647214
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Nov 2010 Duplicate
Description
Using Cluster Edition and enabling HAFailover on a CallableStatement with registered output parameters fails with JZ006, JZ0EM End of Data after failover





Tested and reproduced using:



- jConnect (TM) for JDBC(TM)/6.05(Build 26655)/P/EBF18285/JDK14/Thu Sep 9 12:51:54 2010

- Adaptive Server Enterprise/15.5/EBF 17798 Cluster Edition ESD#1/P/RS6000/AIX 5.3/asear155/2495/64-bit/FBO/Thu May 27 02:16:42 2010

- IBM Websphere WAS 6.1.0.23 (in customer's case - we are able to reproduce it outside Websphere)





When using com.sybase.jdbc3.jdbc.SybConnectionPoolDataSource, if failover occurs over a CallableStatement(), jConnect throws "JZ006: Caught IOException: java.io.IOException: JZ0EM: End of data." when CallableStatement.execute() is re-issued and no CallableStatement.prepareCall() is re-issued right before the execute().

Customer hits this issue in WebSphere. We were able to reproduce the issue outside WebSphere.
Workaround Description
 Needs to include a new prepareCall() before CallableStatement.execute() inside the JZ0F2 Failover Exception.



CR:647223
CR Number:   647223
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Using Cluster Edition and enabling HAFailover on a CallableStatement with registered output parameters fails with JZ006, JZ0EM End of Data after failover
Workaround Description
 re. prepare the Callable statement on the new failedover connection.



CR:647500
CR Number:   647500
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 8 1024 11 Nov 2010 Fixed
Description
Calling RSP on mainframe in transfer command or singly direct to DC/zOS is causing failure.



ASE ODBC Driver is removing ";" characters used to delimit the RSP command when using the 'WITH DATA' clause:



Send this:



USE PROCEDURE WITH DATA RSPS3C; 'YO!!!!';

ASE ODBC removes semicolons and failure occurs:



[Sybase][ODBC Driver][Adaptive Server Enterprise][VENDORLIB] Vendor Library Error: RSP Completion Code = MYERCODE <DB2>"

[Sybase][ODBC Driver][Adaptive Server Enterprise] ERROR WITH CALL TO OPENPIPE - SPRC CODE: EOF



The semi-colon after "RSPS3C" needs to remain in place for the call to succeed.
Workaround Description
 WorkAround:

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

No way to get around this problem.



CR:647508
CR Number:   647508
Product Name:   Open Client
Product Component:   cslib
Status:   Open
OS:   Linux
Original Version:   15.0 ESD#22
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Unexpected data truncation happens when ESQL/C application inserts TEXT variables with roman-latin characters in an UTF8-based locale.



CR:647652
CR Number:   647652
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 01 31 Aug 2011 Duplicate
Description
MFC Server Option for CICS should support LU62 style pre-set security under TCP.



CR:647865
CR Number:   647865
Product Name:   SDK
Product Component:   Java
Status:   Open
OS:   all
Original Version:   4.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Bad Javadocs for AdapterSdk and RpcSdk



CR:648015
CR Number:   648015
Product Name:   SDK
Product Component:   Java
Status:   Open
OS:   RH
Original Version:   4.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Sample embedded Java RPC program "TestRpc" has several bugs in it



CR:648019
CR Number:   648019
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for some automatic way for Provider to copy un-managed component
Workaround Description
 WorkAround:

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

Manual xcopy of the sybdrvado20.dll after building x86 or x64 solution (keep in mind it's the same solution so a forceable setting of copying the dll has to be manually changed each time they switch the config mode of the solution)



CR:648061
CR Number:   648061
Product Name:   SDK
Product Component:   Java
Status:   Closed
OS:   all
Original Version:   4.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Nov 2010 Fixed
Description
Fixed a memory leak when using the embedded Java RPC/in-process adapter feature



CR:648072
CR Number:   648072
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 8 1024 16 Nov 2010 Fixed
15.5 ESD 8 1024 17 Nov 2010 Fixed
Description
Calling RSP on mainframe in transfer command or singly direct to DC/zOS is causing failure.



ASE ODBC Driver is removing ";" characters used to delimit the RSP command when using the 'WITH DATA' clause:



Send this:



USE PROCEDURE WITH DATA RSPS3C; 'YO!!!!';

ASE ODBC removes semicolons and failure occurs:



[Sybase][ODBC Driver][Adaptive Server Enterprise][VENDORLIB] Vendor Library Error: RSP Completion Code = MYERCODE <DB2>"

[Sybase][ODBC Driver][Adaptive Server Enterprise] ERROR WITH CALL TO OPENPIPE - SPRC CODE: EOF



The semi-colon after "RSPS3C" needs to remain in place for the call to succeed.
Workaround Description
 WorkAround:

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

No way to get around this problem.



CR:648077
CR Number:   648077
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 10 13 Jun 2011 Fixed
Description
OLE DB Provider by Sybase: Specified case is not valid error occurs when opening the SQL Server Import/Export Wizard in Microsoft SQL Server 2008.
Workaround Description
 WorkAround:

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

If you use MSSQL Server 2008 there is no workaround.



CR:648483
CR Number:   648483
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#24
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#26 20 Mar 2011 Bundled Request
Description
jConnect: jConnect 6.05 reports errors when calling getSchemas on DatabaseMetaData.
Workaround Description
 WorkAround:

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

You can modify the script like the 6.05 , keeping in the CATALOG field and it should work - look at CR details.



CR:648520
CR Number:   648520
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#24
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0 ESD#10 04 May 2011 Fixed
auriga 05 May 2011 Fixed
6.5 ESD#27 04 May 2011 Fixed
auriga 04 May 2011 Fixed
auriga 05 May 2011 Fixed
Description
jConnect: When calling getProcedureColumns, parameter names greater than length 30 are truncated at 30.
Workaround Description
 WorkAround:

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

In the sproc script, for the text of sp_jdbc_getprocedurecolumns, this line is of interest:



COLUMN_NAME = convert(varchar, c.name),"



If changed to



COLUMN_NAME = convert(varchar(255), c.name),"



The truncation stops. Since identifiers such as the parameter name are limited in length to 128 characters, this can be adjusted to varchar(128).



CR:648586
CR Number:   648586
Product Name:   Other - Docs: Connectivity
Product Component:   Other - Docs: Connectivity
Status:   Open
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SDK Organic ODBC driver follows ASE TSQL's standard of using default column property of not NULL



CR:648858
CR Number:   648858
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   all
Original Version:   15.7 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2011 Fixed
Description
NETLIB: Interfaces files now support up to 64 master/query entries per server.



CR:648865
CR Number:   648865
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Dynamically prepared SQL is not executable after HAFailover in the Cluster Edition. This data is currently lost and the application program must re-prepare the data before execution on the HAFailover's connection.



CR:649056
CR Number:   649056
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 9 8001 20 Mar 2011 Fixed
Description
ODBC Driver by Sybase: SQLGetInfo(SQL_USER_NAME) fails when executed against the MainframeConnect DirectConnect for z/OS TRS access service.
Workaround Description
 WorkAround:

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

This doesn't stop execution, just an annoyance.



CR:649356
CR Number:   649356
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 9 04 Mar 2011 Fixed
Description
ADO.NET: Error "invalid amount of parameters" received when sending certain SQL such as "create procedure" or "create rule".
Workaround Description
 *** Thu Jan 06 2011 12:45:04 GMT-0700 (Mountain Standard Time) *** pvero ***

We find if NamedParameters=false on connection string or on AseCommand, the exception isn't thrown and executions succeed. However, if customer is coding in a generic fashion where they are targeting various backend databases, this isn't going to be a viable solution.





WorkAround:

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

create procedure [sp_createProc] @p1 int as select * from ado_table where c1 = @p1



create procedure dbo.sp_createProc @p1 int as select * from ado_table where c1 = @p1



There is no way to workaround the create rule syntax



CR:649368
CR Number:   649368
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to send actual query on Linked Server OPENQUERY command to retrieve metadata instead of a SELECT with the "Where 1=2" clause.
Workaround Description
 WorkAround:

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

This customer has decided to use different syntax on Linked Server which does a pssthrough type of query:



EXECUTE ('SQL Statement') at LinkedServer



This is much better and provides least bit of problems. We feel this is the better solution, but CR was logged in case there is some need in the future for this.



CR:649645
CR Number:   649645
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 8 29 Apr 2013 Fixed
Description
ODBC driver fails to connect using encrypted password on some unix platforms.



CR:649935
CR Number:   649935
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows Vista
Original Version:   15.5 ESD 7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The SDK 15.5 ship additional dll's for SSL support CSI-OpenSSL CSI-Crypto 2.6,

sbgse2.dll, sybcsi_certicom_fips26.dll, sybcsi_core26.dll and sybcsi_profiler26.dll.



Request to remove the static runtime dependency on the SSL support dll's for all drivers when no SSL is needed.





--------------------------------------华丽的分割线-------------------------------------------------------------------------

Sybase SQL Anywhere数据库恢复工具ReadASADB:

之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具: ReadASADB。
此工具支持ASA v5.0, v6.0, v7.0, v8.0, v9.0, v10.0, v11.0, v12.0, v16.0, v17.0等版本。
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具。
恢复Sybase SQL Anywhere的工具在国内处于领先水平。

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,16.x,17.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使用介绍

Sybase SQL Anywhere数据库恢复工具ReadASADB适用场景

各种误操作:

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

Sybase SQL Anywhere数据库恢复工具ReadASADB的应用场景:

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
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


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

Sybase ASE数据库恢复工具READSYBDEVICE:

一个不依赖数据库管理系统、直接从Sybase数据库设备文件上提取数据的业内领先的恢复工具!
能够从损坏的Sybase ASE设备文件(.dat)上提取数据的非常规恢复工具。

Sybase ASE数据库恢复工具READSYBDEVICE的主要功能:

  1. 被勒索病毒加密数据文件及备份文件情况下的恢复;
  2. 系统崩溃只剩下数据文件的情况下的恢复,甚至数据库文件不存在而只有损坏的备份文件情况下的恢复;
  3. 因断电、硬盘坏道等造成数据库文件损坏情况下的恢复;
  4. delete数据恢复、误update数据恢复、误删除表(drop)恢复、误truncate表恢复 等;
  5. 各种Sybase内部系统表损坏、索引错误的修复;
  6. master数据库损坏而无法正常运行情况下的恢复;
  7. Sybase数据库被标记为可疑,不可用等情况的恢复;
  8. Sybase数据库中数据文件内部出现坏块情况下的恢复;
  9. Sybase数据库无数据文件但有日志文件的情况下的恢复;
  10. Sybase数据库只有数据文件无任何日志文件的情况下的恢复;
  11. Sybase数据文件被误删除情况下的碎片提取恢复;
  12. 磁盘阵列上的Sybase数据库被误格式化情况下的数据库恢复;
  13. 数据库sysobjects等系统表损坏无法正常应用情况下的恢复;
  14. Sybase数据库还原数据库出现失败情况下的恢复;
  15. Sybase数据库只剩下损坏的备份文件情况下的恢复。

Sybase ASE数据库恢复工具READSYBDEVICE支持的版本:

Sybase ASE 11.0.x,11.5.x,11.9.x,12.0.x,12.5.x,15.0.x,15.5.x,15.7.x,16.0.x


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

SQL Server数据库恢复工具SQLRescue:

一个不依赖数据库管理系统、直接从SQL Server数据库文件上提取数据的业内领先的恢复工具!
能够从损坏的SQL Server数据库文件(.mdf)上提取数据的非常规恢复工具。

SQL Server数据库恢复工具SQLRescue的主要功能:

  1. 系统崩溃只剩下数据文件的情况下的恢复,即无日志文件或者日志文件损坏情况下的恢复;
  2. 断电导致数据库文件损坏情况下的恢复;
  3. 硬盘坏道造成数据库损坏情况下的恢复;
  4. 数据文件内部存在坏页情况下的恢复;
  5. 企业管理器误删除数据表记录,管理软件误删除数据表记录的恢复;
  6. 并闩锁错误、格式化、误删除后导致软件不能使用的情况;
  7. 无法读取并闩锁页sysindexes失败情况下的修复;
  8. 数据文件被误删除情况下的碎片提取恢复;
  9. 系统表损坏、索引错误、误删除数据库表、删除记录的数据找回;
  10. master数据库损坏而无法正常运行情况下的恢复;
  11. 数据文件无法附加情况下的数据恢复;
  12. 数据库被标记为可疑,质疑,不可用等情况的恢复;
  13. 数据库sysobjects等系统表损坏情况下的恢复;
  14. 数据被误(drop、delete、truncate)删除表数据的恢复,误update后的数据恢复等;
  15. 还原时报一致性错误,错误823等情况下的数据恢复,各种错误提示的数据库文件修复;
  16. 数据库被误格式化等情况下的数据库恢复;
  17. 日志收缩造成数据库损坏情况下的恢复;
  18. 仅剩损坏的备份文件情况下的恢复。

SQL Server数据库恢复工具SQLRescue技术特点:

只要SQL Server数据库的数据文件存在,我们就有办法帮您从数据文件中找回重要数据。
  1. 从数据文件中直接恢复数据
  2. 不能附加时直接恢复数据并生成新的数据库
  3. 系统表损坏的数据库修复
  4. 快速修复SQL 823错误、连接中断错误

SQL Server数据库恢复工具SQLRescue支持的版本:

Microsoft SQL Server 7.0, 2000, 2005, 2008, 2008R2, 2012, 2014, 2016, 2017,2019。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------