远程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:486528
CR Number:   486528
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2007 Fixed
18 Mar 2008 Fixed
Description
DRIVERS: Drivers are erroneously being looked up in the 'config' directory instead of 'lib' directory in absence of a library path.



CR:486629
CR Number:   486629
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Inserting or updating columns of data type datetime fail with Linked Server.



CR:486684
CR Number:   486684
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#20
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2008 Duplicate
Description
OLE DB Provider by Sybase: Executing a stored procedure via OpenQuery() on a Linked Server fails.



CR:486685
CR Number:   486685
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#22 04 Feb 2008 Duplicate
Description
OLE DB Provider by Sybase: Memory corruption with SSIS and preview Table List.



CR:486687
CR Number:   486687
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#22 04 Feb 2008 Duplicate
Description
OLE DB Provider by Sybase: Get error when previewing SQL Command in SSIS.



CR:486699
CR Number:   486699
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#14 08 Dec 2013 Fixed
Description
ADO.NET: Request to support System.Transaction.TransactionScope interface.



CR:486887
CR Number:   486887
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Windows 2000
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jul 2008 Fixed
Description
OpenSwitch Manager gets exception in tokenizeVersionString while connecting to OpenSwitch running on Windows.



CR:486916
CR Number:   486916
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Enabling quoted identifiers in connection string produces syntax errors during command execution.



CR:486961
CR Number:   486961
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2007 Fixed
Description
Parameters were reported as being SQL_PARAM_INPUT even though some were defined as output or input_output.



CR:486962
CR Number:   486962
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2007 Fixed
Description
INOUT/OUT parameters were reported as being SQL_PARAM_INPUT when parameter name contained the word 'last'.



CR:486963
CR Number:   486963
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Dec 2007 Fixed
Description
When a Sybase stored procedure had a comment that contained the

keyword "AS", all parameters were reported as being SQL_PARAM_INPUT

when calling SQLProcedureColumns, even when some were defined as

output or input_output.



CR:486989
CR Number:   486989
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Select, Insert or Update from Linked server fails for char columns larger than 255 in length.



CR:486995
CR Number:   486995
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Sybase.AdoNet2.AseClient.dll version 1.15.192.0.



Using a SqlDataSource bound to a GridView with parameters in the data source gives AseException "COUNT field incorrect"



CR:487075
CR Number:   487075
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows XP
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Dec 2007 Fixed
Description
Fail to execute script generated by RepServer Multimark wizard.



CR:487252
CR Number:   487252
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#20
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jul 2008 Presently Not Targeted For Any Future Release Of This Product
Description
Open Client/Server crash in free() under heavy load



CR:487278
CR Number:   487278
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2010 Fixed
14 Sep 2010 Fixed
Description
Examples: Open Server sample program CTOS sends an unqualified select statement when handling a bulk copy request from a DB-Library client.



CR:487281
CR Number:   487281
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jul 2008 Fixed
21 Jul 2008 Fixed
01 Sep 2008 Fixed
Description
OpenSwitch sends an unqualified select statement when handling a bulk copy request from a client.



CR:487383
CR Number:   487383
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: When quoted identifiers are enabled for Microsoft SQL Server Linked Server connection to ASE, executing any statement fails.



CR:487418
CR Number:   487418
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2008 Fixed
08 Sep 2008 Fixed
Description
Enhance Mutual Aware error in configuration detection



CR:487531
CR Number:   487531
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#12 08 Dec 2013 Fixed
1.1 ESD#22 08 Dec 2013 Fixed
Description
ADO.NET: Invalid number of parameters error occurs when using Named Parameters and the same parameter is used more then once in the SQL Statement.



CR:487552
CR Number:   487552
Product Name:   Database Development
Product Component:   Cheat Sheets
Status:   Closed
OS:   Windows 2000
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Dec 2007 Fixed
Description
NullPointerException is thrown when switching to database Perspective.



CR:487555
CR Number:   487555
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Dec 2007 Fixed
Description
From the ASA Table/view editor, if the user completes some operation on the

permission page, switches to another page, saves, takes no further action, and

closes the editor, no warning dialog appears for saving the dirty editor. If the

user switches to another editor and switches back, the revert action is disabled

for the dirty editor.



CR:487584
CR Number:   487584
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#13 08 Dec 2013 Fixed
Description
ADO.NET: Request to add support for AddWithValue(parameterName, value) method on AseParameterCollection class.



CR:487614
CR Number:   487614
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Dec 2007 Fixed
Description
For ASE, UDT should not be loaded under data type folder.



CR:487670
CR Number:   487670
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Calling CommitTrans on ADO connection using MSDataShape produces Unexpected error (ACCESS_VIOLATION).



CR:487693
CR Number:   487693
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Generic
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2008 Fixed
Description
The default values of the variable are not shown correctly in the Stored Procedure Editor.



CR:487792
CR Number:   487792
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2010 Presently Not Targeted For Any Future Release Of This Product
29 Jul 2008 Fixed
Description
OpenSwitch does not provide end to end password encryption



CR:487811
CR Number:   487811
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#13 08 Dec 2013 Fixed
Description
ADO.NET: Unsupported parameter type error produced when passing Null parameter values to AseParameterCollection.Add(parameterName, value) method.



CR:487815
CR Number:   487815
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Dec 2007 Fixed
Description
When the user clicks on the 'Go to workbench' button of the Welcome page, the

Database Development perspective opens and should show the cheat sheet view with

'Getting Started w/ Database Development.'



CR:487952
CR Number:   487952
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 May 2014 Third Party Problem
Description
OLE DB Provider by Sybase: When Microsoft SQL Server is started under its own Windows account, executing statements on Linked Server connection to ASE fail with Access denied error.



CR:487980
CR Number:   487980
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#13 08 Dec 2013 Fixed
1.1 ESD#22 08 Dec 2013 Fixed
Description
ADO.NET: If CommandTimeout is set to 30 seconds, the actual timeout lasts only 10 seconds. Other timeout values behave correctly.



CR:488253
CR Number:   488253
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 01 18 Jun 2008 Fixed
Description
No message is returned when application security prevents SYGH from starting. The problem occurs when RACF facilities (such as the APPL class) prevents CICS from starting a task. See "LISTENER.HTM" document for details.



CR:488254
CR Number:   488254
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Nov 2008 One-off Provided
16 Jul 2008 Fixed
Description
OpenSwitch gives error message when entered text size is more than its configured text size.
Workaround Description
 None.



CR:488255
CR Number:   488255
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 May 2014 Fixed
08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: On Linux platform, ODBC connections terminated by ASE may not timeout.



CR:488285
CR Number:   488285
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Apr 2009 Duplicate
Description
Request for Data Designer Extensibility (DDEX)



CR:488286
CR Number:   488286
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Request for more detailed error information in the ErrorInfo collection.



CR:488326
CR Number:   488326
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#21
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2008 Fixed
13 Jul 2012 Reservation Made
12 Aug 2012 Fixed
Description
SRVLIB: In the non-threaded libraries, calling sp_terminate() with "immediate" option can result in a core dump at sybtcp_write(). In the threaded libraries, calling the same procedure may not complete immediately.



CR:488417
CR Number:   488417
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2008 Fixed
Description
jConnect: Request for property to provide failover Host:Port pairs for DataSource.



CR:488439
CR Number:   488439
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows XP
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2008 Fixed
Description
The values assigned to a variable of type money does not change during the fetch loop during procedural object debugging.



CR:488519
CR Number:   488519
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request full implementation for ISupportErrorInfo



CR:488559
CR Number:   488559
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Solaris
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Mar 2008 Fixed
14 Jan 2008 Fixed
Description
jConnect: Under JRE 1.5, performance of reading UNIVARCHAR is poor.
Workaround Description
 None !



CR:488564
CR Number:   488564
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Tracing of OLEDB provider does not work as documented in build 192. Works fine using earlier build 186 of esd 10.



CR:488566
CR Number:   488566
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#12 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Select, Insert or Update from Linked server fails for binary columns.



CR:488588
CR Number:   488588
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 01 19 Jun 2008 Fixed
Description
ISQLCICS will ASRA if there are not Key Entries in SYGWLKEY in SYGWXCPH
Workaround Description
 Just Add Key Enteries to the SYGWLKEY Macro.



CR:488673
CR Number:   488673
Product Name:   Open Server-Doc
Product Component:   Server-Library/C Reference Manual
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 30 Jan 2009 Fixed
Description
Document defaults for SRV_T_NOTIFYPND in srv_thread_props



CR:488759
CR Number:   488759
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2008 Fixed
12.5.1 ESD#24 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Executing a stored procedure that returns numerous DONEINPROC tokens results in excessive memory usage on the client proportional to the number of tokens in the result.
Workaround Description
 *** Friday, January 11, 2008 12:41:03 PM *** pvero ***

On my test I was able to call dbcc traceon(292) and DIPs stopped being sent - I think there's a bug on ASE 15.0.X in that the sp_configure 'send doneinproc tokens', 0 doesn't work - ASE still sends them. Currently, customer has ASE 15.0.1 ESD#2 AIX 64 bit, EBF 14204, and -T292 wasn't working. They'll try dbcc traceon(292) today.



CR:488853
CR Number:   488853
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2008 Fixed
03 Jul 2008 Fixed
25 Jun 2008 Fixed
03 Jul 2008 Fixed
09 Jul 2008 Fixed
09 Jul 2008 Fixed
Description
NETLIB: pre-12.5.1 Open Client and 12.5.1 Open Client ESD18 and earlier may not connect successfully via SSL to Open Server 15.0 and Open Server 12.5.1 ESD19 and later.



CR:488944
CR Number:   488944
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Sep 2008 Fixed
Description
jConnect: jConnect should send literal DATETIME values with 3 nanosec digits for ASE.



CR:489099
CR Number:   489099
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#13 08 Dec 2013 Fixed
1.1 ESD#23 08 Dec 2013 Fixed
Description
ADO.NET: Request to add GetBytes method for character types in AseDataReader class.



CR:489115
CR Number:   489115
Product Name:   Embedded SQL/C-Doc
Product Component:   C Programmer's Guide
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2009 Fixed
Description
Request to add more explanation about declaring two identically named cursors for static cursor in Embedded SQL/C Programmer's Guide.



CR:489228
CR Number:   489228
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: When quoted identifiers are enabled for Microsoft SQL Server Linked Server connection to ASE, executing any statement fails.



CR:489344
CR Number:   489344
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   6.5 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Encrypt/decrypt operations fail with null passwords and 15.0.2 and up servers using the new RSA password encryption algorithms.



CR:489466
CR Number:   489466
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#23 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Crystal Reports Report Wizard fails to create a report using Sybase

ODBC driver. ODBC Driver fails when SQLMoreResults is called after SQLPrepare.



CR:489639
CR Number:   489639
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Unknown
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jun 2008 Fixed
12 Sep 2008 Presently Not Targeted For Any Future Release Of This Product
Description
CTLIB: Issuing a ct_cancel() via Open Server in passthrough mode can result in the client receiving a disconnect when the negotiated packet size is greater than 1024 bytes.



CR:489858
CR Number:   489858
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for examples and documentation to show how to use jConnect with common Transaction Managers in JTA applications.
Workaround Description
 Searcg on the Web shows examples for Oracle and others.



CR:489910
CR Number:   489910
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2008 Fixed
Description
EXAMPLE: README file and 'ctos -h' now reflect the SSL capability of ctos sample program.



CR:489932
CR Number:   489932
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#19 04 May 2010 Fixed
Description
ADO.NET: Application occasionally throws a 'NullReferenceException: Object reference not set to an instance of an object' when an attempt is made to open a new connection.



CR:490019
CR Number:   490019
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Feb 2008 DEFER
Description
When executing the same client code against the production database there is a different result when calling a stored procedure as compared to the development database in the ct environment.



CR:490230
CR Number:   490230
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#5 04 29 May 2008 Fixed
15.0 ESD#2 01 05 Jun 2008 Fixed
Description
Connecting to server using ISQLCICS with a bad password several

times leaves connection open in CLOSEWAIT state and memory

allocated. Occasionally ISQL may hang.
Workaround Description
 NONE execpt for hitting PF3 to term the env



CR:490407
CR Number:   490407
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Feb 2008 Fixed
20 Feb 2008 Fixed
Description
NETLIB: Kerberos security driver may raise segmentation violation in pCSF_gss_display_status() when using Cybersafe GSS libraries.



CR:490418
CR Number:   490418
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
A windows service or replication agent cannot use a system OLEDB datasource due

to a permission error on HKLM\SOFTWARE\Sybase\OLEDB Provider



Full control is needed but a regular user by default only has Read access.



Secondly the application sybdrvadm.exe doesn't properly maintain system and user datasources.



CR:490576
CR Number:   490576
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 01 05 Jun 2008 Fixed
15.0 ESD#2 01 13 May 2008 Fixed
Description
Default application CCSID cannot be changed from 500.



CR:490740
CR Number:   490740
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#23 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: When using ODBC Driver from ADO, updates may fail with "Insufficient key column information error for ASE server setup with case insensitive sort order.



CR:490851
CR Number:   490851
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Feb 2008 Fixed
Description
CTLIB: Password encryption doesn't work with HA failover.



CR:491126
CR Number:   491126
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#16 08 Dec 2013 Fixed
12.5.1 ESD#26 02 May 2013 Fixed
Description
ODBC Driver by Sybase: A Data Connection in Visual Studio using ".NET Framework Data Provider for ODBC" and the Sybase ODBC Driver shows empty table list.



CR:491164
CR Number:   491164
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Insufficient priority to fix
Description
To turn SSL encryption on/off for client applications.



CR:491361
CR Number:   491361
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows XP
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2008 Fixed
Description
NPE pops up when try to change a table name



CR:491532
CR Number:   491532
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#17 25 Mar 2009 Fixed
Description
ADO.NET: When using DbType.String the provider is ignoring case insensitive data.



CR:491536
CR Number:   491536
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Mar 2008 Fixed
13 Apr 2008 Fixed
Description
OpenSwitch crashes in ct_cancel()



CR:491552
CR Number:   491552
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#23 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: If ODBC Driver is connected to Direct Connect back ends, the SQLTables call will fail when the criteria for TableType is specified as "'TABLE', 'VIEW', 'SYSTEM TABLE', 'ALIAS', 'SYNONYM'".



CR:491601
CR Number:   491601
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2008 Fixed
25 Feb 2008 Fixed
Description
ISQL: Help output from isql is not correct syntactically.



CR:491602
CR Number:   491602
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   NA
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 May 2008 Fixed
Description
ISQL: Added a new command line option --help to give verbose isql usage.



CR:491611
CR Number:   491611
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Generic
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Mar 2008 Fixed
Description
Problem: SQL Editor incorrectly reports a syntax error when using derived tables.

Resolution: This has been fixed.



CR:491692
CR Number:   491692
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2008 Fixed
Description
CTLIB: Clients fail to connect to ASE 11.9.x with an error "ct_connect(): protocol specific layer: internal Client Library error: There is a tds state machine error. An illegal tds token sequence was received."
Workaround Description
 Use SDK 15.0 ESD#11 if possible.



CR:491726
CR Number:   491726
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Mar 2008 Third Party Problem
Description
If you specify 2048 bytes to CS_PACKETSIZE in an Open Server application, you may not be able to connect to ASE 15.0.x through the Open Server application.
Workaround Description
 Use CS_PACKETSIZE less than 2048 bytes in the Open Server application if possible.



CR:491800
CR Number:   491800
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Mar 2008 Fixed
27 Mar 2008 Fixed
Description
DBLIB:dbopen() may not return NULL even if login attempt fails under the following conditions:

(1) Use TDS 4.6 or earlier versions;

(2) Connect to an Open Server application;

(3) Use different character sets between the client and the Open Server.
Workaround Description
 To use TDS 5.0, call dbsetversion(DBVERSION_100) or setenv SYBOCS_DBVERSION DBVERSION_100



CR:491801
CR Number:   491801
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Open
OS:   Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature: a configuration option to suspend failover when RCM detect RS is down



CR:491817
CR Number:   491817
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2008 Fixed
27 Feb 2008 Fixed
Description
CTLIB: When mis-functioning server does not mark EOM on cancel attention packet,ctlib application may report an error like "ct_send(): network packet layer: internal Client Library error: State error: trying to write when connection is expecting a read."



CR:492036
CR Number:   492036
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#20
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Apr 2008 Fixed
17 Apr 2008 Fixed
Description
NETLIB: On Windows, ct_cancel() may hang on queries that return lots of data.



CR:492112
CR Number:   492112
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2008 Fixed
01 Jul 2008 Fixed
Description
When OpenSwitch encounters a character conversion error, OpenSwitch does not send any error to the client and then the client hangs up.



CR:492149
CR Number:   492149
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#23 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: In a Microsoft SQL Server Linked Server connection to ASE, executing a select statement can cause the OLE DB Provider to request the same result two times causing poor performance.



CR:492185
CR Number:   492185
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Apr 2008 Not a Bug
Description
COM+ application crashes in ct_exit()



CR:492854
CR Number:   492854
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#23 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: For ODBC Driver connected to Direct Connect DB2 Access Service, binding a parameter with ctype of SQL_C_DEFAULT and sqltype SQL_CHAR results in "Invalid conversion" error during SQLExecute().



CR:493079
CR Number:   493079
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Option to turn off some or all initialization SQL during login phase.



CR:493106
CR Number:   493106
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#13 05 Jun 2008 Fixed
1.1 ESD#23 05 Jun 2008 Fixed
Description
ADO.NET: Incorrect mapping of ASE float data type causes ArgumentOutOfRangeException exception.
Workaround Description
 Workaround:



1> sp_addtype "double", "float"

2> go

Type added.

(return status = 0)



1> create proc sp_double_wa (@p1 double)

2> as

3> return 88

4> go

1>



Test results





C:\Stuff\subcases\asenet\11424892-11\AADALConsole\AADALConsole\bin\Debug>AADALConsole

Class : DeriveParameter

Provider version : 1.15.200.0

Number of parameters derived : 2

Parm [0] DbType: Int32

Parm [1] DbType: Double



Not clear if customer can use this - requires changing the sproc code.



CR:493309
CR Number:   493309
Product Name:   jConnect
Product Component:   Ribo
Status:   Open
OS:   Unknown
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RIBO to generate output to both window and a textfile when selected

"Translate to a file" and "Display translation in a window" in

Menue File -> Preferences.



CR:493387
CR Number:   493387
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2008 Fixed
Description
The driver returned a '369098752' error in xa_prepare.



CR:493394
CR Number:   493394
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2008 Fixed
Description
SQLProcedureColumns returned incorrect result when stored procedure

had tab characters in the parameter declaration.



CR:493399
CR Number:   493399
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2008 Fixed
Description
When a Sybase stored procedure had a comment containing the keyword

"AS" two or more times, all parameters were reported as being

SQL_PARAM_INPUT when calling SQLProcedureColumns, even though some

were defined as output or input_output.



CR:493400
CR Number:   493400
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2008 Fixed
Description
When a Sybase stored procedure had more than one comment, and one of

the comments contained the keyword "AS" two or more times, all

parameters were reported as being SQL_PARAM_INPUT when calling

SQLProcedureColumns, even though some were defined as output

or input_output.



CR:493432
CR Number:   493432
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Apr 2008 Fixed
04 Nov 2009 Fixed
Description
OpenSwitch might crash in the Open Client library function ct_cancel() under heavy load.



CR:493464
CR Number:   493464
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#2 01 13 May 2008 Fixed
Description
Allow multiple license keys for multiple CPUs in one SYGWXCPH module.



CR:493467
CR Number:   493467
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#21
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2008 Fixed
18 Nov 2008 Fixed
Description
DBLIB: dbcancel() times out when waiting for server to acknowledge attention.
Workaround Description
 Use libsybdb.so from a pre-12.5.1 ESD#12 release.



CR:493557
CR Number:   493557
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#13 08 Dec 2013 Fixed
12.5.1 ESD#22 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Invalid conversion error produced for parameters of Real type in Microsoft SQL Server Linked Server Replication to ASE.



CR:493740
CR Number:   493740
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
AseBulkCopy concept doesn't work when qualifying destination table with database
Workaround Description
 In the connection string add Database=<Destination Table Database>, this will then return a result set when sp_oledb_columns <Database>..Dst_tableName is called.



CR:493913
CR Number:   493913
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#23 01 Jun 2010 Fixed
15.0 ESD#14 01 Jun 2010 Fixed
Description
ODBC Driver by Sybase: Request to provide application process id for the "Client Host Process" in order to uniquely identify client processes.



CR:493925
CR Number:   493925
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Setting CS_TIMEOUT and using ct_callback() for Client messages. On Unix platform, commands are not being terminated via ct_cancel(CS_CANCEL_ATTN) when the network cable is pulled and remote host becomes unreachable via TCP.
Workaround Description
 Could return CS_FAIL instead of ct_cancel() in the callback but this would be a different behavior for Unix (Linux) from Windows.



CR:494087
CR Number:   494087
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Closed
OS:   Windows XP
Original Version:   2.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2008 Fixed
Description
Failed to pause at breakpoint when debugging a trigger on ASE12



CR:494141
CR Number:   494141
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1 ESD#22
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Apr 2008 Fixed
16 Apr 2008 Fixed
Description
SRVLIB: srv_poll() may crash at sybnet__do_poll() when polling on multiple file descriptors.



CR:494309
CR Number:   494309
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#14 08 Dec 2013 Fixed
1.15 ESD#14 08 Dec 2013 Fixed
1.1 ESD#24 08 Dec 2013 Fixed
Description
ADO.NET: Unable to start a second transaction when TransactionOption.Required is used.





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