远程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:461446
CR Number:   461446
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Windows
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2007 Fixed
27 Mar 2007 Fixed
27 Mar 2007 Fixed
Description
BCP: bcp'ing to an SSL connection on winx64 and ibmplinux with text columns may fail.



CR:461544
CR Number:   461544
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 02 12 Sep 2007 Fixed
Description
Need to read the MFCLIC file only once, not for ever request



CR:461606
CR Number:   461606
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
Using the "exec" command to dynamically call SQL Statements is failing.



CR:462113
CR Number:   462113
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 31 Oct 2007 Fixed
14 Dec 2007 Fixed
14 Dec 2007 Fixed
Description
OLE DB Provider by Sybase: Cannot obtain Database Schema information for queries that reference tables from a database other than the one defined in the Datasource definition.



CR:462304
CR Number:   462304
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#4 07 23 Apr 2007 Fixed
Description
Sample VSAM defines missing for SYGWLSA1 and SYTACCT1.



CR:462809
CR Number:   462809
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   1.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Tonga 10 Aug 2007 Fixed
Description
REPRODUCTION:

In an ASE 15 database, create a new user. Do not have this user as the DBO.

Create a new stored procedure, and give ownership to the new user.

In the Enterprise Explorer, create a connection to that database using the sa or DBO information

Browse to the database --> new user schema --> expand the Procedures

You should now see the error



Disconnect the DB session, and modify the properties such that you are logging in as the new user

In the Enterprise Explorer, log in to the database again (as the new user)

Browse to the database --> new user schema --> expand the Procedures

You are now able to see the stored procedure.

You may also now expand the DBO procudures, and see the list available there as well.



CR:462831
CR Number:   462831
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2007 Fixed
26 Jun 2007 Fixed
Description
SRVLIB: Bulk copy of text/image column that has a default value through gateway server results in server error "16067/10/0: Illegal length (0) for datatype 'CS_IMAGE_TYPE'"



CR:462904
CR Number:   462904
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#24 03 Feb 2011 Not reproducible with latest version of the product available as of Resolution Date
1.15 ESD#14 08 Dec 2013 Fixed
Description
ADO.NET: 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.



CR:463480
CR Number:   463480
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#8
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: Getting "Access Violation" when loading OLAP database from ASE using OLEDB



CR:463595
CR Number:   463595
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Apr 2007 Fixed
24 Sep 2007 Fixed
Description
ODBC Driver by Sybase: The SQL used in "sp_odbc_datatype_info" stored procedure that is used by ODBC functions like SQLGetTypeInfo, does not produce an optimal query plan. This is increasing the time taken to make an ODBC connection to ASE.
Workaround Description
 *** Monday, April 23, 2007 16:37:31 *** pvero ***

This was discovered by Customer and Alliance Engineer in case 11340629



Significant increase in performance when adding this line:



and c.type =* d.ss_dtype to the WHERE clause:



from sybsystemprocs.dbo.spt_datatype_info d, syscolumns c,

sybsystemprocs.dbo.spt_datatype_info_ext e, systypes t

where

d.ss_dtype = t.type

and t.usertype *= e.user_type

and c.type =* d.ss_dtype



In simple ISQL testing the time diff was:



610 millisec for sp_odbc_datatype_info (sdk15 esd07)

240 millisec for change to sp_new_odbc_datatype_info (look in dt_new.sql)



CR:463872
CR Number:   463872
Product Name:   Database Development
Product Component:   Online Help
Status:   Closed
OS:   Windows 2000
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Oct 2007 Added to user documentation
Description
*** Monday, October 08, 2007 3:15:30 PM *** kliu ***

Problem Description:

Some users have experienced that for some ASE procedural objects-- stored procedures and triggers in database other than 'master', the debugger breakpoint cannot be set at the correct location.

Problem Resolution:

The workaround is to restart ASE database server











For some ASE procedural objects-- stored procedures and triggers in database other than 'master', the debugger breakpoint cannot be set at the correct location. Usually, those procedural objects contain SQL statements eRxpanded by the ASE server after the definition is modifed and saved. For example, after the following statement in a stored procedrue got saved and expanded by the server, the user will not be able to set the breakpoint on that statement:

"select * from authors", will be expanded to

"--Adaptive Server has expanded all '*' elements in the following statement

select authors.au_id, authors.au_lname, authors.au_fname, authors.phone, authors.address, authors.city, authors.state, authors.country, authors.postalcode from authors",

and when the user tries to set breakpoint at the 'select authors...' statement, the breakpoint will be off.



This problem is caused by an ASE bug, CR463870.
Target Version
 Tonga



CR:463944
CR Number:   463944
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2007 Fixed
11 May 2007 Fixed
Description
DBLIB: dbsetinterrupt() fails to handle interrupt until after read from server completes.



CR:464319
CR Number:   464319
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2007 Fixed
03 Jun 2007 Fixed
Description
SRVLIB: ODBC client executing a language command against Open Server application may result in server error message "16227/15/0: Unknown token TDS stream received by spid".



CR:464325
CR Number:   464325
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Aug 2007 Fixed
22 Feb 2008 Fixed
06 Dec 2007 Fixed
28 May 2008 Fixed
06 Mar 2008 Fixed
03 Mar 2008 Fixed
04 Mar 2008 Fixed
24 Apr 2008 Fixed
30 May 2008 Fixed
14 Jul 2008 Fixed
Description
CTLIB, SRVLIB: Allow partial text/image updates to open server.



CR:464833
CR Number:   464833
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Microsoft Win32s
Original Version:   12.5.1 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2007 Fixed
03 May 2007 Fixed
Description
BCP: BCP fails to truncate trailing space due to wrong interpretation of univarchar space.
Workaround Description
 Various awkward work-arounds:

1. BCP into varchar() and then select into target column.

2. Use UNIX BCP application.

3. Use CIS external file system (XFS) option.



CR:464864
CR Number:   464864
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#4 19 Apr 2007 Not a Bug
Description
TDSETPRM is adding an a binary Zero in front of the Data area of a TDSCHAR parm
Workaround Description
 None



CR:464989
CR Number:   464989
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#19 08 Dec 2013 Fixed
15.0 ESD#9 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Visual Basic applications using rdoResultset that's opened with rdOpenDynamic and rdConcurReadOnly attributes receive runtime error.
Workaround Description
 Use DataDirect driver, or use ADO technology, instead of rdo.



CR:465281
CR Number:   465281
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
aries 29 May 2009 Fixed
Description
Documentation not clear on PATH where install_odbc_sprocs.bat is located.



CR:465337
CR Number:   465337
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2007 Fixed
24 Apr 2007 Fixed
Description
CPRE: When parsing recursive structures or unions, cpre incorrectly reports a syntax error "M_SYNTAX_PARSE".



CR:465402
CR Number:   465402
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#8 27 Jul 2007 Fixed
Description
jConnect: Calling DatabaseMetaData.getDatabaseMajorVersion() method fails when connected to a Data Federation (Avaki) backend.



CR:465646
CR Number:   465646
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Windows 2000
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2011 Presently Not Targeted For Any Future Release Of This Product
23 Oct 2007 Added to user documentation
Description
*** Monday, October 08, 2007 2:55:53 PM *** kliu ***

Problem Description:

In WorkSpace2.0, if you use Visual SQL, the Query editor, or the DataWindow editor with a particular connection profile and database, then make a change to the tables/columns of that database (eg, add/delete a table or column), you will not see those changes the next time you use Visual SQL, the Query editor, or the DataWindow editor;



Problem Resolution:

Disconnect and connect to the database server again.



CR:465836
CR Number:   465836
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2007 Fixed
23 Apr 2007 Fixed
Description
CTLIB: When CS_ASYNC_NOTIFS is enabled and ct_recvpassthru is called with CS_EOM set, message 0x0502070a (A read was attempted on a connection already executing a read.) is raised.



CR:465955
CR Number:   465955
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2007 Fixed
18 May 2007 Fixed
10 Jan 2008 Fixed
11 Jan 2008 Fixed
Description
CTLIB: Race condition exists in non-reentrant libraries when CS_ASYNC_NOTIFS is set to CS_TRUE.



CR:466137
CR Number:   466137
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#9 08 Dec 2013 Fixed
12.5.1 ESD#19 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Applications using Microsoft ADO or ADO.NET OleDb Client cannot correctly read Unicode data stored in char/varchar/nchar/nvarchar columns.



CR:466158
CR Number:   466158
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ADO.NET provider >System.NullReferenceException on AseDataReader.close() when using the "Using" statment in c#.
Workaround Description
 finally

{

if(reader != null && !reader.IsClosed)

reader.Close();



CR:466533
CR Number:   466533
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   HP-UNIX
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jun 2007 Fixed
Description
SRVLIB: Open Server may core dump at srvr__xi4Swap while reading cursor command sent by the client.



CR:466666
CR Number:   466666
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
aries 18 Jun 2009 Fixed
Description
'Connection Lifetime' and 'Idle Connection Timeout properties should be detailed in ASE ADO.NET Data Provider API Reference.



CR:467003
CR Number:   467003
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 10 May 2007 Fixed
Description
OCC is overlaying the hostvar in a PLI RPC with the length field of the next varaible.



CR:467090
CR Number:   467090
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Replication MS SQLServer 2005 to Sybase ASE via 'linked server' and Sybase Organic ASE OLE DB provider fails to connect to subscriber.



CR:467092
CR Number:   467092
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 May 2007 Not a Bug
Description
Tested and reproduced with:

Version: Sybase DB-Library/12.5.1/P-EBF14280 ESD #17/PCIntel/BUILD1251-048/OPT/Tue Jan 23 01:47:19 2007 (we kept this same version in client side when testing all servers below)



When running C application that calls xp_server, the following error message appears:



Returns error:

Msg 8015, Level 0, State 1

Server 'ase1254', Procedure 'xp_cmdshell', Line 2

Adaptive Server has truncated parameter number 1 passed to rpc '08sybsyespxp_cmdshell' on server 'ASE1254_XP'. The remote server does not support character or binary data wider than 255 bytes.



Issue happens with dblib applications only. Ctlib applications work fine.



CR:467483
CR Number:   467483
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
If using dynamic_prepare=true and executeBatch() support, very large numbers of inserts can cause hangs between the client and the server. jConnect should batch up the inserts to eliminate hangs.
Workaround Description
 make your own small batches, or set "dynamic_prepare = false" on the connection properties. New bulk insert support should help here also.



CR:467510
CR Number:   467510
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Nov 2007 Fixed
Description
OLE DB Provider by Sybase: The OLE DB Provider exhibits excessive memory accumulation and some leaks executing queries.



CR:467639
CR Number:   467639
Product Name:   Connectivity Utilities
Product Component:   dscp
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2007 Fixed
Description
DSCP: Dscp deletion corrupts the data of an interfaces file when the first line of the interfaces file is a blank or comment line.



CR:467846
CR Number:   467846
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLE DB Provider by Sybase:



Microsoft Data Link utility fails with "Catastrophic failure" when creating MS Data Link 64bit entry with OLEDB provider. Works fine in 32-bit environment only.



CR:468655
CR Number:   468655
Product Name:   jConnect
Product Component:   JDBC Gateway
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jul 2007 Fixed
Description
jConnect: Feature request to support passing connection property values as part of directory services URL (dsurl).



CR:468750
CR Number:   468750
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 06 Nov 2007 Fixed
12.5.1 ESD#21 12 Dec 2007 Fixed
Description
OLE DB Provider by Sybase: DSNs created through Sybase Data Source Administrator cannot be created as system DSNs such that they can be used by any user on the system.



CR:468860
CR Number:   468860
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   12.5.1 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Mar 2009 Fixed
12.5.1 ESD#19 05 Sep 2007 Fixed
Description
ODBC Driver by Sybase: Executing a query that includes a COMPUTE clause results in an Internal Error.
Workaround Description
 None apart from avoiding using COMPUTE clause



CR:469317
CR Number:   469317
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#9 06 May 2013 Fixed
12.5.1 ESD#18 06 May 2013 Fixed
Description
ODBC Driver by Sybase: Some Microsoft ADO/Access/Excel applications make repeated calls to SQLGetConnectAttr(SQL_ATTR_TXN_ISOLATION) to obtain current transaction isolation level. Request to cache this value rather than get it each time from ASE to improve performance.



CR:469452
CR Number:   469452
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Presently Not Targeted For Any Future Release Of This Product
Description
Clarify documentation about the executeBatch and Dynamic prepare.



CR:469693
CR Number:   469693
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.15 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2007 Fixed
Description
ADO.NET: Adding a row to DataTable derived from DataReader with multiple result sets fails.
Workaround Description
 *** Thursday, May 24, 2007 09:50:49 *** pvero ***

Possible to use ODBC driver (didn't test OLEDB) but haven't approached customer on this yet. Probably not a practical approach since this is ADO.NET 1.1 code. Also fails with ADO.NET 2.0 Beta Provider.



CR:469739
CR Number:   469739
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.15 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#11 21 Jan 2008 Fixed
1.1 ESD#22 08 Dec 2013 Fixed
Description
ADO.NET: NullReferenceException thrown when disposing AseDataReader outside the scope of the using block that created the AseCommand object.
Workaround Description
 *** Thursday, May 24, 2007 17:09:37 *** pvero ***

Finding out if customer can use AseDataReader.Dispose() within the using block.



CR:469800
CR Number:   469800
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2009 Fixed
Description
Massive difference in performance with 12.5 driver taking 20 minutes and the Sybase 11 ODBC takes seconds to retrive rows from a query via a linked table in MS Access.



CR:470206
CR Number:   470206
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
Arithmetic overflow occurs when using NUMERIC OUTPUT parameter



CR:470275
CR Number:   470275
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#8
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The method AseDataReader.GetGuid() throws an NotSupportedException and it seems that the Method is there but not fully implemented.

Sideinfo: When using AsaDataReader from IAnywhere Ado.Net driver it works fine.



CR:470377
CR Number:   470377
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Massive difference in performance with 12.5 driver taking 20 minutes and the Sybase 11 ODBC takes seconds to retrive rows from a query via linked table in MS Access.



CR:470457
CR Number:   470457
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#11 06 Nov 2007 Fixed
14 Dec 2007 Fixed
Description
ODBC Driver by Sybase: SQLCancel is not working in VB/ADO applications.



CR:470558
CR Number:   470558
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   NA
Original Version:   12.5.1 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2007 Fixed
08 Jul 2007 Fixed
Description
CPRE: When using the -G option cpre generates incorrect T-SQL stored procedures when the host variable is a char type with length given as a numeric expression eg: char myVar[4+1];
Workaround Description
 Avoid numeric expressions - use macros instead.



CR:470568
CR Number:   470568
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#11 06 Nov 2007 Fixed
18 Dec 2007 Fixed
Description
ODBC Driver by Sybase: Calling SQLSetConnectAttr(SQL_ATTR_QUERY_TIMEOUT) returns error.



CR:471060
CR Number:   471060
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   SunOS
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2007 Fixed
30 Jul 2007 Fixed
Description
SRVLIB: Open Server crashes at comn__oidtoname() when client attempts to connect using network security service and charset conversion is not requested.



CR:471451
CR Number:   471451
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Closed
OS:   Generic
Original Version:   1.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2008 Fixed
06 Jan 2008 Fixed
Description
It would be useful to have the ability to save the

contents of variables and dump the first x number

of rows in the referenced tables at each

breakpoint.



Resolution: Added a context menu to allow

the user to invoke the Dump Variable & Table Data

wizard during a SQL debug session to save the

variable values and selected table rows to a log

file specified by the user.



CR:471471
CR Number:   471471
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)
06 Mar 2008 Bundled Request
Description
ODBC Driver by Sybase: Error in MS Query: Column 'col_name' can't be used in criteria



CR:471786
CR Number:   471786
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Red Hat Linux
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2007 Fixed
11 Mar 2008 Fixed
Description
OpenServer hits assertion error with invalid TDS length.



CR:471938
CR Number:   471938
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Access ASE via Visual Studio Designer 2005 fails with error msg "The given type name was

unrecognized"



CR:471996
CR Number:   471996
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Oct 2007 Fixed
04 Oct 2007 Fixed
07 Dec 2007 Fixed
23 May 2008 Added to user documentation
09 Oct 2007 Fixed
22 Nov 2007 Fixed
12 Oct 2007 Fixed
10 Oct 2007 Fixed
23 Nov 2007 Fixed
07 Dec 2007 Fixed
17 Dec 2007 Fixed
20 Dec 2007 Fixed
02 Jan 2008 Fixed
03 Jan 2008 Fixed
Description
CSLIB: Add cs_config() properties to specify alternative Sybase home directory, libtcl.cfg configuration file and interfaces file location.



CR:472155
CR Number:   472155
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#8 02 Aug 2007 Fixed
Description
jConnect: BatchUpdateException is thrown by executeBatch, if one of the statements in the batch throws an error.



CR:472296
CR Number:   472296
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
Feature request so cancel isn't blocked when two statements are not pending



CR:472309
CR Number:   472309
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Nov 2007 Fixed
14 Dec 2007 Fixed
Description
ODBC Driver by Sybase: SQLExecute() raises error #30128 when binding fixed length parameters as SQL_C_DEFAULT and not explicitly setting the bufferlength or columnsize.
Workaround Description
 If you use MS Access, there is no workaround.



CR:472565
CR Number:   472565
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Dec 2007 Fixed
Description
ISQL: ISQL fails to load locales when $SYBASE environment variable is set to a relative path.



CR:472612
CR Number:   472612
Product Name:   Organic ODBC Driver
Product Component:   Install
Status:   Open
OS:   Microsoft Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request for adding infos in the following sections in documentation/installer

a.) ITransactionJoin Interface as being implemented in

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00075_1500/html/oledb/Supported_interfaces_oledb.htm

b.) The MS DTC registry entries for the OLEDB and ODBC dlls had to be entered manually.

(http://support.microsoft.com/kb/817066/en-us) amd tp configure the MS DTC

(http://support.microsoft.com/?scid=kb%3Ben-us%3B839279&x=14&y=9).



CR:472651
CR Number:   472651
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#21 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: OLEDB Provider returns "-2147467259/Unspecified error" in a COM+ component.



CR:472683
CR Number:   472683
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Documented connection parameters that contain a space do not work with OLEDB Provider with VC++.
Workaround Description
 Do not use the connection parameters that contain a space (ie User ID or Initial Catalog)



CR:472694
CR Number:   472694
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2009 Presently Not Targeted For Any Future Release Of This Product
18 Dec 2007 Fixed
09 Aug 2007 Fixed
Description
Intermittent failure of RCM to set the ASE status and switch connections



CR:472710
CR Number:   472710
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jan 2008 Fixed
Description
OLE DB Provider by Sybase: Microsoft UDL raises a runtime error when configuring for ASE OLEDB Provider.



CR:472980
CR Number:   472980
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 06 Nov 2007 Fixed
12.5.1 ESD#21 18 Dec 2007 Fixed
Description
ODBC Driver by Sybase: Request to support iso15 charset.



CR:473031
CR Number:   473031
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Jul 2007 Fixed
Description
SRVLIB: Open Server crashes at srv__putchar() when returning row data containing unitext



CR:474154
CR Number:   474154
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)
15.0 03 12 Sep 2007 Fixed
Description
API call returns an actual length of 2 when a numeric is null.



CR:474307
CR Number:   474307
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 30 Apr 2008 Fixed
Description
The TRS CSP program AMDCCPGM will ASRA, if unicode pages missing



CR:474493
CR Number:   474493
Product Name:   Open Client
Product Component:   dblib
Status:   Open
OS:   Solaris
Original Version:   12.5.1 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
The customer would like for DBLIB that is staticly linked to return an error

when the Sybase Environment Variables are incorrectly set.



CR:474626
CR Number:   474626
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   2.0 Beta1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2007 Fixed
Description
ADO.NET: AseCommandBuilder.DeriveParameters describes parameters of 搉char type as 揷har.



CR:474759
CR Number:   474759
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 07 Nov 2007 Fixed
12.5.1 ESD#21 18 Dec 2007 Fixed
Description
ODBC Driver by Sybase: In VB/ADO application, get MoveNext error when fetching from a LONGCHAR column.
Workaround Description
 Works if we set CursorLocation to adUseClient



CR:474828
CR Number:   474828
Product Name:   Database Development
Product Component:   Online Help
Status:   Closed
OS:   Windows XP
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Tonga 23 Oct 2007 Added to user documentation
Description
Problem 1 Decription:

In ASE 15, proxy table mapped to external directory/file sometimes can't be opened.

Problem 1 Resolution:

Restart ASE 15 server.



Problem 2 Decription:

Proxy table can't be updated/inserted/deleted when proxy table have datetime datatype column,and the proxy table mapped to the remoted table in Chinese language ASE server.

Problem 2 Resolution:

This is ASE server issue, it will be fixed in the later version.



CR:474846
CR Number:   474846
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows XP
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD1 03 Jan 2008 Fixed
03 Jan 2008 Fixed
Description
IQ index has placements tabs and Fragmentation tabs in Sybase Central, so we should add them.



Resolution: Added Placements and Fragmentation read-only pages in the IQ Index Editor.



CR:475273
CR Number:   475273
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#1 01 04 Jan 2008 Fixed
Description
Iso_1 definition always used for code page translation when IBMUNICODE=N.



CR:475275
CR Number:   475275
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jul 2009 Fixed
28 Jul 2009 Fixed
25 Aug 2009 Fixed
24 Sep 2009 Fixed
Description
DBLIB: dbexit() unpaired with dbinit() causes a core dump after upgrading to 12.5.1 ESD#12.
Workaround Description
 Remove the DBEXIT () or comment it out

there is no need to have DBEXIT () in the source

code if you not using any dblib functions.



CR:475457
CR Number:   475457
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#1 01 04 Jan 2008 Fixed
Description
ASRA in new context handller when IBMUNICODE=Y and a charset override.



CR:475482
CR Number:   475482
Product Name:   Connectivity Utilities
Product Component:   dscp
Status:   Closed
OS:   NA
Original Version:   15.0 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2008 Fixed
Description
NETLIB: Dscp fails to add entry if the interfaces file does not exist.



CR:475640
CR Number:   475640
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2007 Consult Complete
Description
OLE DB Provider by Sybase: opening multiple connections causings issues with temp tables
Workaround Description
 None at this time



CR:475704
CR Number:   475704
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jul 2007 Fixed
26 Jul 2007 Presently Not Targeted For Any Future Release Of This Product
Description
LANGUAGE MODULES: "locale = en_GB.UTF-8, us_english, utf8" is now available in the [linux] section of locales.dat.



CR:475806
CR Number:   475806
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC Driver by Sybase: Attempting to insert data that includes 0x84 character using iso_1 character set for the connection results in syntax errors returned from ASE.



CR:475963
CR Number:   475963
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2007 Not a Bug
Description
Cust. would like a List of that Describes all the MF Transactions added to Doc



CR:476196
CR Number:   476196
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2007 Fixed
Description
jConnect: NoClassDefFoundError error raised when connecting to a server that supports extended password encryption.



CR:476201
CR Number:   476201
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Oct 2007 Fixed
Description
jConnect: JDBC meta data function calls may return partial results if user has set rowcount to limit results on this database connection.



CR:476239
CR Number:   476239
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2007 Fixed
Description
OLE DB Provider by Sybase: Unable to access multiple resultsets after executing a stored procedure call using TDS_DBRPC.



CR:476250
CR Number:   476250
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2007 Fixed
Description
ASE CIS proxy table DDL is "create existing". Per an ASE customer, it would be better if we used sp_addobjectdef for DDL.



CR:476487
CR Number:   476487
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2008 Duplicate
Description
ability to customise the isql prompt so that it shows the servername:



isql -Uusername -Sservername -P

SERVERNAME:(1)>

SERVERNAME:(2)>



CR:476497
CR Number:   476497
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Aug 2007 Fixed
19 Aug 2007 Fixed
30 Aug 2007 Fixed
Description
CTLIB: Open Client does not failover when ASE is configured with HA Active-Passive.



CR:476512
CR Number:   476512
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Reproduced with:

- Organic ODBC Driver 15.0.0.162 (03.51) 64-bit

- SQL Server 2005 64 bit

- Windows 2003 Server 64-bit

- Adaptive Server Enterprise/12.5.1/EBF 11662 ESD#2 on HP-UX 64-bit box

- Visual Studio 2005



When running an SQL Server Integration Services (SSIS) package from within SQL Server 2005 64 bit by using Organic ODBC Driver 15.0 64-bits, the following conversion errors occur when international characters are present in rows data (, , etc.):



For string values:

Data conversion failed while converting column "di_descripcion" (1817) to column "di_descripcion" (239). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page."



For integer values:

4495 OnError carga CC_CTACTE 2007-07-23 14:48:03.000 SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "DataReader Source" (1)" failed because error code 0x80004002 occurred, and the error row disposition on "output column "cc_protestos" (145)" specifies failure on error. An error occurre



When there are no international characters involved in rows data, the SSIS package works fine.

In 32-bit environment Windows 2003 (using SQL Server 2005 32-bits, Organic ODBC Driver 15.0 32-bit), the same SSIS package always runs fine, including when there are international characters involved in rows data.



CR:476623
CR Number:   476623
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2007 Fixed
03 Jan 2008 Fixed
Description
Problem Description: For IQ and ASA, the SQL source displayed in the Stored Procedure Editor is sometimes different from the source entered by the user.



Resolution: For ASA and IQ, there are two ways to retrieve the definition of procedural objects, one is via the debug API, the other is using system tables, but the source retrieved are different. Originally, the procedural object editor was using the ASA/IQ debug API to retrieve the source. Now it is fixed by adding a read-only Debug page in the ASA/IQ procedural object editor which still uses the debug API, but the original Source page is now using the system tables to retrieve the correct definition.



CR:476626
CR Number:   476626
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 09 Nov 2007 Fixed
12.5.1 ESD#21 18 Dec 2007 Fixed
Description
ODBC Driver by Sybase: Unhandled exception error when you execute a stored procedure with 28 or more parameters.



CR:476843
CR Number:   476843
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Linux
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Tested and reproduced with:

- SDK 15.0 ESD#9 for Linux

- ASE 15.0.2 EBF 14328 for Sun Solaris



When selecting data via Linux SDK 15.0 isql, the columns display with double of the original size defined in datatype.



CR:476970
CR Number:   476970
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#1 01 10 Dec 2007 Fixed
Description
Terminal security is not working from Direct Connect.



CR:477078
CR Number:   477078
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Aug 2007 Fixed
29 Aug 2007 Fixed
Description
BLKLIB: blk_init() leaks memory when error occurs during the blklib initialization.



CR:477349
CR Number:   477349
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2010 Not a Bug
Description
The EBF number of isql or bcp shows the 32-bit edition after installing SDK15.0 ESD#9.



CR:477638
CR Number:   477638
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Sep 2007 Fixed
19 Oct 2007 Fixed
Description
NETLIB: For the non-threaded libraries, when the child process closes a connection shared between the parent and child, the parent process receives a disconnect error.



CR:477725
CR Number:   477725
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Oct 2007 Fixed
17 Oct 2007 Fixed
Description
DBLIB: One of the memory allocated in dbopen was not freed after use.
Workaround Description
 None



CR:478185
CR Number:   478185
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows 2000
Original Version:   1.7
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Nov 2007 Fixed
06 Jan 2008 Fixed
Description
When executing a group of SQL statements, the results are grouped under a root node, but the user needs to go thru each child node, i.e., individual SQL statements to save and collect the results or result sets in the SQL Results view.



Resolution: Added a context menu in the SQL Results view on the root node of a group of results so that the user can save all sql statements at the same time.



CR:478258
CR Number:   478258
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Nov 2007 Fixed
Description
Refreshing db node took a long time after DDL wizard is called.



CR:478310
CR Number:   478310
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)
15.0 ESD#1 01 10 Dec 2007 Fixed
Description
OCC 12.6 ESD4 is not padding Char field correctly, used to work in 12.5.x, padding with Low-values not Blanks as requested....



CR:478369
CR Number:   478369
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#11 06 Nov 2007 Fixed
12.5.1 ESD#21 14 Dec 2007 Fixed
Description
OLE DB Provider by Sybase: Memory not released after ADODB.Recordset is closed.



CR:478570
CR Number:   478570
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Nov 2007 Fixed
Description
SQL File Editor and SQL Scrapbook connection information field require minor enhancements.



Resolution: Enhanced the usability of the Connection Info. Field in the SQL Scrapbook/File Editor.





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