远程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:420092
CR Number:   420092
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2012 Fixed
Description
Feature request consider increasing the max-rows bcp out can handle (2^31-1 row).



CR:420176
CR Number:   420176
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2007 Fixed
15.0 ESD#8 23 Feb 2007 Fixed
Description
OLE DB Provider by Sybase: Unable to execute queries from Microsoft SQL Server using a Sybase ASE linked server.



CR:420178
CR Number:   420178
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 04 May 2006 Fixed
12.5.1 ESD#14 19 May 2006 Fixed
12.5.1 ESD#14 19 May 2006 Fixed
Description
ODBC Driver by Sybase: SQLGetTypeInfo (SQL_ALL_TYPES) returns no data for subsequent rows after the first, when using SQLGetData.



CR:420271
CR Number:   420271
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#11
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2006 Fixed
01 May 2006 Fixed
Description
ADO.NET: Application connecting to ASE using ADO.NET Data Provider hangs when connection is killed within ASE.



CR:420484
CR Number:   420484
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2006 Fixed
02 Mar 2006 Fixed
03 Jan 2007 Fixed
16 Nov 2006 Fixed
08 Mar 2006 Fixed
10 Mar 2006 Fixed
27 Mar 2006 Fixed
30 Mar 2006 Fixed
Description
NETLIB: A client trying to use Entrust generated server certificate cannot connect to the server. The validation callback exit of a diagnostic program shows: CS_SSL_INVALID_MISSINGNAME. Note that this fix is available on all platforms except Linux AMD64, Solaris x64 and HP Itanium platforms.
Workaround Description
 use environment variable IGNORE_INVALID_CERT but it does not work on windows, logging another CR there.



CR:420505
CR Number:   420505
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 03 May 2006 Fixed
12.5.1 ESD#14 19 May 2006 Fixed
Description
ODBC Driver by Sybase: SQLNativeSql returns SQL_SUCCESS_WITH_INFO incorrectly even when there are no warnings.



CR:420522
CR Number:   420522
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to handle readtimeout from OpenSwitch as SQLWarning.



CR:420570
CR Number:   420570
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2006 Fixed
21 May 2007 Not a Bug
Description
BLKLIB/DEFNCOPY: Using an object name with a right square bracket but without a matching left square bracket will raise a new error message like "Parameter <object> has syntax error."



CR:420734
CR Number:   420734
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 01 May 2006 Fixed
12.5.1 ESD#13 02 May 2006 Fixed
Description
ODBC Driver by Sybase: Driver attributes returned by SQLDrivers do not contain information for "DriverODBCVer" attribute.



CR:420755
CR Number:   420755
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 04 25 Oct 2006 Fixed
Description
SYGWXLAT ends abnormally if USEIBMUNICODE=Y and the code page used is not defined in the OS Unicode definitions.



CR:420768
CR Number:   420768
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 May 2006 Fixed
Description
ODBC Driver by Sybase: ASE datetime datatype supports accuracy upto 1/300th of a second, but the ODBC Driver attempts to return a higher precision fractional second value. Request to have fractional second values exactly match what is returned by ASE.



CR:420976
CR Number:   420976
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 01 May 2006 Fixed
12.5.1 ESD#13 02 May 2006 Fixed
Description
ODBC Driver by Sybase: Unable to access ASE data from MS-Access using ODBC when key column is numeric or decimal datatype. Data is shown as "#Deleted".



CR:421000
CR Number:   421000
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Mar 2006 Fixed
Galaxy 03 Apr 2007 Fixed
Description
SSL: Open Server needs to fail listening while not successfully loading certificate.
Workaround Description
 None known.



CR:421007
CR Number:   421007
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2006 Fixed
22 Mar 2006 Fixed
Description
SSL: With this fix, now all anonymous cipher suite, *_anon_*, has been removed from OCS default cipher suite list. This is used to make SSL connection more secure by enforcing server authentication. If customers want to use anonymous SSL handshake, they need to install it explicitly using ct_con_props(,CS_SET,CS_PROP_SSL_CIPHER,,,) and take the risk without server authertication by their own. Also, now libsybflssl does not allow SSL connection to be continued if it fails in setting customize ciphersuite or trusted.txt.
Workaround Description
 None known.



CR:421026
CR Number:   421026
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 01 May 2006 Fixed
12.5.1 ESD#13 02 May 2006 Fixed
Description
ODBC Driver by Sybase: The ODBC Catalog Functions require the database supplied as the argument to be the same as the current database. For instance if the user is in master and wants a list of tables in the pubs2 database and invokes the SQLTables function, it will fail.



CR:421130
CR Number:   421130
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.15 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#5 19 Dec 2006 Fixed
1.1 ESD#15 21 Dec 2006 Fixed
Description
ADO.NET: The Sybase Interfaces file lookup via use of DSURL syntax expects the "QUERY" keyword in the interfaces file to be in lower case. Lookup fails if the keyword appears in upper case.
Workaround Description
 Edit all entries to be lower case.

(Difficult for big shops!)



CR:421218
CR Number:   421218
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Generic
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Feb 2006 Fixed
22 Feb 2006 Fixed
22 Feb 2006 Fixed
Description
If any RCM config option is specified with more than 255 characters, it used to be truncated silently. The fix allows RCM config options to have upto 4096 characters.



CR:421646
CR Number:   421646
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2006 Fixed
07 Mar 2006 Fixed
Description
DBLIB: On Solaris, Windows and Linux platforms, there is a memory leak in dbopen.



CR:421873
CR Number:   421873
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Feb 2006 Fixed
08 Mar 2006 Fixed
Description
SRVLIB: Bulk copy via Open Server in passthrough mode fails with the following errors:

Msg 5702, Level 10, State 1: ASE is terminating this process.

CTLIB Message: - L0/O0/S0/N0/0/0:

blk_init(): blk layer: CT library error: Failed when CT_Lib routine ct_results() called.



CR:422194
CR Number:   422194
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Apr 2006 Fixed
Description
OLEDB: Problems with SHAPE object.
Workaround Description
 Not known.



CR:422239
CR Number:   422239
Product Name:   ESQL
Product Component:   C
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
cpre -x option disables default ANSI options normally set when not using -x
Workaround Description
 Enable the following options in your ocs.cfg file to

force the application to behave the same as when the

precompiler -x flag is not in use:



CS_CAP_RESPONSE = CS_RES_NOSTRIPBLANKS

CS_EXTRA_INF = CS_TRUE

CS_ANSI_BINDS = CS_TRUE

CS_OPT_ANSINULL = CS_TRUE

CS_OPT_ANSIPERM = CS_TRUE

CS_OPT_STR_RTRUNC = CS_TRUE

CS_OPT_ARITHABORT = CS_FALSE

CS_OPT_TRUNCIGNORE = CS_TRUE

CS_OPT_ARITHIGNORE = CS_FALSE

CS_OPT_ISOLATION = CS_OPT_LEVEL3

CS_OPT_CHAINXACTS = CS_TRUE

CS_OPT_CURCLOSEONXACT = CS_TRUE

CS_OPT_QUOTED_IDENT = CS_TRUE



CR:422264
CR Number:   422264
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Mar 2006 Fixed
03 Mar 2006 Fixed
Description
jConnect: Unable to call setAutoCommit(false) after ending a XA transaction.



CR:422412
CR Number:   422412
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Sep 2007 Fixed
Description
cm_get_value documentation shows cm_rp_set in Syntax section



CR:422413
CR Number:   422413
Product Name:   Organic ODBC Driver
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Buffer overrun when entering more than 80 characters in the properties.



CR:422416
CR Number:   422416
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 07 Apr 2006 Fixed
Description
The installer is stopping on a 150 Information MSG on the FTP part of the install



CR:422440
CR Number:   422440
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 16 May 2006 Fixed
12.5.1 ESD#14 19 May 2006 Fixed
Description
ODBC Driver by Sybase: Unable to use connection information from LDAP Server if sybaseServername defined in the LDAP entry is different from the hostname of the target server and DriverCompletion is set to SQL_DRIVER_COMPLETE.



CR:422518
CR Number:   422518
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#5 10 Jan 2007 Fixed
10 Jan 2007 Fixed
Description
ODBC Driver by Sybase: No support for character set koi8.



CR:422531
CR Number:   422531
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2006 Fixed
19 Mar 2006 Fixed
Description
Customer would like cm_error to format Open Client messages better



CR:422557
CR Number:   422557
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0 28 Feb 2006 Fixed
Description
jConnect: Implement jConnect 6.0 JDBC Driver with support for selected JDBC 3.0 features.



CR:422598
CR Number:   422598
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Mar 2006 Fixed
18 Mar 2006 Fixed
20 Mar 2006 Fixed
Description
Customer would like a OpenSwitch registered procedure call, equivalent of cm_rp_rcm_list to list all of the CMs connected to the OpenSwitch.



CR:422618
CR Number:   422618
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2006 Duplicate
Description
rp_set fails to display/set some configuration parameters with error 20012



CR:422716
CR Number:   422716
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#10 10 Apr 2008 Fixed
Description
OLE DB Provider by Sybase: Request to gracefully handle expired password during connection to ASE.



CR:422718
CR Number:   422718
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#10 10 Apr 2008 Fixed
Description
ADO.NET: Request to gracefully handle expired password during connection to ASE.



CR:422781
CR Number:   422781
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 19 May 2006 Fixed
Description
Test Connect has no Dialog Window - cannot enter connection properties for server, port, login id, password, database. Non-blank passwords on user ids will result in the test connect issuing a message "login failed".



CR:422824
CR Number:   422824
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OCS drivers should be able to resolve other Sybase library function calls independant of the customer options for loading the sybase libraries. Depending on resolution of symbols in the Global Symbol Space assumes no symbol collisions and places un-necessary dependancies on ctlib applications wishing to use our drivers.
Workaround Description
 Force application to dlopen(RTLD_GLOBAL) may not be possible in many environments.



CR:422998
CR Number:   422998
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2006 Fixed
Description
jConnect: Calling Statement.close() on a statement that's already closed results in SQLException. As of JDK 1.4 specifcication, this should be a no-op.



CR:423033
CR Number:   423033
Product Name:   jConnect
Product Component:   Jisql
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Mar 2006 Fixed
Description
jisql: Replace use of JPasswordField class with a Sybase specific class that disables copy text functionality.



CR:423072
CR Number:   423072
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 04 25 Oct 2006 Fixed
Description
Connecting via SNA with IBMUSEUNICODE set to Y and the client charset not matching a SYGWXCPH definition entry causes an abend.
Workaround Description
 In this case just adding the correct code page to the SYGWMCXL macro resloved teh problem.





SYGWMCXL TYPE=ENTRY, *

CHARSET=819,CHARSETBYTES=S, *

CCSID=819,CHARTYPE=A,CHARSIZE=1,PAD=20





Please added it between these entries your SYOSCUST job.

SYGWMCXL TYPE=INITIAL



SYGWMCXL TYPE=FINAL

*



CR:423355
CR Number:   423355
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)
03 May 2006 Duplicate
Description
ODBC Driver By Sybase: SQLGetTypeInfo should return SQL_TYPE_DATE / SQL_TYPE_TIME for DATA_TYPE.



CR:423445
CR Number:   423445
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 23 May 2006 Fixed
12.5.1 ESD#14 19 May 2006 Fixed
Description
ODBC Driver by Sybase: Calling SQLConfigDataSource() to create a DSN always returns FALSE.



CR:423535
CR Number:   423535
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: SQLGetTypeInfo returns incorrect TYPE_NAME for unsigned types. It returns ubigint, uint and usmallint instead of unsigned bigint, unsigned int and unsigned smallint respectively.



CR:423538
CR Number:   423538
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2006 Fixed
27 Apr 2006 Fixed
Description
NETLIB: On Windows, Open Server may appear to stop or defer accepting connections when there are many concurrent connections.
Workaround Description
 Use ctos on Unix.



CR:423549
CR Number:   423549
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Fixed
Description
ODBC Driver by Sybase: SQLColumns returns underlying native datatype name for user defined datatypes.



CR:423551
CR Number:   423551
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2006 Fixed
17 Mar 2006 Fixed
17 Mar 2006 Fixed
Description
jConnect: DatabaseMetaData.getTypeInfo() reutrns incorrect value for TYPE_NAME for unsigned types. It returns ubigint, uint and usmallint instead of unsigned bigint, unsigned int or unsigned smallint.



CR:423713
CR Number:   423713
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 09 Aug 2007 Fixed
Description
jConnect: Feature request to gracefully handle login password expiration policies.



CR:423818
CR Number:   423818
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 19 May 2006 Fixed
12.5.1 ESD#14 19 May 2006 Fixed
Description
OLE DB Provider by Sybase: Cannot access certain OLE DB Provider Connection parameters or properties after setting them. List of parameters and properties: Application Name, WorkStation ID, Current Catalog, Provider Version, Provider Name, Provider Friendly Name, DBMS Version, DBMS Name, WorkStation ID.



CR:423838
CR Number:   423838
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 May 2006 Fixed
Description
TRANLIB: Application using the DTM XA Interface and linked with the non-threaded shared libraries fail to retrieve the XA connection handle.
Workaround Description
 Link the threaded ctlibs and use sybase_TXS_xa_switch if the customer environment permits this. Mostly nonthreaded Tuxedo applications would probably be affected by this bug.



CR:424286
CR Number:   424286
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Mar 2006 Fixed
17 Mar 2006 Fixed
Description
jConnect: If the LANGUAGE connection property is set and localized jConnect messages are available for the language, then display jConnect messages in that language instead of english.



CR:424503
CR Number:   424503
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#3 15 Mar 2006 Duplicate
Description
OLE DB Provider by Sybase: The length of table name, column name input arguments in the MDA stored procedures used by the OLE DB Provider are not long enough to account for names with escape characters like [_].



CR:424737
CR Number:   424737
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 May 2006 Fixed
14 Jun 2006 Fixed
Description
SRVLIB: Server properties SRV_S_LOGFILE and SRV_S_TRUNCATELOG cannot be set after srv_init() is called. On windows, if the application calls CreateProcess then the logfile handle is exported to the new process. This prevents the Open Server from truncating the log.
Workaround Description
 Use the old (depricated open server 2.0) API function srv_config().



- srv_config(NULL, SRV_LOGFILE, "", 0); /* Closes the handle */

- The CreateProcess() call.

- srv_config(NULL, SRV_LOGFILE, "new_filename", CS_NULLTERM);



CR:424835
CR Number:   424835
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)
19 May 2006 Fixed
Description
ODBC Driver by Sybase: The sample applications fail to compile on Linux with `SQLLEN' undeclared error.



CR:424947
CR Number:   424947
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Deferred
07 Apr 2006 Fixed
05 Jul 2006 Fixed
16 May 2006 Fixed
17 May 2006 Fixed
Description
When COORD_MODE is set to AVAIL and CM drops off network, clients are unable to login and may fail even though OpenSwitch and ASE servers are operational.
Workaround Description
 Keep the CM on the same server as the OpenSwitch.



CR:425291
CR Number:   425291
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Apr 2006 Fixed
01 May 2006 Fixed
Description
BLKLIB: blklib should pass error number and severity to its applications when it reports errors.



CR:425331
CR Number:   425331
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   RH Linux
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Mar 2006 Fixed
Description
isql Kerberos login with -V on IBM PSeries Linux fails with error:

$ isql_r -V -SREGTEST15

CT-LIBRARY error:

ct_con_props(SET): security service layer: internal security control layer error: error string not available



CR:425615
CR Number:   425615
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like to know the root cause why OLE DB hangs. The dump files we provided are from the moment OLE DB gets hung



CR:425811
CR Number:   425811
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2007 Fixed
Description
ADO.NET: AseDataReader.GetOrdinal(<column name>) performs case sensitive search even if ASE is setup to be case insensitive.
Workaround Description
 Use ordinal = reader.GetOrdinal("xvarchar") instead.



CR:425968
CR Number:   425968
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Dec 2006 Workaround
Description
ISQLCICS Abends if a LE370 DSA Storage is set to other then NONE.

CEEXOPT STORAGE=((00,NONE,00,0K),OVR) The third Pamater is the issue "dsa_alloc_value"
Workaround Description
 Relink ISQLCICS with a CEEUOPT over ride, belwo is the Jcl that Over rides the storage parm and relink ISQLCICS:

//ASMOPT EXEC PGM=ASMA90,PARM='DECK,NOOBJECT'

//SYSPRINT DD SYSOUT=*

//SYSUT1 DD UNIT=SYSDA,SPACE=(CYL,(1,1))

//SYSUT2 DD UNIT=SYSDA,SPACE=(CYL,(1,1))

//SYSUT3 DD UNIT=SYSDA,SPACE=(CYL,(1,1))

//SYSPUNCH DD DSN=&&OPTOBJ(CEEUOPT),DISP=(,PASS),UNIT=SYSDA,

// SPACE=(TRK,(1,1,1)),

// DCB=(BLKSIZE=3120,LRECL=80,DSORG=PO)

//SYSLIB DD DSN=CEE.SCEEMAC,DISP=SHR

// DD DSN=SYS1.MACLIB,DISP=SHR

//SYSIN DD *

CEEUOPT CSECT

CEEUOPT AMODE ANY

CEEUOPT RMODE ANY

CEEXOPT STORAGE=(NONE,NONE,NONE,0K)

END

//*--------------------------------------------------------------------

//LINKISQL EXEC PGM=HEWL,PARM='MAP,XREF,LIST,RENT,AMODE=31,RMODE=ANY'

//STEPLIB DD DISP=SHR,DSN=CEE.SCEERUN

//SYSLIB DD DISP=SHR,DSN=REL.R126001.CT.CICS.LOADLIB

//CEEOPT DD DISP=(OLD,PASS),DSN=&&OPTOBJ

//SYSLMOD DD DISP=SHR,DSN=CICSTS23.USER.CICSTD.LOADLIB

//SYSPRINT DD SYSOUT=*

//SYSLIN DD *

ORDER DFHELII

INCLUDE SYSLIB(ISQLCICS)

INCLUDE CEEOPT(CEEUOPT)

ENTRY CEESTART

NAME ISQLCICS(R)



CR:426302
CR Number:   426302
Product Name:   Open Client
Product Component:   blklib
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
bcp fails to report an error when attempting to copy an oversized row into ASE
Workaround Description
 Correct the row of data so that it is smaller than the maximum.



CR:426606
CR Number:   426606
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Apr 2006 Fixed
09 Apr 2006 Fixed
Description
ISQL: The column separator (-s) option is not applied to text or image columns.
Workaround Description
 None known.



CR:427043
CR Number:   427043
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Generic
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 May 2006 Fixed
09 May 2006 Fixed
03 May 2006 Fixed
09 May 2006 Fixed
Description
During a failover, when the RCM issues multiple 'switch active' commands to the Replication Server in parallel, not all connections are switched over successfully and the Replication Server hangs.



CR:427126
CR Number:   427126
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.0 ESD#5 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Applications receive "Unsupported parameter type" error when using numeric(20,0) type parameter.
Workaround Description
 None known.



CR:427175
CR Number:   427175
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 May 2006 Fixed
18 Jun 2006 Not reproducible with latest version of the product available as of Resolution Date
07 Mar 2007 Fixed
Description
BLKLIB: An initializing error in Bulk-Library causes Open Server to corrupt data when bcp to columns with default values.
Workaround Description
 CR 427175:

Don't run bcp through Open Servers like OpenSwitch or CTOS



CR:427176
CR Number:   427176
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 May 2006 Diagnostic Provided
Description
Open Server corrupts data when bcp to columns with default values



CR:427201
CR Number:   427201
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2006 Fixed
Description
jConnect: Add support to have multiple open ResultSet objects per statement as defined in JDBC 3.0 specifications.



CR:427244
CR Number:   427244
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   5.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Apr 2006 Not a Bug
05 Oct 2006 Fixed
14 Sep 2006 Third Party Problem
5.5 ESD#22 05 Oct 2006 Fixed
Description
jConnect: Calling DatabaseMetaData.getProcedureColumns when auto-commit mode is off raises SybSQLException: SELECT INTO command not allowed within multi-statement transaction.



CR:427638
CR Number:   427638
Product Name:   Connectivity Utilities
Product Component:   dsedit
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
dsedit on Solaris writes incorrect entries for various Transport types
Workaround Description
 Manually create the TLI style entry.



CR:427937
CR Number:   427937
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 May 2006 Fixed
Description
ODBC: SQLFetch() may hang up if InitializationString of ODBC Connection String has a Sybase command.



CR:428140
CR Number:   428140
Product Name:   Connectivity Utilities
Product Component:   scripts
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2006 Fixed
Description
CTLIB: 'lnsyblibs create' raises error: "libsyb*.s[o: No such file or directory"
Workaround Description
 Delete unnecessary "|" from ls command at line 34 as follows:



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

32 createlinks()

33 {

34 ls libsyb*.s[ol] |\

35 awk '{

36 print "ln -s " $1 " lib" substr($1, 7, length($1) - 6)

37 }' | sh

38 }

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



CR:428168
CR Number:   428168
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#2 11 12 May 2006 Fixed
Description
Add new capabilities to sp_capabilities result for ASE 15 support.



CR:428398
CR Number:   428398
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2006 Fixed
12 Sep 2006 Fixed
28 Jun 2006 Fixed
04 Jul 2006 Fixed
15 Aug 2006 Fixed
22 Aug 2006 Fixed
19 Sep 2006 Fixed
Description
LDAP: LDAP Directory Services requests should have timeouts in case LDAP servers are unreachable or fail in such a way that requests against them never complete in a timely fashion or never complete at all. The LDAP Directory Servers lookups should timeout like the rest of the ct_connect process to prevent application hangs.
Workaround Description
 There is no workaround



CR:428417
CR Number:   428417
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2006 Fixed
26 Apr 2006 Fixed
Description
Open Server: If the CTOS sample program is used with the CT-Lib sample program 'csr_disp'
and the ASE server's version is not 15.0 the CT-Lib sample program fails with a corrupt
TDS token stream.
Target Version
 15.0 ESD#4



CR:428546
CR Number:   428546
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.0 ESD#4 03 May 2006 Fixed
12.5.1 ESD#14 03 May 2006 Fixed
Description
ODBC Driver by Sybase: SQLGetTypeInfo for SQL_TYPE_DATE returns 9 for DATA_TYPE & 91 for DATA_TYPE_2 (SQL_DATA_TYPE). It should return 91 for both values.



CR:428578
CR Number:   428578
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jul 2006 Fixed
07 Jul 2006 Fixed
Description
jConnect: Feature request - Change sp_jdbc_stored_procedures to use intermediate temp tables to reduce duration of shared intent locks on sysprocedures tables.



CR:428696
CR Number:   428696
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 14 Dec 2011 Fixed
12.5.1 ESD#15 14 Dec 2011 Fixed
Description
OLE DB Provider by Sybase: When executing large SQL statement, the connection is timed out 30 seconds after query is executed.



CR:429056
CR Number:   429056
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Calling stored procedure with T-SQL exec syntax & null arguments fails



CR:429151
CR Number:   429151
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
7.0 29 May 2009 Fixed
Description
Request to add newer warnings to list of SQL Exceptions and Warnings



CR:429175
CR Number:   429175
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.5 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Jun 2006 Fixed
12 Jun 2006 Fixed
Description
jConnect: When setNanos() function is used to set nano second values, jConnect may incorrectly report rounding or truncation warnings.



CR:429185
CR Number:   429185
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 01 29 Sep 2006 Fixed
Description
When sp_server_info is called with an attribute parameter, only one row should be returned.



CR:429313
CR Number:   429313
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jul 2006 Fixed
14 Aug 2006 Fixed
Description
CTLIB: When array binding is in use on asynchronous connections, CS_END_DATA completion status is not returned after ct_fetch has fetched all rows of the current result set.
Workaround Description
 Don't use array binding or don't use ASYNC_IO or map CS_QUIET from ct_poll and rowCound < arrayBindSize to CS_END_DATA.



CR:429436
CR Number:   429436
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 09 Jul 2007 Fixed
Description
The list of supported SSL ciphersuites needs to be updated and maintained.
Workaround Description
 N/A



CR:429458
CR Number:   429458
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 22 Dec 2006 Fixed
12.5.1 ESD#15 22 Dec 2006 Fixed
Description
OLE DB Provider by Sybase: Applications are not able to retrieve messages from T-SQL 'print' statements.
Workaround Description
 Customer says that DataDirect works OK - their problem is trying to port the application to OLE-DB by Sybase.



CR:429608
CR Number:   429608
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
aries 07 Apr 2009 Duplicate
Description
Request to support Reporting Services extensions



CR:429884
CR Number:   429884
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jun 2006 Fixed
12 Jun 2006 Not a Bug
Description
jConnect: Calling getInt() and getLong() methods on ResultSet and CallableStatement will throw SQLExceptions if the column/parameter is of type Tds.UINT8.



CR:429933
CR Number:   429933
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Solaris
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ENCRYPT_PASSWORD may result in NULL Pointer exception if you not set charset props.
Workaround Description
 Add property CHARSET to the initial property list prior to connection

It could be any supported charset in Jdbc - list of supported charset values

can be found in Jconnect Programmer's manual.



Example:

props.put ("CHARSET", "iso_1");



This will avoid the Null pointer in java.lang.String.getBytes() exceptipon



CR:429948
CR Number:   429948
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 22 Dec 2006 Fixed
12.5.1 ESD#15 10 Jan 2007 Fixed
Description
OLE DB Provider by Sybase: Accessing the ADODB.Field.Properties.Count gives error "Row handle is invalid" when the RecordSet contains no rows.
Workaround Description
 None known.



CR:430007
CR Number:   430007
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 10 Jan 2007 Fixed
10 Jan 2007 Fixed
Description
ODBC Driver by Sybase: SQLGetData not working with smalldatetime datatype columns when used from Microsoft Access applications.
Workaround Description
 I am trying to get the customer to create a view of the table with samlldatetime and convert the columns to datetime as this seems to work. I do not know if they will apply this at this time.



CR:430140
CR Number:   430140
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: Import from MS Query to Excel causes: "HY021":"[DataDirect][ODBC Sybase Wire Protocol driver]Inconsistent descriptor information." Occurs on SQLExecute() on a parameterized query, involving a smalldatetime data type. The Sybase driver on Windows crashed the application when EnableDescribeParam=1 and OptimizePrepare=0 and the application called SQLPrepare on a select statement that did not contain any parameter markers.



CR:430157
CR Number:   430157
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When attempting to select row which contains binary field and using the select method cursor, OLEDB driver from SDK 12.5.1 EBF13484 ESD #13 gets disconnected from ASE.



CR:430432
CR Number:   430432
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Feb 2008 Not a Bug
Description
blk_done(CS_BLK_BATCH) incorrectly returns CS_FAIL when a batch partially (but not fully) succeeds.
Workaround Description
 Use a 12.5 open client installation to do the bcp operations.



CR:430890
CR Number:   430890
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jun 2007 Fixed
20 Jul 2007 Fixed
09 Oct 2007 Fixed
Description
Security: Windows x86 now has Kerberos support using Windows SSPI interface.
Target Version
 To Be Determined



CR:430893
CR Number:   430893
Product Name:   Organic ODBC Driver
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#6 02 Dec 2013 Fixed
08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: The ODBC Driver may commit unexpected rows in batch insert mode, if a deadlock or other error causes ASE to abort the ongoing tansaction.



CR:431038
CR Number:   431038
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer needs API to retrieve default value of parameter from stored procedure



CR:431071
CR Number:   431071
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 15 May 2006 Duplicate
Description
OLE DB Provider by Sybase: DBSCHEMA_PROVIDER_TYPES Schema Rowset returns incorrect TYPE_NAME for unsigned types. It returns ubigint, uint and usmallint instead of unsigned bigint, unsigned int and unsigned smallint respectively.



CR:431115
CR Number:   431115
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 22 Dec 2006 Fixed
12.5.1 ESD#15 10 Jan 2007 Fixed
Description
OLE DB Provider by Sybase: OLE DB Provider does not pass connection properties "Application Name" nor "WorkStation Id" to the server in the login packet.
Workaround Description
 None known.



CR:431185
CR Number:   431185
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Jan 2007 Fixed
12.5.1 ESD#16 15 Jan 2007 Fixed
12.5.1 ESD#16 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Using a parameter with valueType SQL_C_CHAR representing Date value in a parameterized query on datetime or smalldatetime filed, causes "Invalid conversion" error on SQLExecute.



CR:431363
CR Number:   431363
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Jun 2006 Fixed
05 Jun 2006 Fixed
15 Jun 2006 Fixed
Description
NETLIB: On Windows, if a server is shutdown when there is an existing connection, the same server cannot be restarted until the existing connection becomes inactive.



CR:431381
CR Number:   431381
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   12.6.ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like the installer to save the params, so that they do not have to reenter them evey time.



CR:431394
CR Number:   431394
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 29 Jun 2006 Fixed
16 Jan 2007 Fixed
12.5.1 ESD#15 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Resultset.GetRows VBScript function does not work in ASP page.
Workaround Description
 Use the old OEM Sybase ASE ODBC Driver instead.



CR:431495
CR Number:   431495
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 Jan 2007 Fixed
15 Jan 2007 Fixed
Description
ODBC Driver by Sybase: SQLExecDirect() fails when SQL statement being executed contains "@" sign(s).



CR:431679
CR Number:   431679
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to have getColumnName return value from TDS_ROWFMT2 "Label Name" when using property JCONNECT_VERSION=6 for Wide Table support.





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