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

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 联系我们获取数据库技术支持!
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:613066
CR Number:   613066
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Red Hat Enterprise Linux
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 2 11 Jan 2010 Fixed
Description
ODBC Driver by Sybase : When a command times out the driver returns "connection lost" error leaving stale connection objects in the database.



CR:613491
CR Number:   613491
Product Name:   Open Client
Product Component:   cslib
Status:   Closed
OS:   all
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Jan 2010 Fixed
Description
COMNLIB: Using isql to add a value to a CS_BIGTIME variable results in overflow.



CR:613985
CR Number:   613985
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 18 Aug 2010 Fixed
Description
ADO.NET: When using AseCommandBuilder.GetUpdateCommand() on table that is owned by another user, MissingPrimaryKeyException is thrown.



CR:613995
CR Number:   613995
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.15 ESD#19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 5 17 May 2010 Fixed
Description
ADO.NET: SharePoint application throwing System.InvalidCastException due to thread mode changing from MTA to STA when connections in connection pool are unexpectedly severed.



CR:614585
CR Number:   614585
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Open
OS:   Generic
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2010 Fixed
Description
Redundant RCM won't be started from Secondary OpenSwitch

using rp_rcm_startup() without any arguments or rp_rcm_connect_primary()

after Primary OpenSwitch and its RCM is re-started.
Workaround Description
 Set RCM_SECONDARY = 1 in Secondary OpenSwitch config file



CR:614661
CR Number:   614661
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#22
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2010 Fixed
09 Mar 2010 Fixed
16 Mar 2010 Fixed
Description
SRVLIB: When a client accesses LONGCHAR data columns in an ASE through an Open Server application and the character set of the client is different from that of the Open Server application, the maximum length of the columns may be incorrectly calculated by Open Server.



CR:614973
CR Number:   614973
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#22
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Jul 2010 Fixed
17 May 2010 Fixed
Description
DBLIB: If a dblib application installs an error handle which returns INT_TIMEOUT for a timeout error, the application crashes when a timeout occurs.



CR:615357
CR Number:   615357
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Open
OS:   Generic
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
In the "SQL Results" view, if you are viewing the results in "Display results in single tab"-mode and make one of the columns wider, a horizontal scrollbar will automatically appear at the bottom, hiding/masking the last row without compensating for this by adding a vertical scrollbar.



CR:615365
CR Number:   615365
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Open
OS:   Generic
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhancement request:

Currently you only have the option to Copy/Save/Export/Print the entire result set from the context menu.

Please implement the ability to copy the value of a single cell.



CR:615371
CR Number:   615371
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Open
OS:   Generic
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When changing the Connection profile using the second dropdown in the SQL Scrapbook or the SQL Editor, the previously selected syntax in the editor is lost.



CR:615918
CR Number:   615918
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Generic
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jan 2010 Fixed
Description
In a web-based environment where clients are connected

and disconnected in a continuous fashion, when backend ASE fails for

some reason, clients send a login retry notification to CM application

when OpenSwitch is busy handling the ASE failure which is incorrect.



CR:616185
CR Number:   616185
Product Name:   Open ClientCONNECT for IMS and MVS
Product Component:   Open ClientCONNECT
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 06 24 Mar 2010 Fixed
Description
OCC TCP connection needs to set TCP_NODELAY socket option.



CR:616189
CR Number:   616189
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#21
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLEDB Provider:



MS Linked Server OpenQuery statement containing a where clause in a subclause gives error



select * FROM openquery(ds_link,

'SELECT getdate() as test,

(select max(getdate()) from sysobjects WHERE 1=1 ) as test2

FROM sysobjects WHERE 1=1 ')



Msg 7350, Level 16, State 2, Line 1

Cannot get the column information from OLE DB provider "ASEOLEDB" for linked server "ds_link"



Msg 7357, Level 16, State 2, Line 1

Cannot process the object "

The OLE DB provider "MSDASQL" for linked server "ds_link" indicates that either the object has no columns or the current user does not have permissions on that object.



CR:616421
CR Number:   616421
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2010 Fixed
Description
OpenSwitch doesn't handle new clients establishing at the time when

backend ASE server fails and OpenSwitch is handling the ASE server

failure.



CR:617416
CR Number:   617416
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#21
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Feb 2010 Consult Complete
Description
Customer want to set service name with oledb driver.
Workaround Description
 use ApplicationName property.



CR:617636
CR Number:   617636
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2010 Fixed
Description
ADO.NET, ODBC Driver by Sybase and OLE DB Provider by Sybase: ASE Drivers require larger amount of procedure cache on ASE to update text columns and also encounter occasional drropped ASE connections attempting to update large text columns.



CR:617823
CR Number:   617823
Product Name:   SDK
Product Component:   Java
Status:   Closed
OS:   all
Original Version:   3.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2010 Fixed
19 May 2010 Fixed
Description
CEP Java SDK leaking memory in TuplImpl



CR:617866
CR Number:   617866
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Feb 2010 Fixed
Description
Busy clients are terminated in a mutual aware setup and a HA environment

when the entire ASE HA cluster fails instead of getting deadlock (1205)

errors when CFG_STORAGE is set to 0 in OpenSwitch config file.



CR:618044
CR Number:   618044
Product Name:   SDK
Product Component:   C/C++
Status:   Open
OS:   all
Original Version:   3.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Integration Guide spells C8ErrorGetMessageLength API incorrectly



CR:618218
CR Number:   618218
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   all
Original Version:   3.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Apr 2010 Fixed
20 Apr 2010 Fixed
Description
C8SubscriberGetNextMessage returns C8_ERR_TIMEOUT erroneously
Workaround Description
 - When C8ErrorGetCode() returns C8_ERR_TIMEOUT

--> Check whether it exceeds interval in C8SubscriberGetNextMessage or not

--> If it does NOT exceed the interval, re-run the adapter

--> If it exceeds the interval, stop the input stream



CR:618940
CR Number:   618940
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.0 ESD#22
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Oct 2012 Fixed
Description
CTLIB, DBLIB: ENV to change path to interfaces file (sql.ini) in ctlib, dblib.
Workaround Description
 Thanks to Markus O



just out of curiousity: would the following get what you want:

setenv SYBOCS_CFG $SYBASE/$SYBASE_OCS/ocs_ifile.cfg

ocs_ifile_cfg:

[APPLICATION]

CS_IFILE = /opt/something/example_1/interfaces



[SERVER]

CS_IFILE = /opt/something/example_2/interfaces





Cheers,

Markus



CR:619021
CR Number:   619021
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)
16 Apr 2010 Fixed
15 Apr 2010 Fixed
Description
jConnect: Request to remove SQLWarning objects from the SQLException chain. Added DELETE_WARNINGS_FROM_EXCEPTION_CHAIN connection property to enable this. Enabled by default for jConnect 7.0



CR:619127
CR Number:   619127
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 15 Sep 2010 Diagnostic Provided
Description
ODBC Driver by Sybase:

Linked Server is failing for tinyint fields.
Workaround Description
 WorkAround:

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

No workaround since tinyint is used - they could change to different datatype such as smallint but they have lots of applications and hundreds of tables to change, etc.



CR:619140
CR Number:   619140
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#21
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC Provider:



Delphi connection with ASE using the MSDASQL Provider through ODBC



An access violation occurs when preparing statements like:



'insert into rate(source_code) select :p1 where not exists(select 1 from rate where source_code = :p2)';

'if not exists(select 1 from rate where source_code = :p2) insert into rate(source_code) values(:p1)';

'if not exists(select 1 from rate where source_code = :p2) update set rate source_code = :p1 where source_code = :p2';

'insert into rate(source_code) select :p1 where not exists(select 1 from rate )';



CR:619373
CR Number:   619373
Product Name:   SDK
Product Component:   Java
Status:   Open
OS:   all
Original Version:   3.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Java asynchronous publisher thread can't keep up with input flow
Workaround Description
 In my solution I set some limits, and when the limit is reached, the thread that supplies the messages will be blocked until the space becomes available.



CR:619419
CR Number:   619419
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Feb 2010 Fixed
Description
With RCM, login retry clients fail to connect to the standby ASE server.



CR:619840
CR Number:   619840
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2010 Fixed
22 Mar 2010 Presently Not Targeted For Any Future Release Of This Product
22 Mar 2010 Presently Not Targeted For Any Future Release Of This Product
Description
Update locales.dat to add ja_JP.utf8 to [linux] section and JA_JP.UTF-8 to [aix] section.



CR:619927
CR Number:   619927
Product Name:   Organic OLE DB Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#21
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 3 26 Feb 2010 Fixed
Description
ADO.NET, ODBC Driver by Sybase and OLE DB Provider by Sybase: When a connection request is re-directed by ASE Cluster Edition, sockets are left in CLOSE_WAIT state.
Workaround Description
 WorkAround:

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

None - when sockets fill up the windows socket list, the App server is non-functional.

Server needs to be restarted to clear out the CLOSE_WAIT sockets.



CR:620037
CR Number:   620037
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
setAddressList and getAddressList are the new functions to SybConnectionPoolDataSource

interface. However, there is no corresponding document and in JConnect's Programmer

Reference. The only description occurs in javadocs of SybDataSource but it is far not

enough for Java developer, especially it is key feature for JConnect to support ASE CE.

Also there is no sample code bundled with the JConnect 6.05 / 7.0 package to demo the feature.



CR:620134
CR Number:   620134
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.5 ESD 2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 5 26 May 2010 Fixed
Description
ODBC Driver by Sybase: Call to sp_odbc_getprocedurecolumns returning NULL for DATA_TYPE_column when the stored procedure has a numeric parameter.
Workaround Description
 Within the stored procedure sp_odbc_getprocedurecolumns, there are 2 primary logic paths, one with no pattern matching done on the table name and another with pattern matching done on the table name. With regards to the numeric parameter not working, the customer simply copied the 'no pattern' code to the 'pattern' section so that they would match. The section of code that is copied is:



/* Copied from the "no pattern" block */

d.data_type+convert(smallint,

isnull(d.aux, ascii(substring("666AAA@@@CB??GG",

2*(d.ss_dtype%35+1)+2-8/c.length,1)) -60))



The above 3 lines replace:



convert(smallint,ascii(substring("8;<9<H<<<<<:<=6<5<A<?<@<GC?GD",

t.type%34+1,1))-60)



*** Tuesday, March 16, 2010 04:23:08 PM *** pvero ***

Another alternative is to hardcode the type info in the same area of the proc:



when t.name = "numeric"

then convert(smallint,2)

when t.name = "decimal"

then convert(smallint,3)



CR:620147
CR Number:   620147
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Feb 2010 Fixed
Description
In a Primary ASE network failure case with RCM, existing OLTP

clients hang and fail to connect to the Secondary/standby ASE.



CR:620247
CR Number:   620247
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#20
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 5 07 May 2010 Fixed
Description
OLE DB Provider by Sybase: Windows ADO client receiving wrong results for decimal types when precision for the number exceeds precision supported by ADO.
Workaround Description
 While workarounds have been suggested, such as explicitly defining the type of the returned result. These workarounds are not suitable for the client:



CR:620808
CR Number:   620808
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 07 14 Apr 2010 Fixed
Description
MFC Server Option does not process the TDS_OPTIONCMD token for a gatewayless connection.
Workaround Description
 Customer removed the CT_OPTION call from there CT-LIB application



CR:620831
CR Number:   620831
Product Name:   SDK
Product Component:   Java
Status:   Open
OS:   all
Original Version:   3.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Java c8-sdk-java5.jar contains com.coral8



CR:620832
CR Number:   620832
Product Name:   SDK
Product Component:   Java
Status:   Open
OS:   all
Original Version:   3.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
pom.xml provided with Java SDK is for appl. using SDK, not for the SDK itself.



CR:621429
CR Number:   621429
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   15.0 ESD#22
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Mar 2010 Fixed
26 Apr 2010 Fixed
Description
NETLIB: With the UNIX threaded libraries, the SIGCHLD handler may not be invoked when a child process terminates.



CR:621450
CR Number:   621450
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2010 Fixed
Description
ADO.NET: Memory leak if the AseCommand object disposed before the AseDataReader object.



CR:622465
CR Number:   622465
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   all
Original Version:   aries
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Apr 2010 Fixed
Description
ADO.NET, ODBC Driver by Sybase and OLE DB Provider by Sybase: Request to add ESD number to the TDS login record's program version field.



CR:622518
CR Number:   622518
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   RH
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2010 Not a Bug
Description
RPC is not passing correct value to the webservice procedure



CR:622884
CR Number:   622884
Product Name:   SDK
Product Component:   other
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
Description
ODBC Driver "Sybase CEP Public Windows" fails to connect

when using the link/import table features from Access and Excel



CR:623464
CR Number:   623464
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jun 2010 Fixed
Description
ADO.NET: Unable to connect to Adaptive Server using encrypted password.



CR:623551
CR Number:   623551
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Apr 2010 Fixed
06 Apr 2010 Fixed
Description
MDA stored procedure sp_jdbc_getxacoordinator doesn't work properly on SDC with multiple instances



CR:623611
CR Number:   623611
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2010 Fixed
Description
ADO.NET: Applications compiled with older provider releases do not work with latest provider due to issues with the policy files.
Workaround Description
 WorkAround:

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

Manually change the policy file



CR:623631
CR Number:   623631
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2010 Duplicate
Description
ADO.NET: The ADO.NET Provider policy files shipped with 15.5 versions do not redirect applications built with SDK 15.0 versions of the provider.



CR:623792
CR Number:   623792
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2010 Duplicate
Description
When Visual Basic ADO application explicitly sets CommandTimeout=0 on Command object, ODBC Driver doesn't set a timeout. The result is the driver internally sets the timeout to 180 seconds. This is resolved in 15.5 releases.



CR:623804
CR Number:   623804
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#19
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jun 2010 Duplicate
Description
ODBC Driver by Sybase: When Visual Basic ADO application explicitly sets CommandTimeout=0 (infinite) on Command object, ODBC Driver still times out in 180 seconds.
Workaround Description
 WorkAround:

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

Set CommandTimeout to high value such as 1800 or more



CR:624012
CR Number:   624012
Product Name:   Open Client-Doc
Product Component:   Supplement
Status:   Closed
OS:   all
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Mar 2014 Fixed
Description
The "Open Client and Open Server Programmers Supplement for UNIX", section "Compile-and-link lines" needs to be rectified for 64bit modes.



CR:624199
CR Number:   624199
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   Solaris 10
Original Version:   4.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
Description
Unable to run CEP applications compiled on Sun x86 with Sun's CC compiler. If

the server is down or an unused port is given in the URI, the application crashes in

c8::Mux2Socket_Connection::Connect.
Workaround Description
 Use the gcc compiler.



CR:624257
CR Number:   624257
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2010 Fixed
Description
Link errors like "unresolved external symbol: cm_get_server_status"

is seen when compiling CM1 sample on Windows.



CR:624340
CR Number:   624340
Product Name:   Open Client
Product Component:   blklib
Status:   Open
OS:   all
Original Version:   15.5 ESD 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
This CR covers the request to provide a more descriptive error when bcp in determines that

a row is too large for a single page. Currently if this condition is true at the point of

building the row in preparation for the insert, we will just return 'bcp copy in failed'

or 'bcp copy in partially failed'



CR:624402
CR Number:   624402
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Apr 2010 Fixed
Description
ADO.NET: When a thread running a long query is killed, Client intermittently receives Internal Error: 30016 in AseDataReader.
Workaround Description
 Customer unable to back out of ESD#03 since it contains fixes for them and we're pushing them off the ASE OLE DB Provider.



CR:624561
CR Number:   624561
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2010 Fixed
16 Apr 2010 Fixed
Description
jConnect: Request to add ESD version information in the TDS login packets program version field.



CR:624804
CR Number:   624804
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#21
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 5 17 Jun 2010 Fixed
17 Jun 2010 Fixed
Description
ADO.NET: Request to hide the password value from the Connection String.



CR:625022
CR Number:   625022
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 8 02 Dec 2010 Fixed
Description
ODBC Driver by Sybase: Improper handling of DateTimeResults when BackendType is DB2.
Workaround Description
 WorkAround:

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

InitializationString will resolve, but IF the DC Server has the value set globally, and client isn't setting this in InitializationString there is no change in behavior - that is the error reported in CR 584504 still occurs.



CR:625222
CR Number:   625222
Product Name:   Connectivity Utilities
Product Component:   dsedit
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2010 Fixed
21 Nov 2010 Fixed
Description
DSEDIT: On first screen, dsedit shows wrong LDAP configuration file path.



CR:625517
CR Number:   625517
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2010 Fixed
Description
Enable CS_BIGDATETIME and CS_BIGTIME capabilities

by linking with OCS 15.5 libraries.



CR:625778
CR Number:   625778
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 08 20 Apr 2010 Fixed
Description
CICS Socket listener is

Starting Transactions uses the Default Prefix of "DF", for TSQ's.



CR:625942
CR Number:   625942
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 09 08 Jun 2010 Fixed
Description
Gateway handler now Checks to See if CICS Autoinstall is active before it issue a CICS INQ Program.



CR:626113
CR Number:   626113
Product Name:   Organic ODBC Driver
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows Vista
Original Version:   15.5 ESD 3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2010 Bundled Request
Description
Unable to install directories with spaces in the name, on the Windows operating system
Workaround Description
 WorkAround:

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

Windows still supports use of the short name syntax for directory names, for the non-8dot3

file and directory names (such as "C:\Program Files"). If you start at C:\ and execute dir /X

you'll notice an alternative name for "Program Files":



PROGRA~1 Program Files



Simply use this name in place of "Program Files""



"C:\PROGA~1\Sybase"



and the installation will proceed and complete successfully.



CR:626305
CR Number:   626305
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2010 Fixed
20 May 2010 Fixed
27 Sep 2011 Presently Not Targeted For Any Future Release Of This Product
Description
Starting from 15.5 ESD #4, the TDS login packet now includes the ESD#.



CR:626472
CR Number:   626472
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2010 Fixed
Description
Client connections might linger and hang inside OpenSwitch

when the query response timeout happens.



CR:626479
CR Number:   626479
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 15 Sep 2010 Fixed
Description
ODBC Driver by Sybase: AdoNet2ManualTests did fail due to environment changes.



CR:626763
CR Number:   626763
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Aug 2010 Duplicate
Description
Need the ServerType property of the connection to be documented.



CR:626765
CR Number:   626765
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Implement extended ASCII charachters as row delimiters in BCP



CR:627067
CR Number:   627067
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#24
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2010 Not a Bug
Description
sp_oledb_primarykey can create a plan that have X worktables
Workaround Description
 Use a AP that force the plan you like.



CR:627242
CR Number:   627242
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#22
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2010 Not reproducible with latest version of the product available as of Resolution Date
Description
jConnect: Error 4837 thrown with ENABLE_BULK_LOAD = true



CR:627244
CR Number:   627244
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2010 Duplicate
Description
jconnect: Error 4837 thrown with ENABLE_BULK_LOAD = true



com.sybase.jdbc3.jdbc.SybSQLException: Bad row data received from the client while bulk

copying into object 969051457 partition 969051457 in database 5.

Received a row of length 4108 whilst maximum or expected row length is 17.



CR:627267
CR Number:   627267
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   RH
Original Version:   3.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Apr 2010 Not a Bug
Description
Unable to send large BLOB values through CEP



CR:627422
CR Number:   627422
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Windows 2000
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Aug 2010 Fixed
Description
When OpenSwitch is installed on Windows with

directory containing spaces in it,

OpenSwitch's standalone configurator

utility %OPENSWITCH%\CFG-1_0\bin\oswcfg.bat exits with the error similar to



Exception in thread "main" java.lang.NoClassDefFoundError: Files\osw\OpenSwitch-

15_1\CFG-1_0\lib\cfggui/jar;C:\Program



CR:627489
CR Number:   627489
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   15.5 ESD 2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2010 Fixed
20 May 2010 Fixed
Description
jConnect: Pooled SybConnectionProxy receiving JZ0C0: Connection is already closed error.



CR:627532
CR Number:   627532
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 May 2010 Fixed
12 May 2010 Fixed
Description
jConnect: Statement.getUpdateCount() not returning correct count with specific sql batch.
Workaround Description
 Current workaround is to use an earlier version of JConnect 6.0.5.



CR:627899
CR Number:   627899
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 12 Aug 2010 Fixed
Description
ODBC Driver by Sybase: Heap corruption in odbc driver when running MFC application.
Workaround Description
 WorkAround:

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

In the SmartStoredProcedure project, under Project | Properties change the C/C++ Preprocessor Definitions for NDEBUG to _DEBUG. This seems to eliminate the problem, but is not the ultimate resolution since this was working okay on previous builds.



CR:627973
CR Number:   627973
Product Name:   SDK
Product Component:   other
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   4.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jun 2010 Fixed
Description
RTD Adapter for Excel cannot connect to an SSL enabled server



CR:628005
CR Number:   628005
Product Name:   SDK
Product Component:   C/C++
Status:   Open
OS:   RH
Original Version:   3.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
Publishing messages with BLOB data fails very frequently



CR:628238
CR Number:   628238
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When sending a For Update statement in a cursor via version 15 ODBC driver it results in

DIAG [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]FOR UPDATE can not be used in a SELECT which is not part of the declaration of a cursor or which is not inside a stored procedure. (7305)



It works in previous non organic driver (ie. version 03.11.0000).



CR:628321
CR Number:   628321
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#24
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2010 Fixed
26 May 2010 Fixed
Description
ISQL: Password encryption reports error when password length is 30 characters.



CR:628445
CR Number:   628445
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#20
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 May 2010 Fixed
Description
OLE DB Provider by Sybase:

OLEDB should be able to return to VB clients correct decimal values upto the precision that VB can deal with.



CR:628447
CR Number:   628447
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 3 07 May 2010 Fixed
Description
ODBC Driver by Sybase:Charset radiobutton was not saving its state.



CR:628722
CR Number:   628722
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 11 30 Jul 2010 Fixed
Description
SYBLSTNR abends with code AEIP on the CICS Set FIle (EZACONFIG) command.



CR:628753
CR Number:   628753
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.7 SP110 03 Jun 2013 Fixed
Description
ADO.NET: Unable to Cancel active result set on separate thread. Requesting implementation of cancel capability on active result set(s).
Workaround Description
 WorkAround:

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

Using Cursor alleviates some of the problem as it stops the cursor fetch. However, our customer is unable to use this

as they don't want to use cursors on the ASE side. Also, this feature would stop a lot of unstability issues related to Reader Exceptions, etc in that

the cancel option would be able to stop the result set stream and then internally clean things up nicely.



CR:628946
CR Number:   628946
Product Name:   SDK
Product Component:   C/C++
Status:   Closed
OS:   Solaris 10
Original Version:   4.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Nov 2013 Presently Not Targeted For Any Future Release Of This Product
Description
SDK i18n c8_sdk_examples.properties file is located in the wrong directory
Workaround Description
 Copy the sdk/c/examples/i18n/en_US/c8_sdk_examples.properties file to the

$C8_LANG_DIR/$C8_LANG directory.



CR:629011
CR Number:   629011
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.5 ESD 2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Aug 2010 Fixed
17 Aug 2010 Fixed
Description
CTLIB: Segmentation fault occurs and a core file is generated when the ct_param() api call is used with the varchar paramter data setting to NULL and the data length setting to 0.
Workaround Description
 Use CS_CHAR_TYPE instead of CS_VARCHAR_TYPE.



CR:629063
CR Number:   629063
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 03 Aug 2010 Fixed
Description
ADO.NET: Internal Error and other Exceptions when canceling command.
Workaround Description
 WorkAround:

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

If using Cursor things stabilze a bit (Customer is not considering this setting) but you can get:



C:\Debug>CR628753 -CancelThreadMin:3 -CancelThreadMax:8

CR628753 (Build: 12/31/1600 5:00 PM)

Run Time: 30 minutes

Cancel Time Range: 3-8 seconds

Using Transaction: False

Enlist: True

Pooling: True

server=pvero-rhel5;port=1503;uid=sa;pwd=;database=portal;Connection Lifetime=90;Min Pool=100;Max Pool=150;Pooling=true;PacketSize=4096;AnsiNull=1;ClearAllPools=

120;Enlist=0;UseCursor=1;

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

Cancel Thread in 3986 ms

.Count: 1000

Cancel completed



00:00:04.0175066

PASSED!

F

Sybase.Data.AseClient.AseException: Resultset is dead.

at Sybase.Data.AseClient1.AseDataReader.Read()

at Sybase.Data.AseClient.AseDataReader.Read()

at CR628753.Program.ExecuteAndReadResults()

at CR628753.Program.GetData()



CR:629072
CR Number:   629072
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   NA
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Feb 2013 Insufficient priority to fix
Description
The customer has many tables with many columns and finds it tedious to create a format table interactively, continuously hitting carriage return.



The customer's request is to add an option to the bcp utility that will automatically read the table format and create a default format file. Then the customer would just have to modify via a text editor those specific columns that need values other than default.



e.g. bcp pubs2..titles -Usa -P -create_format_file <filename>



This would reduce the overall work and tedium needed to create format files.



CR:629213
CR Number:   629213
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 02 Sep 2010 Fixed
Description
OLE DB Provider by Sybase: Setting enableserverpacketsize=true or false has no affect and packet size specified in the SOD file not used when this is set to false.
Workaround Description
 WorkAround:

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

If manually setting the values to 1|0|blank, then the feature works okay. But if the property is somehow set again, the value is result to true.



CR:629214
CR Number:   629214
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2010 Fixed
02 Jun 2010 Fixed
Description
jConnect: Receive XAException during SybXAResource.start due to Adaptive Server error 3933.



CR:629462
CR Number:   629462
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 28 Jun 2010 Fixed
Description
ODBC Driver by Sybase: MFC application cannot insert large image data.
Workaround Description
 WorkAround:

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

NONE - customer has to remain on DDTEK (OEM) Driver.



CR:629521
CR Number:   629521
Product Name:   Connectivity Utilities
Product Component:   dsedit
Status:   Closed
OS:   Linux
Original Version:   bharani
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Jul 2010 Fixed
25 Jan 2011 Fixed
Description
UNIX dsedit does not support space characters in path/file name



CR:629565
CR Number:   629565
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   NA
Original Version:   15.0 ESD#23
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2010 Fixed
24 Jun 2010 Fixed
Description
BCP: bcp exit with 0 instead of 255 when bcp in partially failed.



CR:629649
CR Number:   629649
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2010 Fixed
29 Sep 2010 Fixed
Description
Update locales.dat to add ja_JP.UTF-8 to [linux] section.



CR:629858
CR Number:   629858
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Aug 2010 Fixed
16 Sep 2010 Fixed
Description
On a windows machine without Microsoft Visual C++ 2005 installed, debug mode binaries and dlls might fail. The application event log has SideBySide errors like: Activation context generation failed for <the name for the binary or dll>. Dependent Assembly Microsoft.VC80.DebugCRT,processorArchitecture="x86",publicKeyToken="1fc8b3b9a1e18e3b",type="win32",version="8.0.50608.0" could not be found. Please use sxstrace.exe for detailed diagnosis.



CR:629863
CR Number:   629863
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2010 Fixed
29 Sep 2010 Duplicate
Description
LDAP for Directory Services is not working. LDAP libtcl.cfg is not used. Reverts to sql.ini.



CR:630102
CR Number:   630102
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Jun 2010 Fixed
Description
When a client application sends a language command

with parameters greater than 1024 to OpenSwitch, the

gateway server might fail with an error message

"srvlib_error: Invalid item number(1025)"



CR:630355
CR Number:   630355
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
MFC Client Option needs to support KERBEROS Secuirty



CR:630883
CR Number:   630883
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 28 Jun 2010 Fixed
Description
ODBC Driver by Sybase: MFC application cannot update rowset when where clause is not specified.
Workaround Description
 WorkAround:

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

There is no apparent workaround for this problem.



CR:630902
CR Number:   630902
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 26 Aug 2010 Fixed
Description
ODBC Driver by Sybase: MS Excel application fails on connection when getting external data
Workaround Description
 WorkAround:

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

PSE made change in sp_odbc_tables script to get around the problem:



/*

** Special feature #1: enumerate databases when owner and name

** are blank but qualifier is explicitly '%'.

*/

/****if @table_qualifier = '%' and

@table_owner = '' and

@table_name = ''****/

/* 05-28-10 Pvero - we pass null when Excel passes empty string */

if (@table_qualifier = '%' and

((@table_owner = null and

@table_name = null) or

(@table_owner = '' and

@table_name = '')) )



begin



CR:631106
CR Number:   631106
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   all
Original Version:   15.5 ESD 6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.5 ESD 7 14 Sep 2010 Fixed
Description
ODBC Driver by Sybase: Request to automate the ESD number in the Tds Login packet.



CR:631143
CR Number:   631143
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Jun 2010 Fixed
Description
jConnect: The DatabaseMetaData.getJDBCMajorVersion() method returns 3 instead of 4.



CR:631267
CR Number:   631267
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jun 2010 Fixed
Description
ODBC Driver by Sybase: Truncation occurs when retrieving data with SQLGetData on character string with embedded NULL (0x00).
Workaround Description
 WorkAround:

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

Only workaround is to use SDK 15.0 Drivers.



CR:631284
CR Number:   631284
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.5 ESD 4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Data Source under UDL only displays OEM properties



Detail: Some applications use UDLs for connections to databases. In our case, when we create UDL using our OLE DB Provider, we can't set our own properties in the facility provided (see repro for the details). All DataDirect OEM Properties show-up in the display. We'd like it so only our properties are displayed.
Workaround Description
 WorkAround:

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

Use Extended Properties.





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

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

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

Sybase SQL Anywhere数据库恢复工具ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具
  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x,16.x,17.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集,包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

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

各种误操作:

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

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

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page
7、*** ERROR *** Assertion failed: 201417 (7.0.4.3541) Invalid count or free space offset detected on a table page
8、Internal database error *** ERROR *** Assertion failed: 201425 (8.0.3.5594) Invalid count or free space offset detected on a free list page -- transaction rolled back.
9、Internal database error *** ERROR *** Assertion failed: 100702 (8.0.1.2600) Unable to modify indexes for a row referenced in rollback log -- transaction rolled back


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

Sybase ASE数据库恢复工具READSYBDEVICE:

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

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

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

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

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


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

SQL Server数据库恢复工具SQLRescue:

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

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

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

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

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

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

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