远程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:537721
CR Number:   537721
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#25 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: The datalength() for varchar columns accessed from Microsoft Linked Server thru OLE DB always report the maximum size regardless of the actual data in the column.



CR:538172
CR Number:   538172
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#26 02 May 2013 Fixed
Description
ODBC Driver by Sybase: Third party application 'JobVision' crashes when trying to import data from ASE.



CR:538978
CR Number:   538978
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Linux
Original Version:   12.5.1 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2010 Duplicate
Description
When a DB-Lib error handler catches SYBETIME and returns INT_TIMEOUT,

the DB-Library application reports an OS error and automatically exits.



CR:539116
CR Number:   539116
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   Unknown
Original Version:   15.0 ESD#28
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
BCP should support the use of a hostname:port in it's commandline syntax. isql supports this syntax and interfaces files may not exist with sufficient entries to use -S syntax.



CR:539292
CR Number:   539292
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Linux
Original Version:   12.5.1 ESD#30
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2010 Fixed
Description
Update locales.dat to include entries en_US.ISO8859-1 and en_US.ISO8859-15 for Linux.



CR:539316
CR Number:   539316
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Customer need to have the SDK installed via Red Hat Package Manager



CR:539684
CR Number:   539684
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Calling stored procedure with return value multiple times results in an error



CR:539732
CR Number:   539732
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Linux
Original Version:   12.5.1 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Feb 2011 EOL'd version. Not to be Fixed.
13 May 2011 Fixed
23 May 2011 Fixed
Description
DBLIB: dbexit() does not release all memory allocated by dbinit(). Memory leak occurs.



CR:539769
CR Number:   539769
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Driver by Sybase: Invalid syntax on UPDATE statements when more than one field is updated using SetData



CR:539809
CR Number:   539809
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 the jConnect connection property, "protocol_capture", does not include tds information for both the original connection session and failed over/migrated session.



CR:539827
CR Number:   539827
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#15 08 Dec 2013 Fixed
1.1 ESD#26 08 Dec 2013 Fixed
Description
ADO.NET: Disposing AseCommand object closes the AseDataReader.



CR:540012
CR Number:   540012
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2009 Fixed
19 May 2009 Fixed
Description
Problem: Need to add functions to support manual commit/rollback. Workaround: 1. Add a preference "Connection commit mode" in "Sybase, Inc -> Database Development -> SQL Editor -> SQL Files/Scrapbooks" to support commit mode change: auto or manual, and default value is "Auto". 2. Add a preference "Max connection count" in "Sybase, Inc -> Database Development -> Miscellaneous" to limit sum of opened Table Data Editor and active manual-commit SQL Scrapbook Editor.



CR:540327
CR Number:   540327
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2009 Fixed
05 Aug 2009 Fixed
Description
Problem: Need to add filter function to find column quickly.

Workaround: Add filter function to find column quickly. 1. While switch to column page, the filter function should be work automatically. 2. While invoke refresh form DB or revert action, should clear filter text.



CR:540545
CR Number:   540545
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 01 27 Feb 2009 Fixed
Description
sp_odbc_datatype_info CSP is missing for TRS.



CR:540550
CR Number:   540550
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Dec 2009 Bundled Request
Description
ct_cancel(CS_CANCEL_CURRENT) hangs when ASE returns a deadlock message
Workaround Description
 Use ct_cancel(CS_CANCEL_ALL) instead of ct_cancel(CS_CANCEL_CURRENT).



CR:540656
CR Number:   540656
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#15 08 Dec 2013 Fixed
12.5.1 ESD#24 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Selecting values from a binary column from Microsoft Linked Server thru OLE DB returns error: Msg 7347 搑eturned data that does not match expected data length厰



CR:540697
CR Number:   540697
Product Name:   Open Client-Doc
Product Component:   Supplement
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 30 Jan 2009 Fixed
Description
Need to document ISQL & BCP parameters -X and -W for extended password encrypt



CR:540923
CR Number:   540923
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2008 Fixed
Description
DBLIB: dbopen() does not failover to the second query entry when the connection to the first query entry is not successful.



CR:541065
CR Number:   541065
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2008 Fixed
Description
Issue :

Syntax error in sql_server*.sql scripts causes failure when installing.



CR:541160
CR Number:   541160
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Windows 2000
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2008 Fixed
Description
OSwitch crashed while calling strlen from log__normal while DEBUG=l enabled
Workaround Description
 Turn DEBUG=l off



CR:541495
CR Number:   541495
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2008 Fixed
Description
jConnect: Encrypted Password connections fail if password has expired.



CR:542036
CR Number:   542036
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2009 EOL'd version. Not to be Fixed.
03 Sep 2008 Fixed
Description
RCM crashes with "-a" command-line flag when analyzing the RCM environment upon start-up



CR:542486
CR Number:   542486
Product Name:   Open Client
Product Component:   cslib
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
CS-Lib: Localisation environment variable LC_CTYPE is not applied as default to CS-Lib locale.
Workaround Description
 None known.



CR:542915
CR Number:   542915
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to ship Mit Kerberos runtime library with OCS.



CR:543358
CR Number:   543358
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#25
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#25 08 Dec 2013 Fixed
15.0 ESD#16 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Incorrect row updated after SQLSetPos used to set cursor position. The first row is updated regardless of the position.



CR:543454
CR Number:   543454
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Oct 2008 Fixed
Description
jConnect: Cannot use Bulk load option (ENABLE_BULK_LOAD) on temporary tables if using multiple temporary databases.
Workaround Description
 You can get your spid's tempdb with

select db_name(@@tempdbid).

then switch database context to this tempdb

and it will work.



CR:543456
CR Number:   543456
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2012 Fixed
04 May 2012 Fixed
04 May 2012 Fixed
04 May 2012 Fixed
04 May 2012 Fixed
04 May 2012 Fixed
04 May 2012 Fixed
04 May 2012 Fixed
Description
Mutual Aware setup:



System 'ping' OS command used in OpenSwitch to monitor

and check the health of the participating ASE servers

has the following issues that warrants a different

implementation.



1. This command doesn't work on non-english windows

platforms as advertised.



2. This command brings in 'root' permission issues

in which end-users have to apply a workaround to overcome

this potential problem.



3. In general, it's not recommended for any server

applications to run OS command more frequently as some

of the OS commands require and runs in a separate shell

which is not desirable.



CR:543531
CR Number:   543531
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 17 Dec 2008 Fixed
12.5.1 ESD#27 02 Dec 2013 Fixed
Description
ODBC Driver by Sybase: The SQLBulkOperations call with SQL_ADD parameter value fails if rows are being inserted to a table in a different database than the current database.



CR:544077
CR Number:   544077
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Deleting a row in a Delphi DataGrid, results in the error "The parameter is incorrect"



CR:544105
CR Number:   544105
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#16 08 Dec 2013 Fixed
Description
ASE OLE DB Provider:

Executing stored procedures with Linked Server using 4 part name fail



CR:544222
CR Number:   544222
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   HP-UX
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2008 Fixed
Description
DBLIB: Application is disconnected or fails to connect to server when poll gets EINTR.



CR:544328
CR Number:   544328
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2013 Fixed
08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Memory leak observed when calling Connect and Disconnect in a loop.



CR:544336
CR Number:   544336
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#19 12 May 2009 Fixed
Description
ADO.NET: Unhandled exception (Access Violation) under certain conditions.



CR:544476
CR Number:   544476
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2008 Fixed
Description
jConnect: Null Pointer Exception encountered when a ResultSet is closed without processing it.



CR:544778
CR Number:   544778
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2008 Fixed
Description
DBLIB:ASE raises an error when dblib application sends a char/varchar parameter that is greater than 255 characters.
Workaround Description
 Make sure that all of your calls to dbrpcparam() for char/varchar parameters specify

a valid length <= 255.



CR:544800
CR Number:   544800
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 21 Sep 2010 Fixed
12.5.1 ESD#26 21 Sep 2010 Fixed
Description
OLE DB Provider by Sybase: Some Date and Time data formats not correctly processed when using Microsoft SSIS to insert data into Sybase ASE via OLE DB connection.



CR:544918
CR Number:   544918
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2010 Insufficient priority to fix
Description
Feature Request: Implement a way to compress TDS traffic between OpenClient and Server.



CR:545140
CR Number:   545140
Product Name:   Open Client
Product Component:   blklib
Status:   Open
OS:   Solaris
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
bcp-in using a format file may insert longer data than the length of the column into the column and result in column corruption.

This is a multi-byte character specific problem.



CR:545191
CR Number:   545191
Product Name:   Organic ODBC Driver
Product Component:   Install
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
This is a request from one of our distributors (MTBASE) in Colombia.



Currently, the Win64 machines are becoming more and more usual among customers and they ask for Sybase to consider making available a PC-Client 15.0 64bits together with ASE products, in the future. This will allow customer to use all 64-bit ADO.NET Provider, ODBC and OLEDB drivers.



CR:545440
CR Number:   545440
Product Name:   Open ClientCONNECT for IMS and MVS
Product Component:   Open ClientCONNECT for IMS and MVS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#6 01 04 Oct 2012 Fixed
15.0 ESD#3 02 27 Feb 2009 Fixed
Description
Memory leak for varchar/char parameters of 39 or 40 bytes.



CR:545538
CR Number:   545538
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Connection to ASE fails from some client machines running non-English locales, if this locale is supported by ASE but the language module is not installed on ASE.
Workaround Description
 Install language on ASE.

Modify DSN to use an installed language.

or

Set default language to NULL in master..syslogins.

Use ODBC from 12.5.



CR:545561
CR Number:   545561
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature request for a way to set the default batch size used by BCP
Workaround Description
 Perl script which, if modified with the real bcp path name, made executable, named "bcp", and placed before the "real" bcp in $PATH will substitute in a '-b 1000' parameter and call the real bcp:





bcp

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

#!/usr/bin/perl





my $cmdstring = "/work/releases/1502nb/OCS-15_0/bin/bcp";

my $dashb_found = 0;

my $i = 0;



foreach my $parm (@ARGV)

{

$cmdstring = $cmdstring . " " . $ARGV[$i];

$x = index($ARGV[$i], "-b");

## print "parameter $i: ", $ARGV[$i], $x, "\n";

if ($x == 0) { $dashb_found = 1; }

$i++;

}



if ( $dashb_found == 0 )

{

$cmdstring = $cmdstring . " -b 1000"

}



print $cmdstring . "\n" ;



exec($cmdstring);

exit(0);



CR:545596
CR Number:   545596
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Feb 2009 Fixed
25 Mar 2009 Fixed
22 Feb 2009 Fixed
21 May 2009 Fixed
26 Mar 2009 Fixed
Description
ESQL: FETCH statement does not return the number of rows retrieved in SQLDA structure.



CR:545821
CR Number:   545821
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC gets Internal Error 30016 on SSL querys when packet size is 8192
Workaround Description
 Set the ODBC DSN packet size down to 4096.



CR:545837
CR Number:   545837
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: In a Delphi application, inserting a row into an empty Rowset causes the error "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."



CR:545850
CR Number:   545850
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 09 Oct 2008 Fixed
Description
OLE DB Provider by Sybase: The error "Must declare variable '@full_table_name'." occurs when an application makes a schema call for index information.



CR:545852
CR Number:   545852
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Driver by Sybase: Access Violation occurs when calling IRowsetUpdate::InsertRow on a row with a calculated column



CR:545853
CR Number:   545853
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Inserting and then deleting the new row repeatedly results in the error: "Bookmark is invalid".



CR:546034
CR Number:   546034
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#17 08 Dec 2013 Fixed
1.15 ESD#17 08 Dec 2013 Fixed
Description
ADO.NET: System.NotSupportedException thrown when calling IDbCommand. Parameters RemoveAt() method.



CR:546103
CR Number:   546103
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#16 08 Dec 2013 Fixed
Description
ASE OLE DB Provider:Complex JOIN is failing with Linked Server using OPENQUERY



CR:546216
CR Number:   546216
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Setting a column to empty string results in the column being set to NULL



CR:546227
CR Number:   546227
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Unknown
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Attempting to cancel sql results via ctrl-c aborts the isql application process when the HAFailover property is specified.
Workaround Description
 Don't use -Q !!!



CR:546268
CR Number:   546268
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Update Documents Jconnect for status on Jdbc 3. The Rel Bull is sort of out-of-date as it was written at time of original GA.

REF DOC: http://www.sybase.com/detail?id=1037380



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

Cannot create a connection with MS SQL Server SSIS connection manager as the

dialog to supply the connection parameters is unavailable



CR:546366
CR Number:   546366
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 21 Jan 2009 Fixed
08 Mar 2009 Presently Not Targeted For Any Future Release Of This Product
Description
ODBC Driver by Sybase: Money datatype with a unique index cannot be displayed using Microsoft Access 2003.



CR:546378
CR Number:   546378
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   K2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2009 Fixed
05 Aug 2009 Fixed
Description
Problem: Need to add Source tab to support edit view definition in View Editor.

Workaround: Add Source page to View Editor for ASE/ASA/IQ, user can now edit the definition in the Source page; Source page also provide syntax validation and content assist.



CR:546609
CR Number:   546609
Product Name:   Database Development
Product Component:   Other
Status:   Open
OS:   Windows 2000
Original Version:   K2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.1.2 22 Mar 2009 Fixed
Description
Problem: Issues if you have multiple owners with the same table name. Issue#1, Show Schema not marked and Show Owner marked in Enterprise Explorer. Right-click on the table object-> properties. On the filter, select Include, there's only the table names, but not the owners. Issue#2, A long list of table objects will move the whole window upward instead of the table list only. This means also you need to scroll down the whole list get to the Restore Defaults or Apply button.

Workaround: Fixed Issue 1, now filter property page will show database object name followed by schema name in parent. For Issue2, this problem is a bug in Data Tools Platform connectivity. DTP bug 268479 was opened. Attached UI change notes.



CR:546719
CR Number:   546719
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.5 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Nov 2008 Fixed
Description
jConnect: UnimplementedOperationException encountered when using SybConnectionProxy.prepareStatement(String, int).
Workaround Description
 None.



CR:546741
CR Number:   546741
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Update, then Delete same record in Optimistic mode results in error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."



CR:546761
CR Number:   546761
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Inserting and then updating or deleting the new row results in the error: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."



CR:546838
CR Number:   546838
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Jconnect DYNAMIC_PREPARE = true and ASE set statstics time on fails back to PARAMETERIZED LANGUAGE tds.



CR:546915
CR Number:   546915
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#18 08 Dec 2013 Fixed
Description
OLE DB Driver by Sybase: Memory usage increases when rowset is opened frequently.



CR:547027
CR Number:   547027
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 May 2014 Not reproducible with latest version of the product available as of Resolution Date
Description
OLE DB Provider:



Error 7346 running sp_catalogs on ASE linked server from MSSQL 2005

when using OLE DB Provider options "Allow InProcess Enabled".



exec sp_catalogs '<LINKED_SERVER>'



Cannot get the data of the row from the OLE DB provider "SQL Server" for linked server "(null)".

Deferred accessor validation occurred. Invalid binding for this column. (.Net SqlClient Data Provider)



CR:547087
CR Number:   547087
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2008 Fixed
30 Oct 2008 Fixed
Description
CT-Lib: Application may get "An illegal tds token sequence was received" and abort when ASE Cluster Edition membership changes during ct_fetch() operations.
Workaround Description
 none



CR:547380
CR Number:   547380
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Inserting and then deleting the new row in BatchOptimistic mode causes an access violation.



CR:547553
CR Number:   547553
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 2008 Fixed
29 Jan 2009 Fixed
Description
BCP: BCP dumps core when the datatype of the table column is different from that of the corresponding column in format file.
Workaround Description
 change the second field to SYBINT4

or use 12.5.1 bcp



CR:547704
CR Number:   547704
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   HP-UX
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2008 Fixed
Description
BCP: bcp in using field_terminator (umlat) fail to work.
Workaround Description
 Customer can use ESD#4 to get around the issue.



CR:547733
CR Number:   547733
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2009 Fixed
23 Dec 2008 Fixed
Description
Mutual Aware OpenSwitch issues :



(1) Mutual aware OpenSwitch hangs in SUSPENDED

state when primary ASE goes down. The clients

connected to both primary and secondary

OpenSwitch's are disconnected when the primary

ASE is down.



(2) Secondary/redundant RCM won't perform

replication switch and switch clients to the

standby ASE when the clients are only connected

to secondary OSW when primary ASE goes down.



(3) When primary ASE and primary OpenSwitch hosts

are down, secondary OpenSwitch wrongly detects

this case as a total network failure and

disconnects / terminates itself. Even though

secondary OpenSwitch can contact secondary ASE

host and secondary ASE being up and healthy in

this case.



(4) Client thread state using "rp_dump thread"

command still shows as THRD_S_CLOSED after the

client re-established its connection to the

secondary ASE when primary ASE host goes down.



(5) When clients are connected only to secondary

OpenSwitch, cm_is_active() CM API invoked in the

CM application connected to secondary OpenSwitch

returns CS_FALSE when primary ASE goes down.



(6) Client connections involved in busy

transactions connected to primary or secondary

OpenSwitches might hang when primary ASE goes

down.



(7) Client connections might hang when OpenSwitch

is handling the primary ASE failure and the

client times out when the client application

re-connects to the primary ASE server.
Workaround Description
 Establish a dummy connection to OpenSwitch so that there is

one active connection at all times.



CR:547740
CR Number:   547740
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#16 08 Dec 2013 Fixed
Description
ODBC Driver By Sybase: SQLBulkOperations with SQL_ADD option fails when the client requests to use concurrency type of SQL_CONCUR_ROWVER



CR:547766
CR Number:   547766
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 08 Dec 2013 Fixed
12.5.1 ESD#26 02 May 2013 Fixed
Description
OLE DB Provider by Sybase: On some Windows versions like Windows 2003, Access Violation encountered when calling a stored procedure (RPC) that with a 揝ELECT @variable or 搑aiseerror clause.



CR:547998
CR Number:   547998
Product Name:   Organic OLE DB Provider
Product Component:   TDS Library
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASEOLEDB DynamicPrepare set to 1 and useing temptables (#tables) give MSG 208 from

ASE this is because the driver send all sql as dynamic token even DDL, this lead to that the 2 execution do not see the #table create in the first execute.
Workaround Description
 DynamicPrepare=0

or

Change so you exec them as a batch.

create table #t (col int)

insert #t values (1)

execute



CR:548008
CR Number:   548008
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   AIX
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Connect to Open Server Kerberos sample fails w/ error 16369 in SCL_MECH_ALLOC
Workaround Description
 Compile with -bexpall



CR:548011
CR Number:   548011
Product Name:   Organic OLE DB Provider
Product Component:   TDS Library
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ASEOLEDB UseCursor=1 and send batch sql generate Msg 3804 from ASE. This is FR to have a option so the driver resend the sql as languages token when we get Msg 3804.
Workaround Description
 UseCursor=0



CR:548035
CR Number:   548035
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: ADO Recordset.RecordCount is -1 with CursorLocation = adUseServer



CR:548138
CR Number:   548138
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Generic
Original Version:   2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2009 Fixed
03 Mar 2009 Fixed
04 Aug 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Problem: Performance problem in Enterprise Explorer Explorer for databases with many users.

Workaround: Fixed. Enhanced catalog loader to provide efficient E.E. expansion.



CR:548246
CR Number:   548246
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#17 08 Dec 2013 Fixed
Description
ADO.NET: The DbDataAdapter object instantiated from DbFactory.CreateDataAdapter raises System.InvalidCastException when used.



CR:548285
CR Number:   548285
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 08 Dec 2013 Fixed
12.5.1 ESD#26 02 May 2013 Fixed
Description
OLE DB Provider by Sybase: Provider exhibits memory leak when calling Connect, Executed stored procedure and Disconnect sequence in a loop.



CR:548347
CR Number:   548347
Product Name:   Open Client/Open Server-Doc
Product Component:   Programmer's Supplement
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2009 Fixed
Description
Wrong command in Programmer's supplement(P96) sp_dboption.



CR:548349
CR Number:   548349
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 16 Mar 2009 Fixed
Description
OLE DB Provider by Sybase: Using Decimal parameter in ADO.NET OLE DB Provider results in ASE Domain error.
Workaround Description
 Use OleDbType.Numeric works okay - able to implicitly set precision and scale.



CR:548397
CR Number:   548397
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   K2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2009 Fixed
Description
Problem: Duplicated view editor item in Schema Object Editor Configuration preference page.

Workaround: Fixed to remove the duplicated definition in ASE plugin.xml.



CR:548634
CR Number:   548634
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2010 Fixed
Description
OLE DB Provider by Sybase: Some string data corrupted due to conversion issues when ASE configuration option "enable unicode normalization" is set to 0.



CR:548726
CR Number:   548726
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 02 27 Feb 2009 Fixed
Description
sp_cababilities returns incorrect value of "1" for "transaction handling" when AMD2 is not installed.



CR:549059
CR Number:   549059
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC Driver configured for SSL connects when server certificate has expired.



CR:549072
CR Number:   549072
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 08 Dec 2013 Fixed
12.5.1 ESD#26
Description
ODBC Driver by Sybase: The SQLBulkOperations call with SQL_ADD parameter value fails if default column values are used for all columns of a row.



CR:549358
CR Number:   549358
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2008 Fixed
Description
SRVLIB: When a client application connects to ASE through a gateway Open Server application, the gateway Open Server application sends an error message (TDS_EED) per row of data to the client application when there is any character set conversion error in the row. This might cause client application like BCP to lose data as BCP exits when it receives TDS_EED.



CR:549687
CR Number:   549687
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Insert NULL value into column defined as NOT NULL returns error



CR:549824
CR Number:   549824
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2012 EOL'd version. Not to be Fixed.
15.0 ESD#4 10 09 Jun 2010 Fixed
Description
Old Context Handler, SYGWCTXH, sends out the wrong message for a CICS Verify. The correct message is a CICS INQUIRE.



CR:549972
CR Number:   549972
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2009 Fixed
03 Mar 2009 Fixed
Description
Problem: Should have preference to clean up results history.

Workaround: 1) Added preference to clean result history automatically. 2) The "Max row count" default value was changed to 500. 3) Detached the result set and parameter information from result history file to separated files for performance enhancement. 4) Fixed the bug for the execution can't cancel when the result set content is large. 5) Fixed the bug there is NPE when Sybase Workspace starts.



CR:550191
CR Number:   550191
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Dec 2008 Fixed
Description
DBLIB : Applications always print out UTF-8 encoded DB-Library messages regardless of specified character set of Japanese language.
Workaround Description
 You might be able to work around this issue by replacing dblib.loc file.

For example, if your client's charset is eucjis, copy the eucjis encoded dblib.loc from $SYBASE/locales/japanese/eucjis

directory to $SYBASE/locales/message/japanese directory.

But this workaround can not be applied if your clients charset is mixed like eucjis and sjis.



CR:550195
CR Number:   550195
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2009 Fixed
04 Mar 2009 Fixed
Description
Problem: Need to set option quoted_identifier issue in ASA.

Workaround: The "set option" statement was used when a connection was initialized. It's a server level change, so it affects other users, for example, a user who accesses the database via ODBC in PowerBuilder. Replaced "set option" with "set temporary option", which is the connection level setting and it won't affect other users.



CR:550212
CR Number:   550212
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   RH Linux
Original Version:   15.0 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2008 Fixed
Description
Samples: Using samples in combination with LDAP directory services may raise a segmentation violation and generate a core dump on ibmplinux.



CR:550282
CR Number:   550282
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   HP-UNIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2008 Fixed
22 Dec 2008 Fixed
Description
NETLIB: On HP 11.31 and later, ct_connect() fails intermittently with error EISCONN.
Workaround Description
 Retry connect excessively, but this seems too much for production jobs.



CR:550533
CR Number:   550533
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#26 01 May 2013 Fixed
Description
ODBC Driver by Sybase: An ANSI application receives bogus truncation warnings when calling SQLGetConnectAttr with SQL_ATTR_CURRENT_CATALOG parameter.



CR:550543
CR Number:   550543
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add a warning message reminder when license key is about to expire.



CR:550579
CR Number:   550579
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 06 May 2013 Fixed
12.5.1 ESD#26 02 May 2013 Fixed
Description
ODBC Driver by Sybase: The SQLTables call fails for an ODBC connection to Direct Connect back-ends with "Parameter value was invalid." error.



CR:550689
CR Number:   550689
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 08 Dec 2013 Fixed
08 Mar 2009 Presently Not Targeted For Any Future Release Of This Product
Description
ODBC Driver by Sybase: Microsoft Access receives conversion errors when accessing Date data from a DB2 database via Direct Connect.



CR:551340
CR Number:   551340
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   K2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Mar 2009 Failed
04 Mar 2009 Fixed
Description
Problem: Failed to get role-based permissions. When the user is not sa, the "Roles" can't be shown. For example, you open a Table Schema Editor and select the "Permission" tab, the "Roles" tree is empty.

Workaround: After fixing, if the user is not sa, when database catalog node was expanded in "Enterprise Explorer" under non-dbo role, there would be some exceptions like "Server user id 11 is not a valid user in database 'model'". It's normal, because no-dbo role does not have permission to access each database.



CR:551421
CR Number:   551421
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Windows XP
Original Version:   2.0 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2009 Fixed
Description
WorkSpace open 2 connections not just one, to a DB and generating an excessive volume of queries



CR:551491
CR Number:   551491
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2008 Fixed
02 Feb 2009 Fixed
03 Feb 2009 Fixed
25 Feb 2009 Fixed
26 May 2009 Fixed
02 Apr 2009 Fixed
Description
TCLLIB: Parsing of filter information may allow syntax errors.



CR:551533
CR Number:   551533
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jan 2009 Fixed
22 Jan 2009 Fixed
22 Jan 2009 Fixed
Description
jConnect: Request to support T-SQL queries that include "COMPUTE" clause.





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